AWQL and join

[Marcin Gdak]

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

[Anthony Madrigal]

Hello Marcin,

AWQL does not support joining reports. You will need to run two separate reports, one for Keywords Performance Report and one for Ad Performance Report.

For more information on how to create a query for AWQL, go to the AWQL guide.

Regards,

Anthony

AdWords API Team

[Aditya]

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.