Hi Supermetrics team,
I’m reaching out for help setting up a custom and automated report that fits my business needs.
I run ads on Facebook, TikTok, Google, and Snapchat, each with multiple ad accounts. I also use Shopify as my e-commerce platform.
I manage a catalog of 17 cosmetic products (haircare and skincare), and I run campaigns for each product across all four platforms and accounts.
To make tracking easier, all my campaigns across every platform are named using the product name.
Here is what I’m trying to achieve:
-
A daily automated report, showing data per product
-
For each product:
-
The total ad spend (combined across all platforms and ad accounts)
-
The number of conversions from Shopify
-
The spend for each product from yesterday specifically
-
Is this possible to set up with Supermetrics? And if so, could you please guide me on how to structure my data sources and create this kind of report? A template or example would be extremely helpful.
Thank you very much for your assistance,
Best regards,