I make below query ``` SELECT ad_group.id, asset.id, asset.name, asset.type, asset.image_asset.file_size, asset.image_asset.full_size.height_pixels, asset.image_asset.full_size.url, asset.image_asset.full_size.width_pixels, asset.image_asset.mime_type, asset.book_on_google_asset, asset.youtube_video_asset.youtube_video_id, asset.resource_name, asset.text_asset.text, asset.youtube_video_asset.youtube_video_title, metrics.all_conversions, metrics.all_conversions_value, metrics.clicks, metrics.conversions, metrics.conversions_value, metrics.cost_micros, metrics.impressions, metrics.view_through_conversions, metrics.biddable_app_install_conversions, metrics.biddable_app_post_install_conversions, segments.date FROM ad_group_ad_asset_view WHERE segments.date BETWEEN '2023-08-18' AND '2023-08-18' AND metrics.impressions > 0 AND campaign.advertising_channel_type = 'MULTI_CHANNEL' ```
But this still takes a lot of time and I get DeadlineExceeded Error. Now I batched this query on campaign ids by appending ``` AND campaign.id IN ( 123, 456, 789) ``` Then finally I get response, but it is empty, `[]` So if there is nothing in response, then it should be quicker Did I do something wrong? Thanks and Regards -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ae85dfdf-e839-460d-9cce-3319654c84f4n%40googlegroups.com.
