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
On Wednesday, August 19, 2020 at 7:06:38 AM UTC+2 cv wrote:
> 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,
>
>
> On Wednesday, 19 August 2020 at 00:10:13 UTC+5:30 adsapiforumadvisor wrote:
>
>> 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,
>>
>> Anthony
>> Google Ads API Team
>>
>> ref:_00D1U1174p._5004Q23Jc2b:ref
>>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 the Google Groups
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/72be4dbc-a04f-4e57-95b8-59876ad4feeen%40googlegroups.com.
