Hi, I am unable to get the hotel callouts from campaign_asset and customer_asset by using below queries but have callouts in google ads UI. However I got data for adgroup level from ad_group_asset. Is there any restriction for campaign and customer levels?
SELECT
campaign_asset.campaign,
campaign_asset.field_type,
campaign_asset.primary_status,
campaign_asset.resource_name,
campaign_asset.status,
campaign_asset.asset,
campaign_asset.source,
ad_group.id,
ad_group.name,
campaign.id,
campaign.name,
asset.source,
asset.hotel_callout_asset.language_code,
asset.callout_asset.callout_text,
asset.hotel_callout_asset.text,
asset.id,
asset.resource_name,
customer.currency_code,
customer.id,
customer.descriptive_name
FROM
campaign_asset
WHERE segments.date >= '2022-10-01' AND segments.date <= '2022-10-31'
SELECT
customer_asset.resource_name,
customer_asset.asset,
customer_asset.status,
campaign.id,
campaign.name,
ad_group.id,
ad_group.name,
asset.hotel_callout_asset.text,
asset.callout_asset.callout_text,
customer_asset.source,
asset.source,
customer.id,
customer.descriptive_name,
asset.hotel_callout_asset.language_code,
asset.id,
asset.resource_name,
customer.currency_code
FROM
customer_asset
WHERE segments.date >= '2021-10-01' AND segments.date <= '2023-10-31'
SELECT
ad_group_asset.ad_group,
ad_group_asset.field_type,
ad_group_asset.primary_status,
ad_group_asset.resource_name,
ad_group_asset.status,
ad_group_asset.asset,
ad_group.id,
ad_group.name,
campaign.id,
campaign.name,
ad_group_asset.source,
asset.source,
asset.hotel_callout_asset.language_code,
asset.callout_asset.callout_text,
asset.hotel_callout_asset.text,
asset.id,
asset.resource_name,
customer.currency_code,
customer.id,
customer.descriptive_name
FROM
ad_group_asset
WHERE segments.date >= '2022-10-01' AND segments.date <= '2022-10-31'