Getting Reporting Metrics on Location Assets

[Robert P.]

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.

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

By reviewing your query, I understand that your concern is regarding getting reporting metrics on location Assets. Could you please provide us with the whole screenshot without cropping, including the customer ID and login-customer id for further investigation?

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02rY1Hh:ref"

Thanks,
 

Google Ads API Team

[Robert P.]

Hi,

Any update on this? 

When looking at the customer.location_asset_auto_migration_done,  customer.location_asset_auto_migration_done_date_time,  fields the missing metrics match up to the date migrated.

I tried fetching using the asset_set_asset table, query below, and I am able to get metrics back, but not on the campaign_asset table filtered on location type assets? 

Also not sure if anyone knows how to get the address details of the location asset?

//asset_set_asset query.

SELECT
  asset_set_asset.asset,
  asset_set_asset.asset_set,
  asset_set_asset.resource_name,
  asset_set_asset.status,
  campaign.id,
  campaign.name,
  campaign.serving_status,
  campaign.status,
  segments.date,
  campaign.resource_name,
  metrics.clicks,
  metrics.impressions,
  metrics.cost_micros,
  metrics.interactions,
  metrics.interaction_rate,
  metrics.interaction_event_types,
  metrics.phone_calls,
  metrics.phone_impressions,
  metrics.phone_through_rate,
  metrics.engagements,
  metrics.engagement_rate,
  metrics.ctr,
  metrics.average_cpm,
  metrics.average_cpc,
  metrics.average_cost,
  metrics.all_conversions,
  asset.resource_name,
  asset.source,
  asset.type,
  asset.tracking_url_template,
  asset.policy_summary.review_status,
  asset.policy_summary.policy_topic_entries,
  asset.policy_summary.approval_status,
  asset.name,
  asset.location_asset.place_id,
  asset.location_asset.location_ownership_type,
  asset.location_asset.business_profile_locations,
  asset.id,
  asset.final_urls,
  asset.final_url_suffix,
  asset.final_mobile_urls,
  asset.field_type_policy_summaries,
  asset_set.business_profile_location_group.dynamic_business_profile_location_group_filter.listing_id_filters,
  asset_set.business_profile_location_group.dynamic_business_profile_location_group_filter.business_name_filter.filter_type,
  asset_set.business_profile_location_group.dynamic_business_profile_location_group_filter.business_name_filter.business_name,
  asset_set.business_profile_location_group.dynamic_business_profile_location_group_filter.label_filters,
  asset_set.location_group_parent_asset_set_id,
  asset_set.id,
  asset_set.location_set.business_profile_location_set.business_name_filter,
  asset_set.location_set.business_profile_location_set.label_filters,
  asset_set.location_set.business_profile_location_set.listing_id_filters,
  asset_set.location_set.chain_location_set.relationship_type,
  asset_set.location_set.location_ownership_type,
  asset_set.name,
  asset_set.resource_name,
  asset_set.status,
  asset_set.type,
  customer.id,
  customer.location_asset_auto_migration_done,
  customer.location_asset_auto_migration_done_date_time,
  customer.status,
  customer.resource_name
FROM asset_set_asset
WHERE
  customer.id = %PLACEHOLDER%
  AND segments.date DURING YESTERDAY

Thanks Robert. 

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

Please find answers below for your queries.

I tried fetching using the asset_set_asset table, query below, and I am able to get metrics back, but not on the campaign_asset table filtered on location type assets?

• In order to assist you further, please provide the complete API logs (request and response with request-id and request header) generated at your end.
• Kindly note that you have to enable logging if you are using a client library. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

Also not sure if anyone knows how to get the address details of the location asset?

• To assist you more accurately on this, please provide us with an uncropped UI screenshot with clear visibility of the customer-id where you are able to see address details of the location asset. Please highlight the address details that you want to fetch via the Google Ads API.