Data Difference in Google ADS API Data and Google ADS UI

[ATripathi]

Hi,
I am using below query to fetch data for Final URL, but data from API does not match with Google ADS UI data. I am using Final URL report in Google ADS UI to match data with API response.
Google Ads Query:- "SELECT landing_page_view.unexpanded_final_url, metrics.impressions, metrics.clicks, metrics.interactions, metrics.cost_micros, metrics.conversions, metrics.all_conversions, metrics.conversions_value, metrics.all_conversions_value, metrics.cross_device_conversions, metrics.engagements FROM landing_page_view  WHERE segments.date BETWEEN "2022-03-01" AND "2022-03-31" "

we are using above query in place of this ADWORDS query
" SELECT landing_page_view.unexpanded_final_url, metrics.impressions, metrics.clicks, metrics.interactions, metrics.cost_micros, metrics.conversions, metrics.all_conversions, metrics.conversions_value, metrics.all_conversions_value, metrics.cross_device_conversions, metrics.engagements FROM landing_page_view WHERE segments.date BETWEEN "2022-03-01" AND "2022-03-31" "

There is also difference in ADWORDS API data and Google ADS API data
That Google ADS query was suggested by Google ADS query migrator.
can you confirm that it is a correct query for fetching Final Report?
if yes then why there is difference in data in Google ADS UI and API data?

Thanks

[Google Ads API Forum Advisor]

Hi there,

Thanks for reaching out to the Google Ads API Forum.

Since you mentioned that you noticed a data discrepancy issue on landing_page_view report from Google Ads API as compared with your Ads UI, then for us to investigate further data discrepancies between the Google Ads API and Ads UI, could you please provide us with the following details below?

• Provide the customer ID or complete request and response logs with request ID generated
• Complete screenshots from the UI showing data(containing date filters)
• Sample comparison of the Ads API and Ads UI where we can see the discrepancies
• Provide the AWQL to confirm mapping from AWQL to GAQL

Kindly provide the above information via reply to author privately option.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2aORUy:ref

[b...@saltbox.solutions]

Hello,

I'm having the same issue here. Some of the landing pages in my account are returning complete data, some are returning no data, and some are returning partial data.

Happy to provide details about my account / request privately.

Thanks,

Ben

[Google Ads API Forum Advisor]

Hi Ben,

Thank you for reaching out to Google Ads API support. Here is a final URL report migration guide.

 For us to investigate we will need the following for each discrepancy:

• Full screen screenshot of the UI report you are trying to duplicate using the API.
• Request and response  'DEBUG' log level log of API communications of the API report download. 

The request and response appears similar to the JSON Mappings in our REST documentation with additional headers and information such as request Id. Our client libraries have loggers with logging instructions, to see these instructions you can click on the client library you use in the sidebar of our client library guide and click on "Logging”.

If you are using our REST interface then the full multi line curl command line is a request log and adding curl command line option '-i' will also generate a response log.

The screenshot and API report need to be done during the same time frame as there are changes to the data over time described in the data freshness guide from product support.

In AdWords API, a request looks like the 3rd section in request and a response looks similar to response. Logging instructions are in the read.me on Github of each client library.

Regards,

Aryeh Google Ads API Team

 

ref:_00D1U1174p._5004Q2aORUy:ref

[emanue...@gmail.com]

Hello,

I'm having the same issue here.

Thanks

Emanuele

[Jidapa Thanabhusest]

Hi,

I have the same issue. Do you have any updates? I notice that all the missing records are the ones that will not have valid AMP click rate or mobile speed score in the UI.

Best,

Jidapa

[Mauricio Obando Gomez]

Hi,

Same Issue here but using expanded_landing_page_view, the Ads UI is showing more expanded urls, 20-30% off.

SELECT

    expanded_landing_page_view.expanded_final_url,

    landing_page_view.unexpanded_final_url

FROM

    expanded_landing_page_view

WHERE

    segments.date BETWEEN '2023-08-01' AND '2023-08-31'

Any updates?

Regards,

Mauricio