Reports periodically returns much less data

[Nikita Kulik]

Sometimes, API returned us much less data then often, and on the next time we requesting it everything is okay. If this expected and why this could happen? 

Often we receive 3M rows, but it was a few times when we receive 1M or less. Also, when we receive less data number of rows are always rounded and divisible by 10000.

Example of query used: 

https://googleads.googleapis.com/v11/customers/{{account_id}}/googleAds:searchStream

{

"query":

"

SELECT

campaign.advertising_channel_sub_type,

campaign.advertising_channel_type,

campaign.id,

campaign.name,

campaign.status,

geographic_view.country_criterion_id,

metrics.all_conversions,

metrics.all_conversions_value,

metrics.conversions,

metrics.conversions_value,

metrics.view_through_conversions,

segments.ad_network_type,

segments.conversion_action,

segments.conversion_action_category,

segments.conversion_action_name,

segments.date,

segments.device,

segments.external_conversion_source,

segments.geo_target_city,

segments.geo_target_region,

segments.geo_target_state

FROM

geographic_view

WHERE

segments.date BETWEEN '2021-09-01' AND '2022-10-01'

"

}

[Google Ads API and AdWords API Forum]

Re-posting the last inquiry ( https://groups.google.com/g/adwords-api/c/_A-CFtvF0Mo ) from the forum as it wasn't routed to our support queue.

Kind regards,
Darwin

Google Ads API Team

[Google Ads API Forum Advisor]

Hi,

Thank you for posting your concern. I am from the Google Ads API team and let me provide support to your concern.

In order for us to investigate the issue, would you be able to provide the below data for the report without issue and the report with issues?

• complete request and response logs with request ID and request header

This information can be extracted when logging of API transactions is enabled on your end after following this guide. If you are using the REST API, then you can use the curl command -i flag and this will cause the tool to include the HTTP response headers in the output. 

You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2g1sqv:ref