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. On Monday, January 22, 2024 at 2:50:13 PM UTC-7 Google Ads API Forum Advisor wrote: > 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, > > [image: Google Logo] Google Ads API Team > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/f7294bbd-f796-4508-b09a-54d7a9ca9c99n%40googlegroups.com.