I'm trying to query all call extensions for a particular campaign or multiple campaigns. When I use the Google Ads Query Builder to write it, this is what it returns:
SELECT
campaign.id, extension_feed_item.call_feed_item.country_code, extension_feed_item.call_feed_item.phone_number,
extension_feed_item.id, extension_feed_item.resource_name, extension_feed_item.status FROM extension_feed_item WHERE
campaign.id = XXXXXXXXXX
When I run that query, nothing is returned. When I go into the my account, get the call extension id, and then create a new query without the campaign id it looks like this:
SELECT extension_feed_item.call_feed_item.country_code, extension_feed_item.call_feed_item.phone_number,
extension_feed_item.id, extension_feed_item.resource_name, extension_feed_item.status FROM extension_feed_item WHERE
extension_feed_item.id = XXXXXXXXXX
When I run that, the call extension is returned and looks like this:
extension_feed_item {
resource_name: "customers/XXXXXXXX/extensionFeedItems/XXXXXXXXX"
status: ENABLED
call_feed_item {
phone_number: "XXXXXXXXXXXX"
country_code: "US"
}
id: XXXXXXXXXXX
}
Is it a bug the query builder will allow me to select the
campaign.id even though it doesn't work?
How can I get all the call extensions associated with a list of campaign ids?