Hi
With AdWords API it was my mistake, so finally I made it work. However, now
I also need to get this report type for UAC campaigns and having some
troubles validating data. To get the report I am using user_location_view
which should return data grouped by location of the user specified in
segments. If I am running the query below
```
SELECT
user_location_view.country_criterion_id,
segments.date,
segments.geo_target_region,
segments.geo_target_city,
metrics.clicks,
metrics.cost_micros,
metrics.impressions
FROM user_location_view
WHERE segments.date = '2021-03-25'
```
I am getting smaller amount of clicks, cost and impressions in comparison
to:
```
SELECT
user_location_view.country_criterion_id,
metrics.clicks,
metrics.cost_micros,
metrics.impressions
FROM user_location_view
WHERE segments.date = '2021-03-25'
```
I guess this is happening because of the segments used in the query
(segments.geo_target_city, segments.geo_target_region). If the city is
missing for metrics, it is not returning the row, just omits rows with
empty columns. Is that possible to control that and add all the data?
In AdWords API it returned "--" if there is an empty column.
Just to make it clear let me provide an example. In case of Adwords, API
GEO PERFORMANCE REPORT returns country_id, region_id and city_id. If
city_id is missing (I guess for those clicks which were not matched to
particular city), it returns "--". In case of user_location_view I get
different data, because if there is no matched city, there is no row with
the metrics which were matched on regions, but not cities. I can provide
additional account info for which I am requesting data via private messages
if needed.
On Thursday, 25 March 2021 at 04:48:45 UTC+3 adsapiforumadvisor wrote:
> Hi Maxim,
>
> Could you provide the complete report definition
> <https://developers.google.com/adwords/api/docs/guides/reporting#create_a_report_definition>
>
> in XML
> <https://developers.google.com/adwords/api/docs/guides/reporting#xml> or
> AWQL
> <https://developers.google.com/adwords/api/docs/guides/reporting#awql>
> format, for
> your Geo Performance Report request that you mentioned are not returning
> data? Could you also share sample customer IDs that you used that did not
> return any results? You may send the requested details using the *Reply
> privately to author* option.
>
> The geographic_view should return similar values as its equivalent UI
> view. To access the Geographic (UI) report, navigate to the *Locations* menu
> on the left, then click the *MORE* tab on the top bar, finally click
> *Geographic
> report*.
>
> For the mapping of equivalent fields of the AdWords API and Google Ads API
> reports, you may refer to this guide
> <https://developers.google.com/google-ads/api/docs/migration/reports>.
> For the Geo Performance Report and geographic_view, you may refer to this
> section
> <https://developers.google.com/google-ads/api/docs/migration/reports#geo_performance>
> .
>
> As for the results from the reports, I'm afraid that it would not be
> possible to return them in other languages.
>
>
> Best regards,
>
> [image: Google Logo]
> Peter Laurence Napa Oliquino
> Google Ads API Team
>
>
> ref:_00D1U1174p._5004Q2Dy6R0: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
"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/0609d17c-d4f8-498d-97a0-2c8390507b9en%40googlegroups.com.
