Skip to main content

 

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,

Hi Selma,

Thanks for reaching out!

This sounds like a classic case of last-click attribution, for which we have a blend template: https://support.supermetrics.com/support/solutions/articles/19000165531-how-to-use-data-blending-templates

I would be happy to go through it with a call with you and make sure you get your data as expected. I will reach out to you directly via email to share a link with my availibility.

Best regards,

Mick - Product manager


Reply