Is it possible to do something like this:
var queryReport = AdWordsApp.report(
"SELECT * FROM (SELECT CampaignName, CampaignId, AdGroupId,
AdGroupName, Query, Clicks FROM " +
"SEARCH_QUERY_PERFORMANCE_REPORT WHERE ... ) lt " +
"LEFT OUTER JOIN (SELECT CampaignName, CampaignId, AdGr
Hello,
I am new to Google Ads API still and trying to understand if joins like
demonstrated below are allowed in order to create the table we want. Hope
to get some clarification here.
Thanks!
Yao
On Wednesday, June 9, 2021 at 5:10:20 PM UTC-7 Yao Liu wrote:
> Is it possible to do something
Hi Yao,
Thanks for raising your concern.
Unfortunately, joining 2 report types directly in the API is not possible. You
will need to download the reports and create a process on your end instead to
join the data of different report types.
Regards,
Ernie John Blanca Tacata
Google Ads API Team