We are getting extensions data for campaigns which have NOT run yet - they have 0 impressions and have not been trafficked
SELECT
extension_feed_item.sitelink_feed_item.final_urls,
extension_feed_item.extension_type,
extension_feed_item.call_feed_item.phone_number,
extension_feed_item.callout_feed_item.callout_text,
extension_feed_item.sitelink_feed_item.line1,
extension_feed_item.sitelink_feed_item.line2,
extension_feed_item.sitelink_feed_item.link_text,
extension_feed_item.structured_snippet_feed_item.values,
extension_feed_item.targeted_geo_target_constant,
extension_feed_item.targeted_keyword.text,
extension_feed_item.targeted_keyword.match_type,
extension_feed_item.status
FROM extension_feed_item
However because of the campaign segment we cannot get prelaunch data - in order to get prelaunch data we have to remove
campaign.id from the query
Our question is how do we get
extension.id and
campaign.id together for PRELAUNCH campaigns (campaigns with 0 metrics)?
Appreciate any guidance here. Thank you!