How can i combine or join more reports in Google Adwords API PHP

[Aroxo Senraj]

I have used Google Adwords API PHP - Shopping Performance report and get data successfully (version: v201601). I have used below query

SELECT OfferId,Impressions, Clicks, Conversions, Ctr,ConversionRate,Date FROM SHOPPING_PERFORMANCE_REPORT 

WHERE MerchantId="[MERCHANT_ID]" DURING 20160218,20160218

Now, I Need More Fields gender, age-group etc. How can i combine or join more reports in this query.

(Ex1: SELECT * FROM campaigns

LEFT OUTER JOIN adGroups ON campaigns.id=adGroups.campaignId

LEFT OUTER JOIN ads ON ads.adAdGroupId=adGroups.adGroupId)

(Ex2: SELECT * FROM criteria

JOIN keywords

WHERE criteria.critType='Keyword' AND keywords.keywordId=criteria.critId)

So, Please give me with example. I will wait your response.

[Yin Niu]

Hello, 

You need to join reports at your end, AWQL doesn't support joining reports.

Thanks,

Yin, AdWords API Team.