Audience Performance Report

[Hao Long]

Hi Team,

We are migrate Audience Performance report form Google Adwords API to Google Ads API and according by resource mappings from Google Ads API wiki  page(https://developers.google.com/google-ads/api/docs/migration/mapping) there map to two resources(campaign_audience_view and ad_group_audience_view) in Google Ads API.

for my case there have two purposes:

1. get audience structure as meta data and we got below fields from Google Adwords API:

Date
AccountCurrencyCode
AccountDescriptiveName
AccountTimeZone
AdGroupId
BaseAdGroupId
BaseCampaignId
BiddingStrategyId
BiddingStrategyName
BiddingStrategyType
BidModifier
CampaignId
CampaignName
CampaignStatus
CpcBid
CpcBidSource
CpmBid
CpmBidSource
Criteria
CriteriaDestinationUrl
CriterionAttachmentLevel
CustomerDescriptiveName
ExternalCustomerId
FinalAppUrls
FinalMobileUrls
FinalUrls
Id
IsRestrict
Status
TrackingUrlTemplate
UrlCustomParameters
UserListName

2. get audience performance data  from Google Adwords API and below fields asked:

Date
AccountCurrencyCode
Id
CampaignId
CampaignName
Device
Impressions
Clicks
Cost
UserListName
BidModifier
AdGroupId

and we have below questions:

1. for my understanding campaign and adgroup they are not at the same level, ad group should be more low granularity, could we think campaign_audience_view,ad_group_audience_view are base on the same raw data but summary on diff level?

2. to get the same fields as we we get from Google adwords API we need query from two resources? if yes could you please help identify which field should from which resource?

3. this is continues question regarding #2, two data feeds returned from campaign and adgroup audience view, how to combine these two feeds into one(join keys)?

4. IsRestrict retuen Boolean value in Google Adwords API but Google Ads API returned list, could you please help guide how to transfer from list value to Boolean value in Google Ads API return value?

[Google Ads API Forum Advisor]

Hi Hao,

"campaign_audience_view" only includes audiences attached at the campaign level. "ad_group_audience_view" reports on audiences attached at adGroup level. For structure report you can use ad_group_criterion and campaign_criterion as you won't lose rows. In the audience_view reports, segmentation may cause loss of row reporting if there aren't any non zero metrics available for that row.

Here's our Targeting Settings for Remarketing guide.

To answer thoroughly, it would be useful for us to discuss a real live non theoretical case. Could you privately send us full report definitions from Ads, AdWords and Full UI screenshots of UI report screen of audience metrics?

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2VPd3f:ref

[Hao Long]

Thanks Baker,

As listed in the initial conversation current we have two feeds depend on google adwords api AUDIENCE_PERFORMANCE_REPORT

1. get below fields from google adwords api AUDIENCE_PERFORMANCE_REPORT on daily batch

2. get below fields from google adwords api AUDIENCE_PERFORMANCE_REPORT on daily batch

Date
AccountCurrencyCode
Id
CampaignId
CampaignName
Device
Impressions
Clicks
Cost
UserListName
BidModifier
AdGroupId

Base on these information do we still need use  ad_group_criterion and campaign_criterion? could you please provide some advices on how to migrate to Google Ads API?

[Google Ads API Forum Advisor]

Hello,

Thank you for reaching out to the Google Ads API support team.

You can use ad_group_criterion and campaign_criterion. Regarding migrating API from AdWords API to Google Ads API, you can check migration guide. Let me know if you have any question.

Thanks,

Nirmita Patel Google Ads API Team

ref:_00D1U1174p._5004Q2VPd3f:ref

[Hao Long]

yes i know, as mentioned in previous mail we have two feeds downloan from Google need migrate from Google Adwords Api to Ads API and according by migration guide the  Audience Performance report in Adwords will mapping to two resources (campaign_audience_view and ad_group_audience_view). we need you help guide how to split below two adwrods download feeds to Google Ads query and how to merge the returned two dataset into one file as adwords.

[Google Ads API Forum Advisor]

Hi Hao,

We do not have guidance on combining reports and there are breaking changes from AdWords to the new API that affect the availability of the exact report style you are used to. The Ads API is built to mirror the new UI as much as possible. To assist you we will need a concrete example.

Could you provide us privately with logs of request and response to the API's with request ID of the reports under consideration, combined with a full screen screenshot of a UI report screen you are attempting to replicate so that we can see the numbers that you are seeing and attempt to assist you? 

In the Ads API, the request and response appears similar to the JSON Mappings in our REST documentation. Our client libraries have loggers with logging instructions, to see these instructions you can click on the client library you use in the sidebar of our client library guide and click on "Logging".

In the AdWords API , then a request looks like the 3rd section in request and a response looks similar to response. Logging instructions are in the read.me on Github of each client library.

The requested log can be generated when the log level is set to 'DEBUG'.

Your first report appears to be a structure report and we do recommend using  ad_group_criterion and campaign_criterion for structure reports. 

Regards,

Aryeh Baker Google Ads API Team

 

ref:_00D1U1174p._5004Q2VPd3f:ref

[Hao Long]

Thanks Baker,

According by the AWQL attached below in Adword API I have a thought: the data we requested in Adwords API are all on ad group level(cause campaign and ad group field included in returned fields) and we could also summary the data on campaign level.

Performance data feed：

select
Date,
AccountCurrencyCode,
Id,
CampaignId,
CampaignName,
Device,
Impressions,
Clicks,
Cost,
UserListName,
BidModifier,
AdGroupId
FROM AUDIENCE_PERFORMANCE_REPORT
DURING LAST_7_DAYS

Structure data feed:
select
, Date
, AccountCurrencyCode
, AccountDescriptiveName
, AccountTimeZone
, AdGroupId
, BaseAdGroupId
, BaseCampaignId
, BiddingStrategyId
, BiddingStrategyName
, BiddingStrategyType
, BidModifier
, CampaignId
, CampaignName
, CampaignStatus
, CpcBid
, CpcBidSource
, CpmBid
, CpmBidSource
, Criteria
, CriteriaDestinationUrl
, CriterionAttachmentLevel
, CustomerDescriptiveName
, ExternalCustomerId
, FinalAppUrls
, FinalMobileUrls
, FinalUrls
, Id
, IsRestrict
, Status
, TrackingUrlTemplate
, UrlCustomParameters
, UserListName
FROM AUDIENCE_PERFORMANCE_REPORT
DURING LAST_7_DAYS

could you please help on below two questions?

1. could you please help confirm my thought? 

2. for UserListName need you help guide how to fetch in Ads API, detail please refer below detail:

Migration Query : 

SELECT segments.date, customer.currency_code, campaign.id, campaign.name, segments.device, metrics.impressions, metrics.clicks, metrics.cost_micros, user_list.name, ad_group.id, ad_group_criterion.criterion_id, ad_group_criterion.bid_modifier FROM ad_group_audience_view WHERE segments.date DURING LAST_7_DAYS

Query Valid Tool Exception Message:

Fix your query to address the errors below and re-submit.

• 'user_list.name' is incompatible with 'segments.device'.
• 'user_list.name' is incompatible with 'metrics.impressions'.
• 'user_list.name' is incompatible with 'metrics.clicks'.
• 'user_list.name' is incompatible with 'metrics.cost_micros'.

Thanks

Hao

[Google Ads API Forum Advisor]

Hello,

Thank you for reaching out to the Google Ads API support team.

Please see below the answers of your questions.

1. You can use campaign_audience_view to get performance data from interests and remarketing lists for Display Network and YouTube Network ads, and remarketing lists for search ads (RLSA), aggregated by campaign and audience criterion.
2. You can pull fields from in ad_group, ad_group_criteroion, campaign and customer reports in the "attributed resources”. You can read about metric selectability between metrics and segments here. You can use the selectable_with field to identify compatible metrics. 

Let me know if you have any question.

Thanks,

Nirmita Patel Google Ads API Team

ref:_00D1U1174p._5004Q2VPd3f:ref

[Hao Long]

Hi Patel,

you updates make me confused. 

for performance feed it contains adgroup fields we could not only access  campaign_audience_view to get the data we want.

select
Date,
AccountCurrencyCode,
Id,
CampaignId,
CampaignName,
Device,
Impressions,
Clicks,
Cost,
UserListName,
BidModifier,
AdGroupId
FROM AUDIENCE_PERFORMANCE_REPORT
DURING LAST_7_DAYS

for Structure feeds you mentioned we could access campaign and audience criterion resources. could you guide the fields should from which resource and how to merge returned  data from two resources?