I forgot to mention that, before comparing the API and UI reports, I am dropping all rows where the metrics are all zero. This makes the API report still have 7491 rows (so the API doesn't return, at least in this case, rows where all metrics are zero), while the UI reports now has 7458 rows. Note 7491 - 7458 = 33, hence the 33 rows in the API report that are not found in the UI report. In fact, these 33 rows do not have all metrics equal to zero. In particular, it seems that the clicks are not equal to zero, but all other metrics are.
On Friday, December 16, 2022 at 1:44:30 PM UTC+1 Nelson Brochado wrote: > 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/126c918e-6c77-4b2c-832b-bf6cb106c5d8n%40googlegroups.com.
