Awql Campaign from AdgroupCriterionService

[Kai steudten]

Hello,

im using awql for selecting several keywords over the AdgroupCriterionService.

Now i also want the campaignName in this result. Is it possible to select campaignName, adgroupName and keywords over one awql-statement? Dont think so or?

Regards,

Kai

[Danial Klimkin]

Hello Kai,

No, cross-service joins are not supported. You need to query multiple services and join data by IDs. In some cases higher-level object properties are available, please check the selectors guide for each particular case:

  https://developers.google.com/adwords/api/docs/appendix/selectorfields

-Danial, AdWords API Team.

[Eitan Shay]

Hi Danial,

Does it mean cross-service joins if I join like below:

SELECT Id, Name, Impressions, Clicks, Ctr, AverageCpm, AverageCpc,  UniqueUserCountAsLong, ReachFrequency FROM CAMPAIGN_PERFORMANCE_REPORT
JOIN CAMPAIGN_REACH_FREQUENCY_REPORT ON CAMPAIGN_PERFORMANCE_REPORT.Id=CAMPAIGN_REACH_FREQUENCY_REPORT.CampaignId

since I got a query error "Report was not downloaded. HTTP Response Code: 400, Type: QueryError.PARSING_FAILED" from this query.
Can you pls help me to fix it?

Thanks a lot for your kindly help.
Eitan

[Danial Klimkin]

Hello Eitan,

Yes, you can select from only one report at a time.

-Danial, AdWords API Team.