AUDIENCE_PERFORMANCE_REPORT and GEO_PERFORMANCE_REPORT migration from Adwords to Ads API

[Hao Long]

Hi Team,

We are facing one Google Adwords Report mapping to two Google Ads resources case when migrate from Google Adwords API to Google Ads API. 

Here is the mapping relationship from Google Wiki:

AUDIENCE_PERFORMANCE_REPORT:campaign_audience_view,ad_group_audience_view

GEO_PERFORMANCE_REPORT: geographic_view,user_location_view

we need you help provide some suggestions for our cases.

let's start from simple one: GEO_PERFORMANCE_REPORT

and it have below diff for two mapped resources in Google Ads API:

• Geographic view: The Geographic data shows your customer’s physical locations or locations that they had shown interest in through searches on Google or Google Maps.
• User location view: The user location data shows only your customer’s physical locations, regardless of any locations they may be interested in.

We used in Google Adwords API:

select
 Date
, AccountCurrencyCode
, CampaignId
, CampaignName
, CityCriteriaId
, CountryCriteriaId
, IsTargetingLocation
, MetroCriteriaId
, MostSpecificCriteriaId
, RegionCriteriaId
, AdGroupId
, Device
, LocationType
, Clicks
, Cost
, Impressions
from
GEO_PERFORMANCE_REPORT
where Date >='2022-01-01' and Date<='2022-02-05'

To keep get the same data as Google Adwords API, we need cutover to query geographic_view and user_location_view both and union two part of data? could you please help confirm?

For AUDIENCE_PERFORMANCE_REPORT it mapped to campaign_audience_view and ad_group_audience_view resources. 

and we have two feeds from Google Adwords API, one for performance data and one for audience structure. detail Adwords query attached as below:

Performance data feed：
select
Date,
AccountCurrencyCode,
Id,
CampaignId,
CampaignName,
Device,
Impressions,
Clicks,
Cost,
UserListName,
BidModifier,
AdGroupId
FROM AUDIENCE_PERFORMANCE_REPORT
where Date >='2022-01-01' and Date<='2022-02-05'

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
where Date >='2022-01-01' and Date<='2022-02-05'

1. could you please help confirm my assumption as below:

campaign_audience_view is audience data on campaign level and ad_group_audience_view is audience data on ad group level. we could get campaign_audience_view same data if we summary ad_group_audience_view on campaign level?

2. if #1 is yes then we could migrate our two feeds to ad_group_audience_view directly?

appreciate it if any suggestion from Google team!

Thanks

Hao

[Hao Long]

Hi Team,

Is there have anyone could help on this?

Thanks

Hao

[Hao Long]

Hi Team,

as we are pending on these two API migration, could you please help share your thoughts?

Thanks

Hao

[Hao Long]

Hi Team,

For Audience performance report migration, base on my assumption i have a try but we can not download anything from ad_group_audience_view.

query we used:

SELECT segments.date, customer.currency_code, customer.descriptive_name, customer.time_zone, ad_group.id, ad_group.base_ad_group, campaign.base_campaign, campaign.bidding_strategy, bidding_strategy.name, bidding_strategy.type, ad_group_criterion.bid_modifier, ad_group.campaign, campaign.name, campaign.status, ad_group_criterion.criterion_id, customer.id, ad_group_criterion.final_mobile_urls, ad_group_criterion.final_urls, ad_group.targeting_setting.target_restrictions, ad_group_criterion.status, ad_group.tracking_url_template, ad_group.url_custom_parameters FROM ad_group_audience_view WHERE segments.date DURING LAST_7_DAYS

sample account: 9759108564

could you please help on this?

another question is how to access Segmenting resources(bidding_strategy,user_list), as wiki said:

          Fields from the above resources, when selected along with this resource in your SELECT and WHERE clauses, will segment metrics.

does it means if we included Segmenting resources in query, the data will deep down to low granularity? but why if we add user_list.name it will have conflict with segments.date?

as we are pending on these two reports migration for a while, any help from Google Support team is appreciate. please let me know if we could setup zoom meeting to discuss the detail?

Thanks

Hao

[Hao Long]

Hi Team,

do you have an chance to help looking into this thread? we are pending on this few days.

Thanks

Hao

[Google Ads API Forum Advisor]

Hi Hao,

This case finally made it to our support, thank you for your patience. I was able to download  your ad_group_audience_view report on Feb 23, could you check again? If you added metrics did metrics show? Adding segments would stop rows without metrics from being downloaded.

To find which fields conflict you can use the query builder. If you want a combination that we don't offer you can privately send us a full screen screenshot of the new UI where this combination is available. The new Ads API can only be a conduit to the new product as expressed in the new UI. You may reach out to product support for assistance.

Campaign_audience_view only reports on audiences directly linked to campaigns and ad_group_audience_view only reports on audiences linked directly to ad groups so you need both to cover both types of linkage. You could segment by ad group to get how campaign linked audiences performed in specific ad groups, but that won't cover ad group linked audiences.

geographic_view and shows all impressions whether targeted or not. If user showed an interest in a targeted location and sees the ad from another location it will be attributed to location of interest. user_location_view shows all metrics based on user location only and also reports if the specific location is being targeted. They cannot be combined as they report on all account metrics. 

Feel free to get back to us.

Regards,

Aryeh Google Ads API Team

 

ref:_00D1U1174p._5004Q2WyLCA:ref

[Google Ads API Forum Advisor]

Hi Hao,

I had to remove your post because it contains a log. you may reply privately to send us a log.

Here is a redacted copy of your post:

Thanks Aryeh,


i have retried and can download the data but the it's so weird when i try download one hour later, it's return empty result. could you please help check?

message:

Request ------- MethodName: google.ads.googleads.v9.services.GoogleAdsService/SearchStream Endpoint: googleads.googleapis.com:443 Headers:  query: "select segments.date, customer.currency_code, ad_group_criterion.criterion_id, ad_group.campaign, campaign.name, segments.device, metrics.impressions, metrics.clicks, metrics.cost_micros, ad_group.id from ad_group_audience_view where segments.date between \'2022-02-24\' and \'2022-02-26\' " Response - Body: null Failure message: null Status: Status{code=OK, description=null, cause=null}. count0

Thanks
Hao

It could be because of data freshness issues, there are adjustments on new data and it appears you have no metrics on "linked to ad group" audiences for 2/22 -2/24.  I also reproduced no metrics when pulling your report, however, I pulled a campaign_audience_view report and metrics showed.

If you find a discrepancy between the UI and the API could you privately send us a full screen screenshot of the UI combined with a full log of the API report pull?