Hi there !
I’m working on Facebook Ads data in Supermetrics for Google Sheets and I’m encountering an issue.
I need to extract Reach data (among others) for Awareness campaign analysis over time, but for some campaigns, not all.
The simple scheme is :
- Dimension : Year & Month
- Metrics : Reach, Impressions, Thruplay Actions
- Filter : Campaign Name CONTAINS “US” (or any other filter it seems)
I get the Can’t be calculated, would require summing deduplicated values.While I understand why I get this issue (the fact that Reach can’t be summed), I wanted to know if there is a workaround with Supermetrics, or if anyone find one out of it ?
The aim is to avoid manual extraction of this data, as you can presume.
Thank you for your help,
Georges