GEO_PERFORMANCE_REPORT migration

[Hao Long]

Hi Team,

we are migrate GEO_PERFORMANCE_REPORT from Google Adwords API to Ads API and found there have two resources(geographic_view,user_location_view) mapped in Google Ads API.

in Google Adwords API we download below fields :

Date
AccountCurrencyCode
CampaignId
CampaignName
CityCriteriaId
CountryCriteriaId
IsTargetingLocation
MetroCriteriaId
MostSpecificCriteriaId
RegionCriteriaId
AdGroupId
Device
LocationType
Clicks
Cost
Impressions

to migrate to Google Ads API we need split into two queries, could you please help below questions:

1. could you please help advice the two queries if i want to get the same fields as adwords?

2. how to merge two returned data set into one?

Thanks

Hao

[Google Ads API Forum Advisor]

Hello,

Thanks for reaching out to the Google Ads API Forum. The resource name has been changed to the following mapping from the AdWords API reports to the corresponding Google Ads API resources.The GEO_PERFORMANCE_REPORT details you can find in the Google Ads API from the geographic_view and user_location_view reports. Both reports have the same segments and metrics fields. 

Please share your full AWQL query or those specific fields you are referring to? To get further clarity to investigate further, please share a full screen screenshot of the UI to indicate which activities you are referring to API. Hope this helps. Let us know if you have any further questions.

Best regards,

Jakeia Sabrina Google Ads API Team

 

ref:_00D1U1174p._5004Q2VQTBd:ref

[Hao Long]

Thanks Jakeia,

I could got the same information as you provide in previous mail. 

My question is i could get below fields in Google Adwords API GEO_PERFORMANCE_REPORT and we need migrate to use Google Ads API before this Apr. according the mapping relationship we could found there have two resources we need access if we want download the same data as Google Adwords API GEO_PERFORMANCE_REPORT returned.

AccountCurrencyCode
AdGroupId
CampaignId
CampaignName
CityCriteriaId
Clicks
Cost
CountryCriteriaId
Date
Device
Impressions
IsTargetingLocation
LocationType
MetroCriteriaId
MostSpecificCriteriaId
RegionCriteriaId  

Questions:

1. what the relationship for these two resources(geographic_view and user_location_view reports) in Google Ads API?

2. i draft below queries for geographic_view and user_location_view, two feeds will be returned. how to merge these two feeds into one(union or join) data feed as original Adwords ?

SELECT
customer.currency_code,
ad_group.id,
campaign.id,
campaign.name,
segments.geo_target_city,
metrics.clicks,
metrics.cost_micros,
metrics.impressions,
geographic_view.country_criterion_id,
segments.date,
segments.device,
geographic_view.location_type,
segments.geo_target_metro,
segments.geo_target_most_specific_location,
segments.geo_target_region
FROM geographic_view
WHERE segments.date DURING LAST_30_DAYS

SELECT
customer.currency_code,
ad_group.id,
campaign.id,
campaign.name,
segments.geo_target_city,
metrics.clicks,
metrics.cost_micros,
metrics.impressions ,
user_location_view.country_criterion_id,
segments.date,
segments.device,
user_location_view.targeting_location,
segments.geo_target_metro,
segments.geo_target_most_specific_location,
segments.geo_target_region
FROM user_location_view
WHERE segments.date DURING LAST_30_DAYS

[Google Ads API Forum Advisor]

Hello there,

Thank you for getting in touch. Could you please give us more information why you need to merge these (geographic_view and user_location_view reports) two resources into one, which is not possible via API, is there any valid reason behind this?

The main differences between two of them views are:

• 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.

Kindly go through this article to read more about measuring geographic performance.

Your numbers seem to indicate your location options are set to the default. If you want your ad to show for people physically located within Canada, change this setting to "People in my targeted location". Let me know if you have any questions.

[Hao Long]

Here is the query for Adwords API, when migrate to Ads API i need to query two resources (geographic_view and user_location_view） to get the same data as Adwords.

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'

so it will return two data feeds, right? how to merge these two returned feeds into one as i queried Google Adwords?

or is there have some more efficient solution i could take?

[Google Ads API Forum Advisor]

Hi Kirill,

Thank you for commenting on this forum post.

The GEO_PERFORMANCE_REPORT is indeed migrated to 2 reports in the Google Ads API which are geographic_view and user_location_view. With this, I would suggest using these report types based on its purpose and to get the data and statistics at a specific level.

However, may I know if there is a specific use case why you need to combine the 2 reports? This information will be helpful to further check your concern.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2VQTBd:ref