RE: Google Ads geographic_view report misses data
Hello, Hope you are doing fine. Thank you for reaching out to the Google Ads API team. Moving forward, in order for our team to have a better view and can provide accurate recommendations to you, could you provide the complete request and response logs with request ID and request header generated on your end? If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsapi-supp...@google.com. Regards, Carmela Google Ads API Team ref:_00D1U1174p._5004Q2dnozP: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/g9mUN0RH7R5M00cDMwjmhKTE-qoSQI-b1pfA%40sfdc.net.
Re: Google Ads geographic_view report misses data
Follow up question sent in one more private email. Thanks!
On Tuesday, February 8, 2022 at 12:21:11 PM UTC+2 Oksana Sulyma wrote:
> Hi Aryeh,
> I appreciate your help very much. The answer makes a lot of sense to me. I
> can confirm that I got data match.
> Is it possible to edit your previous comment and remove customer_id from
> public visibility?
> Thanks again,
> Oksana
>
> On Monday, February 7, 2022 at 9:17:38 PM UTC+2 adsapi wrote:
>
>> Hi Oksana,
>>
>> I ran your Ads API report with modification and summary row returned
>> like AdWords:
>>
>>
>>
>> curl -v
>> "https://googleads.googleapis.com/v9/customers/1329679017/googleAds:search; \
>>
>> --header "Content-Type: application/json" \
>>
>> --header "developer-token:{}" \
>>
>> --header "Authorization: Bearer {}" \
>>
>> --data '{
>>
>> "query": "SELECT campaign.id, ad_group.id, segments.ad_network_type,
>> geographic_view.country_criterion_id,
>> segments.geo_target_most_specific_location, segments.date,
>> metrics.impressions, metrics.clicks, metrics.cost_micros,
>> metrics.conversions, metrics.view_through_conversions,
>> metrics.conversions_value, metrics.video_views, metrics.all_conversions,
>> metrics.all_conversions_value, metrics.cross_device_conversions,
>> metrics.interactions FROM geographic_view WHERE segments.date = 20220115 AND
>> ad_group.id = 123224461846" , "returnTotalResultsCount": true,
>> "summaryRowSetting": "SUMMARY_ROW_WITH_RESULTS" }'
>>
>> "summaryRow": {
>>
>> "metrics": {
>>
>>"clicks": "39",
>>
>>"videoViews": "0",
>>
>>"viewThroughConversions": "0",
>>
>>"conversionsValue": 0,
>>
>>"conversions": 0,
>>
>>"costMicros": "29506445",
>>
>>"allConversionsValue": 0,
>>
>>"allConversions": 21,
>>
>>"impressions": "1851",
>>
>>"interactions": "40"
>>
>> }
>>
>> }
>>
>> Note that Ads API excludes metrics that don't fit into each and every
>> segmentation field
>> ,
>>
>> hence when including segments.geo_target_region and/or
>> segments.geo_target_metro you run the risk of losing metrics that don't
>> fit. To get all the encompassing geo targets you can run a
>> geo_target_constant
>> report
>>
>> and walk up the geo_target_constant.parent_geo_target field
>> .
>>
>> Also, Ads API segments by location type of area of interest and location of
>> presence. I added the LocationType field to AdWords report to split the
>> rows.
>>
>> Regards,
>>
>> [image: Google Logo]
>> Aryeh Baker
>> Google Ads API Team
>>
>>
>> ref:_00D1U1174p._5004Q2W3xu1: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/09dd106f-220a-4398-be82-63147489cdd4n%40googlegroups.com.
Re: Google Ads geographic_view report misses data
Hi Oksana,
I ran your Ads API report with modification and summary row returned like
AdWords:
curl -v
"https://googleads.googleapis.com/v9/customers/1329679017/googleAds:search; \
--header "Content-Type: application/json" \
--header "developer-token:{}" \
--header "Authorization: Bearer {}" \
--data '{
"query": "SELECT campaign.id, ad_group.id, segments.ad_network_type,
geographic_view.country_criterion_id,
segments.geo_target_most_specific_location, segments.date, metrics.impressions,
metrics.clicks, metrics.cost_micros, metrics.conversions,
metrics.view_through_conversions, metrics.conversions_value,
metrics.video_views, metrics.all_conversions, metrics.all_conversions_value,
metrics.cross_device_conversions, metrics.interactions FROM geographic_view
WHERE segments.date = 20220115 AND ad_group.id = 123224461846" ,
"returnTotalResultsCount": true, "summaryRowSetting":
"SUMMARY_ROW_WITH_RESULTS" }'
"summaryRow": {
"metrics": {
"clicks": "39",
"videoViews": "0",
"viewThroughConversions": "0",
"conversionsValue": 0,
"conversions": 0,
"costMicros": "29506445",
"allConversionsValue": 0,
"allConversions": 21,
"impressions": "1851",
"interactions": "40"
}
}
Note that Ads API excludes metrics that don't fit into each and every
segmentation field, hence when including segments.geo_target_region and/or
segments.geo_target_metro you run the risk of losing metrics that don't fit. To
get all the encompassing geo targets you can run a geo_target_constant report
and walk up the geo_target_constant.parent_geo_target field. Also, Ads API
segments by location type of area of interest and location of presence. I added
the LocationType field to AdWords report to split the rows.
Regards,
Aryeh Baker
Google Ads API Team
ref:_00D1U1174p._5004Q2W3xu1: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/kDiIA0R6Y88I00s0Lf-aOCRYSICSeY0nyEYw%40sfdc.net.
Re: Google Ads geographic_view report misses data
Also if I remove geographic_view.country_criterion_id, segments.geo_target_region, segments.geo_target_metro, from my report definition For Google Ads API call, I still get the same numbers (smaller than expected). (Actually I need these fields, just trying to guess what could be wrong with segmentation / filtering) On Friday, February 4, 2022 at 5:09:32 PM UTC+2 Oksana Sulyma wrote: > Hi Aryeh, > > "Could you try taking out segments.geo_target_region, > segments.geo_target_metro and replacing them > with segments.geo_target_most_specific_location? " - just tried this, no > change in summaries. > > Sent you complete request and response info in private message. > > Will appreciate any other ideas. > > Also this discrepancy exists for many client of us, so my guess is that I > meet something in report definition. However I was following this migration > guide > https://developers.google.com/google-ads/api/docs/migration/mapping#geo_performance. > > > > Thanks, > Oksana > > > On Thursday, February 3, 2022 at 10:58:15 PM UTC+2 adsapi wrote: > >> Hi Oksana, >> >> Could you try taking out segments.geo_target_region, >> segments.geo_target_metro and replacing them >> with segments.geo_target_most_specific_location? I am asking this because >> you are filtering out all metrics that aren't from a region and a metro >> area. >> >> If this still doesn't fix the issue, could you privately send us a full >> report definition from each API with account Id's combined with a full >> screen screenshot of the UI that is supposed to match? >> >> Regards, >> >> [image: Google Logo] >> Aryeh Baker >> Google Ads API Team >> >> >> ref:_00D1U1174p._5004Q2W3xu1: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/7983b152-924a-4fd6-9e13-a4a0b0c15519n%40googlegroups.com.
Re: Google Ads geographic_view report misses data
Hi Aryeh, "Could you try taking out segments.geo_target_region, segments.geo_target_metro and replacing them with segments.geo_target_most_specific_location? " - just tried this, no change in summaries. Sent you complete request and response info in private message. Will appreciate any other ideas. Also this discrepancy exists for many client of us, so my guess is that I meet something in report definition. However I was following this migration guide https://developers.google.com/google-ads/api/docs/migration/mapping#geo_performance. Thanks, Oksana On Thursday, February 3, 2022 at 10:58:15 PM UTC+2 adsapi wrote: > Hi Oksana, > > Could you try taking out segments.geo_target_region, > segments.geo_target_metro and replacing them > with segments.geo_target_most_specific_location? I am asking this because > you are filtering out all metrics that aren't from a region and a metro > area. > > If this still doesn't fix the issue, could you privately send us a full > report definition from each API with account Id's combined with a full > screen screenshot of the UI that is supposed to match? > > Regards, > > [image: Google Logo] > Aryeh Baker > Google Ads API Team > > > ref:_00D1U1174p._5004Q2W3xu1: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/e4d45fbe-a599-44d5-92fa-d812b74c58dbn%40googlegroups.com.
Re: Google Ads geographic_view report misses data
Hi Aryeh, "Could you try taking out segments.geo_target_region, segments.geo_target_metro and replacing them with segments.geo_target_most_specific_location? " - just tried this, no change in summaries. Any other ideas? On Thursday, February 3, 2022 at 10:58:15 PM UTC+2 adsapi wrote: > Hi Oksana, > > Could you try taking out segments.geo_target_region, > segments.geo_target_metro and replacing them > with segments.geo_target_most_specific_location? I am asking this because > you are filtering out all metrics that aren't from a region and a metro > area. > > If this still doesn't fix the issue, could you privately send us a full > report definition from each API with account Id's combined with a full > screen screenshot of the UI that is supposed to match? > > Regards, > > [image: Google Logo] > Aryeh Baker > Google Ads API Team > > > ref:_00D1U1174p._5004Q2W3xu1: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/2eb719a7-e562-4d83-b13b-347fb5e5bb47n%40googlegroups.com.
RE: Google Ads geographic_view report misses data
Hi Oksana, Could you try taking out segments.geo_target_region, segments.geo_target_metro and replacing them with segments.geo_target_most_specific_location? I am asking this because you are filtering out all metrics that aren't from a region and a metro area. If this still doesn't fix the issue, could you privately send us a full report definition from each API with account Id's combined with a full screen screenshot of the UI that is supposed to match? Regards, Aryeh Baker Google Ads API Team ref:_00D1U1174p._5004Q2W3xu1: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/2ebGb0R6QY8900KK4_n0gFT42hehCSKecrNQ%40sfdc.net.
