Hi guys. I'm trying to reproduce the following Google Ads UI report.
[image: mobile.png] In theory, as far as I understand, this report can be reproduced with the landing_page_view. Please, correct me if I am wrong here, because this is my assumption. Unfortunately, I was not yet able to fully reproduce this UI (with Google Ads API v12) with the following query SELECT landing_page_view.unexpanded_final_url, campaign.name, campaign.status, ad_group.name, ad_group.status, metrics.speed_score, metrics.mobile_friendly_clicks_percentage, metrics.clicks, metrics.impressions, metrics.ctr FROM landing_page_view WHERE segments.date BETWEEN '2022-10-01' AND '2022-11-12' AND campaign.status = ENABLED AND ad_group.status = ENABLED I get *7491* rows, which are the same number of rows I find in the UI report (see the screenshot). However, after having compared the 2 data frames (I'm using pandas), it seems that there are *33* rows returned by the API that are not found in the UI report, and I can't really explain why. So, here are my questions *1. Why is there a difference between the API and UI reports/data?* *2. What does the API do that the UI doesn't and vice-versa (for this specific report)? * *3. What should I change in my query in order to reproduce exactly the UI report above?* The only advice given in the Google Ads API documentation <https://developers.google.com/google-ads/api/docs/reporting/uireports> that I found regarding possible differences is that the UI implicitly filters REMOVED campaigns and so we should also ignore them, but, as you can see above, I am only selecting ENABLED campaigns, so this is not the problem. Note: if I use an older GAD API version (specifically, v11), I get even more different results, with the same query. I get many fewer rows. *Why is that?* Thanks for all the help. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/57b0981e-73ed-434c-afbf-3f42caefdbe2n%40googlegroups.com.
