Hi everyone,
I'm using the Google Ads API v15 with the googleAds:searchStream endpoint,
and I need to retrieve daily campaign performance data. I am using API
connector in Google Sheets.
I am trying to:
1. Filter out campaigns where the name includes “brand awareness”.
2. Aggregate data by day (one row per day).
3. Include metrics such as clicks, impressions, cost, conversions, etc.
However, I am encountering an issue where the API returns multiple rows per
day, one for each campaign. This happens even though I don’t include
campaign.name in the SELECT clause - because I am filtering by
campaign.name in the WHERE clause.
My current query:
{
"query": "SELECT segments.date, segments.day_of_week, metrics.clicks,
metrics.impressions, metrics.average_cpc, metrics.cost_micros,
metrics.conversions, metrics.cost_per_conversion,
metrics.conversions_value_by_conversion_date FROM campaign WHERE
campaign.name NOT LIKE '%brand awareness%' AND segments.date DURING
LAST_30_DAYS"
}
I need to aggregate the results so that I only receive one row per day
(total for all non-brand-awareness campaigns).
My Questions:
1.
Is it possible to use the Google Ads API to aggregate data to one row
per day while filtering out specific campaigns (like "brand awareness")?
2.
Is there a way to filter by campaign name but avoid the campaign-level
granularity in the returned data?
3.
If not, what is the recommended way to handle this type of aggregation?
Thank you!
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
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
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/adwords-api/d0fa6744-a2f2-4b36-9bc0-1d160702e98en%40googlegroups.com.
