Missing data between reports

[Kristina Mikhailenko]

Hello

We have two queries:

1) {"query":"SELECT campaign.id, customer.id, metrics.all_conversions, metrics.all_conversions_value, segments.conversion_action_name, segments.date FROM campaign WHERE segments.date >= '2023-03-17' and segments.date <= '2023-03-20'  AND campaign.id = '18066129741'"}

2) {"query":"SELECT asset_group.id, asset_group_listing_group_filter.parent_listing_group_filter, campaign.id, customer.id, metrics.all_conversions, metrics.all_conversions_value, segments.conversion_action_name, segments.date FROM asset_group_product_group_view WHERE segments.date >= '2023-03-17' and segments.date <= '2023-03-20'  AND campaign.id = '18066129741'"}

In the response for the first query we have the data from the 17th of March, but in the response for second one - we don't have data from the 17th March. Can you help me understand why this is so?

Thank you in advance.

Kristina

[Google Ads API and AdWords API Forum]

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

Regards,

Google Ads API Team

[Google Ads API and AdWords API Forum]

Hi Kristina,

Thank you for raising this concern to the Google Ads API forum.

Regarding your concern, you mentioned that when using the 2nd query, you are not getting the data from the 17th of March. However, I noticed that you are using a different report. For our team to investigate this on our end, can you provide the following data?

• Provide the complete request and response logs with request ID and request header  generated as shown in the respective links.
• Complete screenshots (without cropping) from the Google Ads UI

We do this to check if there’s an error thrown on your side and we can further investigate.
 
If you haven't enabled logging yet, it can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. For REST interface requests, you can enable logging via the curl command by using the -i flag. This will cause the tool to include the HTTP response headers in the output.

You may then send the requested logs via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Regards,

Google Ads API Team

On Friday, March 31, 2023 at 4:04:18 PM UTC+8 kristina.m...@fivetran.com wrote: