Small inconsistencies with conversions_by_conversion_date

[the...@funnel.io]

Hi, we're seeing small differences in the number of conversions by conversion date between the google ads UI and API. From the API we get a total of 21129.62, but in the UI the result is 21131.30. Any idea why this could happen? The query:

SELECT campaign.advertising_channel_type, campaign.advertising_channel_sub_type, campaign.id, campaign.name, campaign.tracking_url_template, campaign.url_custom_parameters, campaign.final_url_suffix, segments.date, segments.conversion_action, segments.conversion_action_name, segments.external_conversion_source, segments.conversion_action_category, metrics.all_conversions, metrics.all_conversions_value, metrics.view_through_conversions, metrics.conversions, metrics.conversions_value, metrics.conversions_by_conversion_date, metrics.conversions_value_by_conversion_date, customer.currency_code FROM campaign WHERE segments.date BETWEEN '2021-05-01' AND '2021-05-31'

[Google Ads API Forum Advisor]

Hello there,

Thank you for raising this to us.

So our team can better check on this, can you share with us the details below via Reply privately to author option or via this email (googleadsa...@google.com)?

• Google Ads UI screenshot showing those discrepancies
• Complete logs (request and response with request-id) generated

Regards,

Mark Kevin Albios Google Ads API Team

ref:_00D1U1174p._5004Q2IyOn3:ref

[the...@funnel.io]

Hi, We have sent a private reply to this but never heard back from you, did you not receive my message? What is the status of this issue?

Best regards
Theodor Sandström
Developer @ Funnel

[Google Ads API Forum Advisor]

Hi Theo,

Thank you for following up. Our team was able to receive your private reply and we've already sent replies there. Unfortunately, it appears that you are not receiving our replies. With this, I would like to reiterate my reply and you can see it below.

I can see that you are comparing the campaign view of the UI and ad_group report type, unfortunately, this is not the correct mapping of API report in the UI.

If you want to get the data at the campaign level, then you need to use the campaign report instead. Otherwise, if you want to compare the data of ad_group report in the UI, then the correct mapping of this report is discussed here.

Furthermore, please ensure that you are using the same fields, filters and date ranges in the API report and UI when comparing the data to each other.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2IyOn3:ref