What is your goal?
I’m trying to build automated marketing reports with full insights inside Make.
The goal is to connect our advertising platforms (Meta, TikTok, Snapchat, Google Ads) and generate complete daily/weekly reports that show:
Spend
Revenue
ROAS
MER
CPC
CPM
CTR
Purchases (paid vs organic if possible)
Creative link( if possible)
We want the reports to come in Google Sheets with all metrics included.
What is the problem & what have you tried?
The issue is that not all metrics are being pulled correctly.
Some KPIs come through, others appear as null, incomplete, or missing entirely.
What we’ve noticed:
Some platforms return partial data only
Purchase events or revenue values don’t always appear
Some insights exist inside the ads manager, but Make doesn’t fetch them
Tried different endpoints, fields, and filters — same results
Also tried manual API calls inside the module (fields), but still incomplete
We’re not sure if:
We’re using the wrong endpoints
We’re missing required permissions
Or Make simply doesn’t support certain insights directly
We need guidance on how to fetch full, accurate reporting KPIs.