When I had to do something similar, I had to generate both the Keywords Performance report and Ad Performance report, and then map the information between the two reports using the keyword ID field.
On Tuesday, June 16, 2015 at 2:56:28 AM UTC-7, Marcin Gdak wrote: > > Hi, > > I need to get all url of advertisements in relation to keywords in my > campaign. > > My query is: > > SELECT KeywordText FROM KEYWORDS_PERFORMANCE_REPORT JOIN > AD_PERFORMANCE_REPORT ON AD_PERFORMANCE_REPORT.KeywordId= > KEYWORDS_PERFORMANCE_REPORT.Id WHERE AD_PERFORMANCE_REPORT.CampaignId = " > + campaignId.ToString() + " DURING LAST_30_DAYS" > > > > Error: QueryError.PARSING_FAILED, Trigger: , FieldPath: > > > I found information that AWQL doesn't supporting joining reports. That's > true? > How can I most quickly get such data? > > Cheers, > Marcin > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/35ebde70-260e-4d5a-94de-d518c6445540%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
