(Google Ads API) AdGroup Audience view returns no data

[the...@funnel.io]

Hi, we are trying to set up an audience view report using GAQL and our queries return no data for intervals that should have data according to other report types. For example:

This returns plenty of data:
SELECT segments.date, metrics.clicks, metrics.cost_micros, metrics.impressions FROM ad_group WHERE segments.date BETWEEN '2019-01-01' AND '2019-12-31'

This return nothing:

SELECT segments.date, metrics.clicks, metrics.cost_micros, metrics.impressions FROM ad_group_audience_view WHERE segments.date BETWEEN '2019-01-01' AND '2019-12-31'

But these should be equivalent for these fields, correct?

[Google Ads API Forum Advisor Prod]

Hi Theo,

Can you please provide me your CID through reply privately to author so I can take a closer look?

Thanks,
Anthony
Google Ads API Team

ref:_00D1U1174p._5004Q23Jc2b:ref

[david...@funnel.io]

Hi,

We are getting two types of criteria prefixes from Adwords, boomuserlist and uservertical. When querying from Google ADS however, we can get boomuserlist by calling the user_list resource. But from where can we get the uservertical criteria prefix? Sorry if this question makes no sense, all of this is a but unclear to us. Is there any place where we can read up on how these things tie together. 

BR

David @ Funnel

[Google Ads API Forum Advisor Prod]

Hi David,

You can have a look at the migration guide to see what fields from AdWords API map to Google Ads API. For verticals, you will want to run a report under ad_group_criterion since VerticalId maps to ad_group_criterion.topic.topic_constant.

Regards,

[the...@funnel.io]

Hi,

Our aim here is just to see data broken down by Audience, as it appears in the Google ads UI.

When querying "Criteria" from an AudiencePerformanceReport in the Adwords API, we get a list of id's from audiences, like this:
boomuserlist::12345
uservertical::6789
...
We can then map these to audience names by using services such as AdwordsUserListService. This works well enough.

But we can't get anything working for the Google Ads API. Campaign_Audience_View only give a small subset of the Audiences we see in the UI, there's no data when using Ad_group_audience_view, and  ad_group_criterion.topic.topic_constant gives no values either. We're at bit of a loss for what to do here. 

Regards,
Theo @ Funnel

[Google Ads API Forum Advisor Prod]

Hi Theo,

You can run the UserListService in Google Ads API to get all of your audiences since this is the migrated service of the AdWordsUserListService in AdWords API. 

Let me know if there are any issues.

Cheers,

[cv]

Hello,

I think Adgroup Audience View must provide data, as get service is expensive in Adwords API beta. It has limited usage.

Please let me know the reason why adwords_audience_view can't give data?

Thanks,

[Google Ads API Forum Advisor Prod]

Hello,

The ad_group_audience_view reflects the Audiences tab in the Google Ads UI. It will show audiences that are targeted from the ad group level. If you are not seeing any results, please provide me more details.

Regards,

[cv]

Hello Anthony,

If I am using ad_group_audience_view with refrence to UI for that I need details of user list as well to get all the data.

This below query will give me empty response, where as in UI there is 4 Audiences are there at adgroup level in UI.

SELECT
                            campaign.name,
                            campaign.id,
                            ad_group.name,
                            ad_group_audience_view.resource_name,
                            ad_group.targeting_setting.target_restrictions,
                            ad_group_criterion.user_list.user_list,
                            ad_group_criterion.type,
                            user_list.type,
                            user_list.resource_name,
                            user_list.name,
                            user_list.description,
                            user_list.id,
                            user_list.eligible_for_display,
                            user_list.eligible_for_search,
                            user_list.integration_code,
                            user_list.membership_status
                           
                        FROM
                            ad_group_audience_view
                        WHERE
                            campaign.id IN (254431837)

Thanks,

[david...@funnel.io]

Hi,

We've been doing some more experimenting with this and what we do now is first to run a query like this:

SELECT

    campaign.name,

    campaign_criterion.criterion_id,

    segments.date,

    metrics.clicks,

    metrics.cost_micros,

    metrics.impressions

FROM

    campaign_audience_view

WHERE

    segments.date BETWEEN '2019-01-01' AND '2020-08-01'

After that we run a query like this:

SELECT

    topic_constant.path,

    user_list.name,

    user_interest.name,

    campaign_criterion.criterion_id

FROM

    campaign_criterion

We will then use to response from the second query to create a mapping table between campaign_criterion.criterion_id and audience where audience is either user_list.name or user_interest.name or topic_constant.path depending on which of those columns have a value that maps to a criterion_id. We can then merge our two results and we get what we want. Sort of..

The problem is still that this results is not 1 to 1 regarding audiences compared to The Adwords API or the Google Ads UI. We've seen cases where:

• We get the audience in the Google Ads UI and Adwords API but not Google Ads API.
• We get the audience in the Google Ads API and Adwords API but not the Google Ads UI.
• We can only get the audience in the Google Ads UI.

We're out of ideas. Please advise on how to continue with this. The UserListService is not really an alternative since it will only take one resource_name at a time and not a list of ids like in Adwords.

BR

David @ Funnel

[Google Ads API Forum Advisor Prod]

Hi David,

Can you please provide me with your client customer ID through reply privately to author so that I can take a closer look?

Thanks,

Anthony
Google Ads API Team

ref:_00D1U1174p._5004Q23Jc2b:ref

[Chirag eReportz]

Hi,

Any update on this?

I need to have same Audience View as UI, like Level, Name, Audience Targeting, Status etc..

Thanks,

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to a topic in the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-api/dDdipg7mYfU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/db3483c4-31ac-4c14-8f7a-a279f6b3f165n%40googlegroups.com.

[Google Ads API Forum Advisor Prod]

Hello,

We resolved David's issue but his was account specific.

I can have a look at your account. Please share your report query, screenshot of your UI and your API results through reply privately to author so I can take a look.

Thanks,

Anthony
Google Ads API Team

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q23Jc2b:ref