-
Combined attribution dashboard?
My company uses Shopify for our e-commerce store. All of our ads use UTM tracking in the final URL, but since people usually take multiple touches before they make a purchase, a lot of these UTM tags fall off along the way. Meta, Google, and TikTok pixels help to fill in the gaps, as well as a post purchase survey that asks where they heard about us from.
My problem is having to juggle all of these different ad dashboards, plus random attribution from UTM tags from Shopify and survey responses.
Is there some kind of integration that would let me feed data from all of these sources and have it displayed on a single combined dashboard? Bonus points if they have attractive charts.
-
1 Reply
-
Positive we could build something custom in power bi but I’m not aware of anything off the shelf.
-
Supermetrics might do the trick.
-
manually import the data into a google sheet/ looker studio to clean the data (document all the operations you need to perform to make the data useable) and transform it into reports that work for all the stakeholders.
once you have finalized a layout. identify a trigger for when new data is imported automatically and parameters and operations that are needed to be done to segment it focusing on the goal of the report.
once all this is identified you can look into publically available google scripts or hire a developer to automate it with appropriate api documentations.
-
supermetrics with the sheets connector… then make your own graphs
Log in to reply.