CAMPAIGN_LOCATION_TARGET_REPORT returns rows with ID='--'

458 views
Skip to first unread message

Zweitze

unread,
Oct 12, 2017, 9:27:35 AM10/12/17
to AdWords API Forum
Hi all,

The documentation of the Id field of CAMPAIGN_LOCATION_TARGET_REPORT states "ID of the main object of this row". So how can I get rows with empty values?
This is the report definition:

<reportDefinition>
   <selector xmlns="https://adwords.google.com/api/adwords/cm/v201702">
       <fields>CampaignId</fields>
       <fields>Id</fields>
       <fields>Date</fields>
       <fields>AveragePosition</fields>
       <fields>Clicks</fields>
       <fields>Cost</fields>
       <fields>Impressions</fields>
       <fields>Interactions</fields>
       <predicates>
           <field>CampaignStatus</field>
           <operator>IN</operator>
           <values>ENABLED</values>
           <values>PAUSED</values>
           <values>REMOVED</values>
       </predicates>
       <predicates>
           <field>IsNegative</field>
           <operator>EQUALS</operator>
           <values>FALSE</values>
       </predicates>
       <dateRange>
           <min>20160101</min>
           <max>20160629</max>
       </dateRange>
   </selector>
   <reportName xmlns="https://adwords.google.com/api/adwords/cm/v201702">Results</reportName>
   <reportType xmlns="https://adwords.google.com/api/adwords/cm/v201702">CAMPAIGN_LOCATION_TARGET_REPORT</reportType>
   <dateRangeType xmlns="https://adwords.google.com/api/adwords/cm/v201702">CUSTOM_DATE</dateRangeType>
   <downloadFormat xmlns="https://adwords.google.com/api/adwords/cm/v201702">GZIPPED_XML</downloadFormat>
</reportDefinition>

An example of a row returned:
<row campaignID='297015706' location='--' day='2016-02-29' avgPosition='1.0' clicks='1' cost='250000' impressions='20' interactions='1'/>

And this is not the only row, the report has dozen, maybe hundreds of them.
Also interesting, when I request a similar report of the same type:

dateRangeType ALL_TIME
IncludeZeroImpressions is TRUE
No segmentation fields, no metric fields
Included field BidModifier

When I request that report for the same account I do NOT get a record with location '--'

What is going on here?
Thanks in advance!

Shwetha Vastrad (AdWords API Team)

unread,
Oct 12, 2017, 11:21:41 AM10/12/17
to AdWords API Forum
Hi,

The row in the downloaded Campaign Location Target Report with "--" for the Location Id corresponds to "Other locations". These are locations where your ads have appeared, but aren't specifically targeted by a campaign at this time. If you changed your location targets, your ad may have appeared in a location that you no longer target. The impressions for any removed locations will be included in the "Other locations" row.

Regards,
Shwetha, AdWords API Team.

Zweitze

unread,
Oct 13, 2017, 4:54:25 AM10/13/17
to AdWords API Forum
Hi Swetha, thank you very much for this answer.
I would have never come up with that.

Do you have more information on these other (disappeared) locations? For instance a link to a product page, as I can't find it.
Basically I want to know when results for a normal location change into results for other locations, meaning how many days after removing the targeting for a specific location (or pausing the campaign or whatever triggers the change). And, if that is very soon, what happens if a conversion falls after a click on a certain location, but the targeting is removed between the click and the conversion.

I know these are AdWords product questions but I can't find it in the AdWords documentation, so I appreciate if you can give some links on this matter.

Thanks!

Shwetha Vastrad (AdWords API Team)

unread,
Oct 13, 2017, 3:07:40 PM10/13/17
to AdWords API Forum
Hi Zweitze,

I couldn't find a support article regarding this as well. If you log in to an AdWords client account and navigate to the Settings > Locations tab, you'll find the "Total - other locations" row in the UI report and if you hover over the question mark, you'll find more details on these statistics. 

yogesh patel

unread,
Jul 29, 2018, 9:52:36 PM7/29/18
to AdWords API and Google Ads API Forum
Hey Shetha Vastrad,

Hope you are fine.

How can I get the Location name and lat-long of that location inside  CAMPAIGN_LOCATION_TARGET_REPORT ?

Peter Oliquino (AdWords API Team)

unread,
Jul 30, 2018, 1:38:37 AM7/30/18
to AdWords API and Google Ads API Forum
Hi Yogesh,

I'm afraid that both of the information you asked are currently not available via the Campaign Location Target Report. For the location name, you can use the Id field of the report as the value of the Criteria Id and use it to filter the geo targeting spreadsheet to get the Canonical Name of the location.

As for the lat-long information, you will need to use the CampaignCriterionService.get() in order to fetch the GeoPoint values of your Proximity criterion. Also, since this is already an old thread, I would recommend that you create a new one for future concerns.

Thanks and regards,
Peter Laurence N. Oliquino
AdWords API Team

yogesh patel

unread,
Jul 30, 2018, 2:20:54 AM7/30/18
to AdWords API and Google Ads API Forum
Hey Peter,

Thanks for your response. But you are too late, I was already implemented using CampaignCriterionService.

Thanks once again, Have a good day ahead.

Divyesh Gajjar

unread,
Jun 18, 2020, 2:25:15 AM6/18/20
to AdWords API and Google Ads API Forum
Hi  Yogesh,
can you please tell me how to implemented using CampaignCriterionService for get campaign location name.
please replay.

Google Ads API Forum Advisor Prod

unread,
Jun 18, 2020, 2:38:32 PM6/18/20
to divye...@gmail.com, adwor...@googlegroups.com

Hi Divyesh,

Thank you for reaching out. You could use the LocationCriterionService to retrieve the CanonicalName of the Id you get from the Campaign Location Target Report. You could refer to this code example on how to use this service.

Thanks and regards,
Xiaoming, Google Ads API Team


 

ref:_00D1U1174p._5004Q217QTE:ref
Reply all
Reply to author
Forward
0 new messages