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)