Unable to query user_list.name from AUDIENCE_PERFORMANCE_REPORT (campaign_audience_view)

[Rahul Kumar]

Hi Team,

When querying the campaign_audience_view, I am getting the following error:

"Cannot select fields from the following resource: 'USER_LIST', since the resource is incompatible with the resource in FROM clause."

My Query is:

"SELECT segments.date,customer.descriptive_name,ad_group.campaign,campaign.name,campaign.status,ad_group.id,ad_group.name,metrics.clicks,metrics.conversions,metrics.conversions_value,metrics.cost_micros,metrics.impressions,metrics.all_conversions,metrics.all_conversions_value,user_list.name from ad_group_audience_view WHERE campaign.status IN ( ENABLED,PAUSED,REMOVED ) AND segments.date >= \'2019-06-16\' AND segments.date <= \'2019-06-18\'"

I understand the meaning of the error. What I don't understand is that the field (user_list.name) is mentioned in the docs (https://developers.google.com/google-ads/api/docs/migration/reports#audience_performance) so it should be available in this resource. Please help.

Thanks,

Rahul

[Jamie]

I'm also having this problem.

I have tried downloading all the user lists and matching up along their IDs, but the Campaign Audience View and Ad Group Audience View fields only provide a "Criterion ID" and I am unsure what this relates to. 

[Google Ads API Forum Advisor Prod]

Hello Rahul and Jamie,

Since user_list.name  can only be fetched via user_list resource but not via Ad Group Audience View and Campaign Audience View resource. You will be only able to fetch the data from resources that are shown in the Selectable With section of those resources.

Alternatively, you an use the criterion_id's from those resources and can match them with the user_list.id fields in another query. Please let me know if you have any further questions.

Regards,
Sai Teja, Google Ads API Team

ref:_00D1U1174p._5001UBnv45:ref

[Jamie]

I just found the same, thanks much Sai! 

[Rahul Kumar]

Hi Sai,

I have a few questions. If it is not selectable from Ad Group Audience View and Campaign Audience View and then why is it mentioned under them. You can check this here:

https://developers.google.com/google-ads/api/docs/migration/reports#audience_performance

As far as I understand, if a field is mentioned under a particular resource then we can query for that field from the same resource. I do understand that there are restrictions on the combination of fields that can be queried together, but if someone just wants to query a single field of the resource, then it should be allowed.

E.g "SELECT user_list.name from ad_group_audience_view WHERE campaign.status IN ( ENABLED,PAUSED,REMOVED ) AND segments.date >= \'2019-06-17\' AND segments.date <= \'2019-06-19\'" should be allowed.

Please let me know if I am missing something.

Thanks,

Rahul

[Google Ads API Forum Advisor Prod]

Hello Rahul,

According to the report migration guide you have shared for the the equivalent field to UserListName field in AdWords API is user_list.name. Here user_list is a separate resource and since it is not in the selectable with list of either Ad Group Audience View or Campaign Audience View resources, you are unable to fetch the field:user_list.name in the same search Query.

If you want user_list.name field then you have to pull that field form the resource user_list separately, but not via Ad Group Audience View or Campaign Audience View resources. You could use the alternative mentioned earlier by using  criterion_id's instead.

[Rahul Kumar]

Hello Sai,

Thanks for the information. So as I understand, the mappings mentioned in the Google Ads migration docs doesn't guarantee that it will be fetchable from the given resource ( campaign_audience_view or ad_group_audience_view in my case).

However, this creates a problem for us while migrating ( And I am sure it will  be a problem for many others also) because earlier we used to have the fields and the resource name stored in the database and our script would automatically call the API to get the data from the report.  This was possible because all the fields in a given report could be fetched using a single API call to the respective report or service (E.g AUDIENCE_PERFORMANCE_REPORT OR CampaignService). Now there is no way to generate a query using a script because the fields are scattered across different resources.

So this is a request from my side to kindly look into this and if possible suggest a way or add a feature request which allows us to migrate the older reports without breaking existing functionality.

Thanks,

Rahul

Thanks,

Rahul

[Google Ads API Forum Advisor Prod]

Hello Rahul,

I will create a feature request for this and update my team on your concern. Meanwhile you could keep an eye on our blog and release notes to see the upcoming releases and features.