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 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, AdGroupId, > AdGroupName, Query, AllConversions " + > "FROM SEARCH_QUERY_PERFORMANCE_REPORT WHERE ConversionTypeName = > 'First Time Purchase' AND ...) rt " + > "ON lt.CampaignId = rt.CampaignId AND lt.AdGroupId = rt.AdGroupId AND > lt.Query = rt.Query" > ) > > I want each query's clicks as well as "First Time Purchase" conversions. I > can't directly use Conversions or AllConversions because each campaign > might have optimized different conversion actions in the past. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] 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 and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/fe486990-0184-412c-adb4-848dd2f3cfben%40googlegroups.com.
