Hi,

TLDR;

I’m looking for a way to export the cost of all active campaign data to Mixpanel from Google Ads, Facebook Ads, Pinterest, TikTok and Bing.

Context
Currently we have an unstable setup where we export all the Social Media data to a Google Sheet with Supermetrics, which on it’s own used an extention within GSheet to sync the data into Mixpanel. 

I was hoping to convert this workflow into a Zap where I take the data from each platform, once a week, and combine all costs, clicks and impressions to a single row and send it to Mixpanel.

The “send it to mixpanel” is the part that works. Yet, getting all the data from Google Ads is a different story. It looks like i need to manually select each active campagin before i can send it over. This means that if a new campaign is created, i have to add it to the Zap. Something that should be automated aswell.

Anyone has an idea how to fix this?

Best,

Sjerd