Hi there, I am hoping someone can help tell which resource to query to get impressions/clicks metrics segmented on date for a campaign for a Location Asset.
I have been trying the campaign_asset report but I am not getting results back, but I see in the in the Google Ads interface (Asset page filtered on Location Assets) that there are clicks and impressions for Location Assets? I have also tried the customer_asset and no luck either. I used to be able to pull the metrics via the extension_feed_item report before the migration of locations to assets like this. SELECT segments.date, campaign.id, campaign.name, campaign.status, campaign.advertising_channel_type, metrics.clicks, metrics.cost_micros, metrics.impressions, metrics.conversions, metrics.average_cpc, metrics.all_conversions, extension_feed_item.id, extension_feed_item.extension_type, extension_feed_item.location_feed_item.address_line_1, extension_feed_item.location_feed_item.address_line_2, extension_feed_item.location_feed_item.business_name, extension_feed_item.location_feed_item.city, extension_feed_item.location_feed_item.country_code, extension_feed_item.location_feed_item.phone_number, extension_feed_item.location_feed_item.postal_code, extension_feed_item.location_feed_item.province, FROM extension_feed_item WHERE campaign.id = %PLACEHOLDER% AND segments.date DURING YESTERDAY I have tried using campaign_asset report filtered on the asset.type of LOCATION but no luck.. SELECT segments.date, campaign.id, campaign.name, campaign.resource_name, campaign.serving_status, campaign_asset.asset, campaign_asset.field_type, campaign_asset.status, campaign_asset.resource_name, campaign_asset.primary_status, metrics.clicks, metrics.impressions, asset.id, asset.type, asset.location_asset.location_ownership_type, asset.location_asset.business_profile_locations, asset.location_asset.place_id FROM campaign_asset WHERE customer.id = %PLACEHOLDER% AND asset.type = 'LOCATION' AND segments.date DURING YESTERDAY Also how do I get the address details of the location asset? I can see the location asset with this query, but not the location's full address : SELECT asset.name, asset.id, asset.resource_name, asset.type, asset.source, asset.location_asset.place_id, asset.location_asset.location_ownership_type, asset.location_asset.business_profile_locations FROM asset WHERE customer.id = %PLACEHOLDER% AND asset.type = 'LOCATION' Any help would be great and appreciated. Thanks Robert. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords 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/4e3d1b2a-b299-4a0c-b60d-9407a7b5d700n%40googlegroups.com.
