Are metrics in CAMPAIGN_LOCATION_TARGET_REPORT aggregated by county for different Location Ids?

[Anton Gabov]

Hello,

I use Java client for downloading CAMPAIGN_LOCATION_TARGET_REPORT with such Query:

ReportQuery query = new ReportQuery.Builder()

        .fields("CampaignId", "CampaignName", "Id", "Date", "Clicks", "Impressions", "Conversions", "Cost")

                .from(ReportDefinitionReportType.CAMPAIGN_LOCATION_TARGET_REPORT)

                .during(ReportDefinitionDateRangeType.LAST_7_DAYS)

                .build();

The result is the following:
Campaign ID,Campaign,Location,Day,Clicks,Impressions,Conversions,Cost
...

<campaign_id_1>,<campaign_name_1>,2586,2019-06-29,5,3500,25.00,5500000
...

<campaign_id_1>,<campaign_name_1>,9061362,2019-06-29,0,2,0.00,4500
...

After that, I want to map Location to the Country Name via LocationCriterionService (https://developers.google.com/adwords/api/docs/reference/v201809/LocationCriterionService).

But in the result I have different locations, which belong to one country (like in the result above):
1) 2586 - it's Pakistan county

2) 9061362 - it's Pakistan county, BUT it's only specific region of the country - Federally Administered Tribal Area

In my case I would like to have metrics for the countries not for the regions. That's why I have questions:
Are metrics in the report for the regions, cities and e.t.c are already included in the metrics for the country?
Or should I sum all metrics, which are related to different locations but belonged to one county, in order to get aggregated result?

For instance, what result should I have for county Pakistan?
1)  <campaign_id_1>,<campaign_name_1>,2586,2019-06-29,5,3500,25.00,5500000 
or this:
2) 
<campaign_id_1>,<campaign_name_1>,2586,2019-06-29,5,3500,25.00,5500000

+

<campaign_id_1>,<campaign_name_1>,9061362,2019-06-29,0,2,0.00,4500
=
<campaign_id_1>,<campaign_name_1>,Pakistan,2019-06-29,5,3502,25.00,5504500 

[Google Ads API Forum Advisor Prod]

Hi Anton,

Thank you for reaching out.

The location types should be treated as separate entities and should not be calculated at the same time because they generate different metrics. If you wish to retrieve data on the country level, this does not mean you can add all the regions under the country to get the total for the country. 

The LocationCriterionService returns LocationCriterion constants that match a specified name or list of criterion id as specified in the input selector. If you want to get the equivalent name of the criterion Id, you can download the .csv file in the Geotargets table for reference.

Regards,
Dannison
Google Ads API Team

ref:_00D1U1174p._5001UCbZ03:ref

[Anton Gabov]

Hello, Dannison!
Thank you for you answer.

1) Unfortunately, I still don't understand whether I should sum metrics for all regions/cities in order to get metrics for the country?
Or metrics for the country location already represents all needed info for this country?

2) For example, I can use Geotargets table for mapping Location -> Country code/Target type.
If I want to get report for the countries, I should eliminate all rows, where Target type != Country. Or I should group all rows by Country code and sum metrics of grouped rows?
What is the right solution?

[Google Ads API Forum Advisor Prod]

Hi Anton,

Kindly refer to my response below.

1) Unfortunately, I still don't understand whether I should sum metrics for all regions/cities in order to get metrics for the country?
Or metrics for the country location already represents all needed info for this country?

- It is not recommended to sum the metrics that are generated on the region/city level to get the result for country level. The country metric should be able to represent all the needed information for the country.

2) For example, I can use Geotargets table for mapping Location -> Country code/Target type. 
If I want to get report for the countries, I should eliminate all rows, where Target type != Country. Or I should group all rows by Country code and sum metrics of grouped rows?
What is the right solution?

- If you would want to return only country data in your report, I am afraid that this is not possible in the Campaign Location Target Report as this reports returns all location criteria set in your campaigns. You cannot set a filter for target type in the report.