Report that ties location_id to radius proximity information?

49 views
Skip to first unread message

jim.m...@ticketnetwork.com

unread,
Jun 8, 2017, 5:40:03 PM6/8/17
to AdWords API Forum
I am looking for an Adwords report that can be used to return me all of the radius (proximity) information I need for existing campaign targets.  Here's my scenario:

We have some campaigns that target both based on locations (Zip Codes) and using a Radius approach (50 miles from a lat/long for example).  We use the CAMPAIGN_LOCATION_TARGET_REPORT to get back all of the data for locations that are tied to existing campaigns.  It returns a location Id for both radius and zipcode locations tied to the campaign.  However it doesn't return any info as to what those location_id's actually represent.

We have a store of the zipcode/dma location_id's and what they actually represent since those are static.  However, unless I'm wrong, the radius location_ids we get are created when we tie the radius target to the campaign.  

Is there a way to query a report that will give me the list of all the radius location_id's along with what they represent?  I need the GeoPoint (lat/long), RadiusDistanceUnits, and RadiusInUnits at the bare minimum.  I know that I can get this using a get on the CampaignCriterionService, but that doesn't seem like an efficient way to get ALL of the active radii and their information every time I need it.

Is there a report that will give me what I want, without having to us a selector/get on the CampaignCriterionService?

Thanks,
Jim


Here's the AWQL query we use for the CAMPAIGN_LOCATION_TARGET_REPORT:
cols = ['CampaignId', 'CampaignName', 'CampaignStatus', 'Impressions', 'Clicks', 'Conversions', 'Cost', 'Id', 'IsNegative', 'AveragePosition', 'AllConversionValue', 'BidModifier']
query
= "SELECT %s FROM CAMPAIGN_LOCATION_TARGET_REPORT WHERE CampaignStatus IN ['PAUSED', 'ENABLED']" % (', '.join(cols))


And here's the selector that gets me what I want with the CampaignCriterionService:
selector = {
 
'fields': ['Id', 'LocationName', 'DisplayType', 'TargetingStatus', 'BidModifier', 'GeoPoint', 'RadiusDistanceUnits', 'RadiusInUnits'],
 
'predicates': [
  {
      'field': 'CampaignId',
      'operator': 'IN',
      'values': ['#########']
  },
 
{
   
'field': 'CriteriaType',
   
'operator': 'IN',
   
'values': ['PROXIMITY']
 
}]
}
result
= campaign_criterion_service.get(selector)


Peter Oliquino

unread,
Jun 9, 2017, 1:58:54 AM6/9/17
to AdWords API Forum
Hi Jim,

I'm afraid that the GeoPoint, RadiusDistanceUnits, and RadiusInUnits are currently not available via the report types of the AdWords API. The supported fields are listed here for your reference. Please follow our blog for any future updates or announcements regarding the availability of these fields in the AdWords API reports.

Best regards,
Peter
AdWords API Team
Reply all
Reply to author
Forward
0 new messages