Getting empty response in query but still takes a long time

[Himanshu Patel]

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

[Google Ads API Forum Advisor]

Hi, 

Thank you for reaching out to the Google Ads API support team. 

By reviewing your concern, I understand that you're getting a Deadline Exceeded error and also getting an empty response after breaking the request. The DEADLINE_EXCEEDED error indicates that your request took longer than the deadline. 

Could you please provide us the complete API logs (request and response with request-id and request header) generated at your end to assist you further?

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

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:_00D1U1174p._5004Q2p2SAe:ref"

Thanks,
 

Google Ads API Team