Google, Facebook, Instagram, Mailchimp
Connected to: Facebook Ads, Facebook Page, Instagram Ads, Google Analytics, Adwords (through Analytics), and Mailchimp
An Automated spreadsheet report that pulls all of your marketing KPIs from 5 different channels with views for the Analyst, the Manager, even the VP of Marketing.
Notes on the Marketing Analytics spreadsheet template
Attention Digital Marketers! This is the one automated spreadsheet template that combines multiple channels worth of information into one "all-you-can-eat" spreadsheet. View your data per company title! The template includes a view for an analyst, a manager, and even a VP of marketing. We've even included a UTM builder and tracker so that you no longer have to go to the Google Campaign builder to create those pesky UTM links. With this tool, you can now bring in information from Google Analytics, Google Adwords (when connected to Google Analytics), Facebook, Instagram, Mailchimp, and more! Add more data feeds and formate it as you with. It's as easy as changing a spreadsheet formula.
Understanding the Spreadsheet
This report has specific tabs that were made per role. The executive Dashboard will give teams a great top-level view of their marketing channels in one place. Use the Campaign Planner tab to map out your marketing objectives and budgets throughout the year so that you can then track your achieved KPIs. Then use the UTM builder to start tracking all of your campaign links and then understand how each campaign behaved in one place. There are lots of ways to view your information. This spreadsheet gives marketers a great process to begin to track and analyze their data within minutes. Simply connect your "blue connected" tabs with your accounts and you're done.