Shared List data mismatch between Google Ads UI and API

[Oliver]

Hi Google team,

We noticed an issue that is happening in few different accounts.  We're using Google Ads API v8.

We use the following query to retrieve which negative keyword lists (shared sets) are associated with which campaign: 

SELECT campaign.id, shared_set.name, shared_set.id FROM campaign_shared_set WHERE campaign.id IN (12531200580) AND shared_set.type IN ('NEGATIVE_KEYWORDS') AND campaign_shared_set.status IN ('ENABLED')

 

In some accounts, the info returned has a slight mismatch.  For example, in Account ID:  1591967311, the API data indicates that Shared Set ID  7677837490 is linked/associated with campaign ID 12531200580.  However, the Google UI data doesn't show such a relationship.

When we revert back to the Adwords API, the data returned matches exactly the UI.  Only the Google Ads API returns different data.

The above mismatch is happening in few other accounts.  We gave only one example above.

Any ideas what is going on?

Oliver

[Google Ads API Forum Advisor]

Hi Oliver,

I ran your query and didn't get Shared Set ID  7677837490. Could you recheck?

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2NThdc:ref

[Oliver]

Hi Aryeh,

Apologies, I actually gave you the version of the query that works.  We were testing various ways to get this data and the below version of the query (where we specify the Shared Set ID instead of specifying the campaign ID) is the one that doesn't work.

The below query returns an association between shared set ID 7677837490  and campaign ID 12531200580:

SELECT campaign.id, shared_set.name, shared_set.id FROM campaign_shared_set WHERE shared_set.id IN (7677837490)

We will use the first version we mentioned in the previous post.  However, there is clearly an inconsistency in the data served by the API.

Regards

Oliver 

[Google Ads API Forum Advisor]

Hi Oliver,

I work with Aryeh and let me provide support to your concern.

To further investigate the issue, could you provide the complete request and response logs, with the request ID and the returned values for each field, generated on your end where we can see the association between shared set ID 7677837490  and campaign ID 12531200580?

You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2NThdc:ref