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 
<https://developers.google.com/google-ads/api/fields/v9/geographic_view?hl=en> 
and user_location_view 
<https://developers.google.com/google-ads/api/fields/v9/user_location_view?hl=en>
 
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





On Saturday, January 29, 2022 at 5:56:33 AM UTC+8 adsapi wrote:

> Hello,
>
> Thanks for reaching out to the Google Ads API Forum. The resource name has 
> been changed to the following mapping 
> <https://developers.google.com/google-ads/api/docs/migration/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 
> <https://developers.google.com/google-ads/api/fields/v9/geographic_view?hl=en>
>  
> and user_location_view 
> <https://developers.google.com/google-ads/api/fields/v9/user_location_view?hl=en>
>  
> 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,
> [image: Google Logo] 
> Jakeia Sabrina 
> Google Ads API Team  
>
>
> ref:_00D1U1174p._5004Q2VQTBd: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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/7219b5ac-f033-4681-bcb9-f625b319f804n%40googlegroups.com.

Reply via email to