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/bdc5b1de-be15-4b34-85c8-0789defa2e88n%40googlegroups.com.
