I am attempting to generate a report which tells me which Final URLs users are landing aggregated by click type (sitelinks, headline, etc). I am pulling a FINAL_URL_REPORT using the following query:
SELECT ClickType, EffectiveFinalUrl, Impressions, Cost, Clicks, Ctr, AverageCpc FROM FINAL_URL_REPORT DURING 20180320,20180320 This query returns all the unique (final url, click type) pairs. When I add up all the clicks across the rows I get a number that matches the total clicks on the AdWords web console. However, when I add up all the clicks across the rows with click type "Sitelink" I get a number that is much lower than what is shown on the AdWords web console for total clicks for all sitelink extensions. What is also interesting is that when I add up the total number of impressions across the rows with click type "Sitelink" it does match up with the number on the AdWords web console. Am I using the FINAL_URL_REPORT incorrectly or is there a bug on the web console/API? My goal is to get the true total number of clicks aggregated by unique final url + click type. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/2ed59e0e-936f-4b17-a0de-c7e65b80ebce%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
