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

2019-07-09 Thread 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.

Regards,
Dannison
Google Ads API Team
ref:_00D1U1174p._5001UCbZ03: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/i0NMA0PUEQ7Z00P6G2yl8NTiilmoXGKIcx0g%40sfdc.net.

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

2019-07-09 Thread 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?

On Tuesday, July 9, 2019 at 10:47:13 AM UTC+3, adsapiforumadvisor wrote:
>
> 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

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/b2711f48-dba5-404f-9f98-6c13124cc799%40googlegroups.com.

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

2019-07-09 Thread 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

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

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

2019-07-08 Thread 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
...
,,2586,2019-06-29,5,3500,25.00,550
...
,,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)  ,,2586,2019-06-29,5,3500,25.00,550 
or this:
2) 
,,2586,2019-06-29,5,3500,25.00,550
+
,,9061362,2019-06-29,0,2,0.00,4500
=
,,Pakistan,2019-06-29,5,3502,25.00,5504500 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/d9afda38-fb10-41b8-bc60-bebea61af094%40googlegroups.com.