Connector Improvement: Lifetime Aggregation for Google And Spotify
Answered
According to the Spotify and Google ads docs, you can specify to get lifetime metrics:
1. https://developer.spotify.com/documentation/ads-api/reference/v3.0/getAggregateReport
2. https://developers.google.com/google-ads/api/docs/reporting/segmentation
However, on Fivetran, we only see the option to segment by month for Google, and day for Spotify.
It would be very beneficial for us to be able to get lifetime metrics from Fivetran.
-
Official comment
Hi Ethan,
Thanks for raising this feature request. I want to make sure we implement this correctly for you.How would you expect this data to appear in your downstream schema? Two options I have in mind:
- A table with a date column, and for each date, it provides the lifetime values for a given metric. E.g. total impressions for an ad as of February 1, 2025, and a separate row for total impressions for an ad as of February 2, 2025
- A single row per ad, with a _fivetran_sync column. Each row is updated during each sync with the lifetime value for metrics at that moment. You can't check the total impressions for an ad as of February 1, 2025. You can only check the total impressions for an ad as of today.
Thanks in advance for your input.
Cheers,
Luke -
Hey Lucas,
Option 1 would be more useful here. We're looking specifically to get a campaign's lifetime unique reach and frequency from Spotify and Google. Due to the nature of these columns, we can't just take the daily reach/frequency from our custom reports and sum them, because we would overcount duplicates.
Would you have a timeline for when this feature could be implemented?
Please sign in to leave a comment.
Comments
2 comments