Hi Ejay, Yes it is helpful!
This is what I have so far. I need to select the CampaignName, AdGroupName, FinalUrls and KeywordMatchType. And I am assuming that FinalUrls are the landing page? SELECT CampaignName, AdGroupName, FinalUrls, KeywordMatchType FROM KEYWORDS_PERFORMANCE_REPORT WHERE CampaignName LIKE "%404%" DURING 20081305,20190725 if the above is correct, how can I actually pass this to a spreadsheet, I dont know how to iterate the result And I also need the name of the keyword which I dont know which attribute is And how can I filter by date??? I thought that ordered by date was not allowed On Monday, July 29, 2019 at 11:39:56 AM UTC+1, adsapiforumadvisor wrote: > > Hi Juan, > > Thank you for posting your concern. > > I would recommend to utilize the Keywords Performance Report > <https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report> > and > include a filter using the CampaignName > <https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report#campaignname> > field > to get the campaigns that contains '*404*' in its name. You should then > inlcude the Date > <https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report#date> > field > as well so you can check the earliest date as to when impressions were > generated. > > However, since you want to retrieve the data and impressions of keywords > that is working since 2018, the output will be extremely large. If you > encounter timeouts > <https://developers.google.com/adwords/api/docs/guides/reporting#timeouts> > because > of this reason, try a shorter date range or use predicates to break up the > report request into multiple, smaller requests. > > Let me know if this is what you're looking for. > > Regards, > Ejay > Google Ads API Team > > > ref:_00D1U1174p._5001UEGxs3:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 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 and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/04612dc9-1951-4109-a2e1-4a62a2abf985%40googlegroups.com.