To illustrate the differences depending on dimensions:
1.when using the following set of dimensions:
{code}
geographic_view.country_criterion_id,
geographic_view.location_type,
campaign.id,campaign.name,
ad_group.id,ad_group.name,
customer.currency_code,customer.descriptive_name,
segments.device,
segments.date,segments.year,segments.day_of_week,segments.month,segments.quarter,segments.week,
{code}
I'm getting 2033 views - exactly the same number as from AdWords API
2. + segments.geo_target_region => I'm getting 1840 views (missing rows
are those with no geo_target_region)
3. +segments.geo_target_city => I'm getting 1732 views
4. +segments.geo_target_metro => I'm getting 1791 views
On Thursday, 29 October 2020 at 07:09:06 UTC+1 Elżbieta Jakubska wrote:
> Hi,
> I am trying to migrate geo targeting reports from AdWords API to Ads API.
> I am doing the following query:
>
> my $query = q{ SELECT
> geographic_view.country_criterion_id,
> geographic_view.location_type,
> segments.geo_target_region,
> segments.geo_target_city,
> segments.geo_target_metro,
> campaign.id,campaign.name,
> ad_group.id,ad_group.name,
> customer.currency_code,
> customer.descriptive_name,
> segments.device,
> segments.date,
> segments.year,
> segments.day_of_week,
> segments.month,
> segments.quarter,
> segments.week,
> metrics.clicks,
> metrics.cost_micros,
> metrics.impressions,
> metrics.conversions,
> metrics.conversions_value,
> metrics.all_conversions,
> metrics.all_conversions_value,
> metrics.interactions
> FROM
> geographic_view
> WHERE segments.date BETWEEN 20201027 AND 20201027
> and campaign.id in (1234)
> };
> I'm getting empty report. When I remove segments.geo_target_metro - I'm
> getting the similar data as from AdWords API. I can see, that in data from
> adwords API this dimension (geo_target_metro) is always empty for this case.
> Also I noticed, that I'm not getting rows for empty city, etc, so the
> metrics numbers are a little different depending on dimensions.
>
> I'm using python libs in version 7.0. Am I doing something wrong?
>
> Thank you for your feedback,
>
> Regards,
> Ela
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"AdWords API and Google Ads 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/e8fc3a05-fa44-4c5f-a5b8-9d015a980f47n%40googlegroups.com.
