RE: reporting on geographic_view returns duplicate country rows

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Fan,

It appears that you might have missed our previous response. Please find the 
previous response below for your reference :

Based on the information provided, I understand that you want to know why the 
two rows with country_criterion_id 2840 are being retrieved. Upon checking the 
logs, I noticed that the geographic_view.location_type is different for each 
row, one has AREA_OF_INTEREST and the other has LOCATION_OF_PRESENCE. This 
difference in location type is why two rows are being retrieved for the same 
country_criterion_id.
This message is in relation to case "ref:!00D1U01174p.!5004Q02tJXZW:ref" 
(ADR-00244893)

Thanks,

Google Ads API Team


Register for the upcoming workshop: Performance Max and the Google Ads API!

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/zp7iZ0SG3ZLR00KExzFMhAToWN2fQpDT4Aog%40sfdc.net.

Re: Reporting on geographic_view returns duplicate country rows

[Fan Wang]

Hi team, 

Any updates on this issue?

BR.
Fan

On Tuesday, July 2, 2024 at 10:12:16 PM UTC+8 Fan Wang wrote:

> Dear Ads DevRel team,
>
> I hope this email finds everyone well!
>
> I'm reaching out to request your assistance regarding the GAQL report for 
> geographic_view 
> , 
> specifically for external CID *7703736321 <(770)%20373-6321>*. According 
> to the DevSite documentation,
>
> *"Geographic View includes all metrics aggregated at the country level, 
> one row per country."*
>
> However, as indicated in the attached log, I have observed 2 rows with 
> country_criterion_id: 2840 - US.
>
> Could you please review this and share your insights?
>
> Thanks and best regards, 
>
> Fan
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/fef77157-dc35-4ae9-9983-f6b8e0044e97n%40googlegroups.com.

Reporting on geographic_view returns duplicate country rows

[Fan Wang]

Dear Ads DevRel team,

I hope this email finds everyone well!

I'm reaching out to request your assistance regarding the GAQL report for 
geographic_view 
, 
specifically for external CID *7703736321*. According to the DevSite 
documentation,

*"Geographic View includes all metrics aggregated at the country level, one 
row per country."*

However, as indicated in the attached log, I have observed 2 rows with 
country_criterion_id: 2840 - US.

Could you please review this and share your insights?

Thanks and best regards, 

Fan

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/3331089b-0fb5-4d06-9c0e-cc707b0e701fn%40googlegroups.com.
2024-07-02T21:53:00.772+08:00  INFO 20631 --- [canary] [ault-executor-1] 
c.g.ads.googleads.lib.request.summary: SUCCESS REQUEST SUMMARY. Method: 
google.ads.googleads.v16.services.GoogleAdsService/Search, Endpoint: 
googleads.googleapis.com:443, CustomerID: 7703736321, RequestID: 
V6yHs2KchcFDKT2uZzE3PQ, ResponseCode: OK, Fault: null.
2024-07-02T21:53:01.044+08:00 DEBUG 20631 --- [canary] [ault-executor-1] 
c.g.ads.googleads.lib.request.detail : SUCCESS REQUEST DETAIL.
Request
---
MethodName: google.ads.googleads.v16.services.GoogleAdsService/Search
Endpoint: googleads.googleapis.com:443
Headers: {developer-token=REDACTED, login-customer-id=1035079252, 
x-goog-api-client=gl-java/17.0.10__Oracle-Corporation gccl/30.0.0 gapic/30.0.0 
gax/2.43.0 grpc/1.61.1}
Body: customer_id: "7703736321"
query: "SELECT geographic_view.country_criterion_id, 
geographic_view.location_type, metrics.impressions, metrics.clicks, 
metrics.ctr, metrics.average_cpc, metrics.average_cpm, metrics.cost_micros, 
metrics.conversions, metrics.cost_per_conversion, 
metrics.conversions_from_interactions_rate FROM geographic_view WHERE 
segments.date DURING LAST_WEEK_MON_SUN ORDER BY metrics.cost_micros DESC, 
metrics.impressions DESC"


Response

Headers: 
Metadata(content-disposition=attachment,content-type=application/grpc,request-id=V6yHs2KchcFDKT2uZzE3PQ,date=Tue,
 02 Jul 2024 13:52:59 GMT,alt-svc=h3=":443"; ma=2592000,h3-29=":443"; 
ma=2592000)
Body: results {
  metrics {
clicks: 83
conversions_from_interactions_rate: 0.047619047619047616
conversions: 4.0
cost_micros: 501602696
cost_per_conversion: 1.25400674E8
ctr: 0.06326219512195122
average_cpc: 6043405.975903614
average_cpm: 3.823191280487805E8
impressions: 1312
  }
  geographic_view {
resource_name: 
"customers/7703736321/geographicViews/2840~LOCATION_OF_PRESENCE"
location_type: LOCATION_OF_PRESENCE
country_criterion_id: 2840
  }
}
results {
  metrics {
clicks: 332
conversions_from_interactions_rate: 0.006024096385542169
conversions: 2.0
cost_micros: 21653
cost_per_conversion: 1.08265E8
ctr: 0.03639153787131426
average_cpc: 652198.7951807228
average_cpm: 2.37345171581E7
impressions: 9123
  }
  geographic_view {
resource_name: "customers/7703736321/geographicViews/2840~AREA_OF_INTEREST"
location_type: AREA_OF_INTEREST
country_criterion_id: 2840
  }
}
results {
  metrics {

... TRUNCATED. See README.md to configure/disable log truncation.
Failure message: null
Status: Status{code=OK, description=null, cause=null}.