Hi
I'm trying to get a report via the Google Ads API that returns campaigns
and conversions by conversion action last week.
query = f'''SELECT campaign.name,
campaign.advertising_channel_type,
segments.week,
customer.currency_code,
metrics.all_conversions,
FROM campaign
WHERE segments.week DURING LAST_WEEK_MON_SUN
AND campaign.name LIKE '%pro%'
AND campaign.name NOT LIKE '%promo%'
'''
Unfortunately, my query above returns a separate row for each campaign with
data for the conversion actions separately.
How can I retrieve the aggregate data for the campaign with the conversion
number for each conversion type like below?
Campaign Campaign Type Week Currency Conversion Action 1 Conversions.
Conversion
Action 2 Conversions. Conversion Action 3 Conversions.
Campaign 1
5
2 10
Campaign 2
2
1 12
I can't query the conversion_action view as the campaign field is not
supported on that.
Any help would be very much appreciated.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/f238e0e6-fdef-4281-b40d-aad71318da9co%40googlegroups.com.
