subject:"GEO_PERFORMANCE_REPORT migration"

GEO_PERFORMANCE_REPORT migration

2022-01-28 Thread 'Hao Long' via Google Ads API and AdWords API Forum

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

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords 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/357b542e-7eee-4f16-9f1e-dc37762080f3n%40googlegroups.com.

Re: GEO_PERFORMANCE_REPORT migration

2022-02-06 Thread 'Hao Long' via Google Ads API and AdWords API Forum

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





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 
>  
> 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,
> [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 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 
"Google Ads API and AdWords 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/7219b5ac-f033-4681-bcb9-f625b319f804n%40googlegroups.com.

Re: GEO_PERFORMANCE_REPORT migration

2022-04-12 Thread Kirill Senatrev

I have the same problem during migration process. Could you tell me, 
please, Did you manage to solve this problem? Thanks in advance!

вторник, 8 февраля 2022 г. в 10:42:28 UTC+3, hal...@ebay.com: 

> 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?
>
> On Tuesday, February 8, 2022 at 3:10:44 AM UTC+8 adsapi wrote:
>
>> 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.
>>
>>
>> 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 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 
"Google Ads API and AdWords 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/6408df9c-5623-42bf-a9fd-0ca839e75aabn%40googlegroups.com.

Re: AUDIENCE_PERFORMANCE_REPORT and GEO_PERFORMANCE_REPORT migration from Adwords to Ads API

2022-02-23 Thread 'Hao Long' via Google Ads API and AdWords API Forum

Hi Team,

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

Thanks
Hao

On Friday, February 18, 2022 at 4:56:44 PM UTC+8 Hao Long wrote:

> 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
>
> On Wednesday, February 16, 2022 at 4:21:16 PM UTC+8 Hao Long wrote:
>
>> Hi Team,
>>
>> as we are pending on these two API migration, could you please help share 
>> your thoughts?
>>
>> Thanks
>> Hao
>>
>> On Tuesday, February 15, 2022 at 10:51:34 AM UTC+8 Hao Long wrote:
>>
>>> Hi Team,
>>>
>>> Is there have anyone could help on this?
>>>
>>> Thanks
>>> Hao
>>>
>>> On Friday, February 11, 2022 at 2:33:40 PM UTC+8 Hao Long wrote:
>>>
 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
 , FinalMobileUrl

Re: AUDIENCE_PERFORMANCE_REPORT and GEO_PERFORMANCE_REPORT migration from Adwords to Ads API

2022-02-27 Thread 'Hao Long' via Google Ads API and AdWords API Forum

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: {developer-token=REDACTED, 
login-customer-id=5749847778, x-goog-api-client=gl-java/1.8.0_252 gccl/task 
':google-ads:jar' property 'archiveVersion' gapic/task ':google-ads:jar' 
property 'archiveVersion' gax/2.6.1 grpc/task ':google-ads:jar' property 
'archiveVersion'} Body: customer_id: "7763800357" 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  Headers: 
Metadata(content-type=application/grpc,request-id=zaophMVMHKsE2o5DxcGloA,date=Mon,
 
28 Feb 2022 06:45:29 GMT,alt-svc=h3=":443"; ma=2592000,h3-29=":443"; 
ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; 
ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43") 
Body: null Failure message: null Status: Status{code=OK, description=null, 
cause=null}. count0

Thanks
Hao

On Thursday, February 24, 2022 at 5:30:01 AM UTC+8 adsapi wrote:

> 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,
>
> [image: Google Logo] 
> Aryeh 
> Google Ads API Team 
>   
>
>  
>
> ref:_00D1U1174p._5004Q2WyLCA: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 
"Google Ads API and AdWords 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/cba39cdb-14f2-4b2a-bb9f-5ac64a8e9eb1n%40googlegroups.com.

Re: AUDIENCE_PERFORMANCE_REPORT and GEO_PERFORMANCE_REPORT migration from Adwords to Ads API

2022-02-28 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum

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?

Regards,

Aryeh
Google Ads API Team
ref:_00D1U1174p._5004Q2WyLCA: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 
"Google Ads API and AdWords 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/laCPZ0R818EI00378i-hE9R3G-sQ0eLkwN4A%40sfdc.net.

GEO_PERFORMANCE_REPORT migration

Re: GEO_PERFORMANCE_REPORT migration

Re: GEO_PERFORMANCE_REPORT migration

Re: AUDIENCE_PERFORMANCE_REPORT and GEO_PERFORMANCE_REPORT migration from Adwords to Ads API

Re: AUDIENCE_PERFORMANCE_REPORT and GEO_PERFORMANCE_REPORT migration from Adwords to Ads API

Re: AUDIENCE_PERFORMANCE_REPORT and GEO_PERFORMANCE_REPORT migration from Adwords to Ads API

6 matches

Site Navigation

Mail list logo

Footer information