Are you a content marketer looking to show results for all of your content marketing campaigns?
Whether you’re marketing an e-commerce or a service-based business to consumers or businesses, an easy trick to try is adding the most important stats to your editorial calendar so you can plan in advance and turn your calendar into a detailed analytics report, as well.
Four Spreadsheet Functions You Need to Know
The basic functions in Excel you really need to know to have your sheets working for you are filter, sort, and the basic math functions like sum and average so you can quickly figure out useful information like average CTR by type of content or your highest performing email in terms of sales or leads.
How to Organize Your Tabs
- To get started, break each platform you use out into different tabs to plan campaigns out months in advance and track the results you care about the most.
- Then put “Date” in the first column so it’s all organized chronologically based on sending or posting schedule.
- Next, decide what you want to track on each tab such as sales, leads, open rate, click through rate, unsubscribes, and number of list sent to or impressions. You should also include variants like what each campaign is in regards to and who’s producing it, so you can filter to see which type of content and which content producers are showing the best results in relation to your marketing goals. These tabs can include things like:
- Social media posts
- Calls-to-Action (CTA’s)
- Landing Pages
Spreadsheets for Content Production
Besides planning content to send in advance and track the results of, spreadsheets are also great for collaborating with writers, designers, programmers, and other involved parties to efficiently produce work for managing different projects from website designs to social media graphics and more. For example, a project manager could create a website design spreadsheet or social media design spreadsheet with color coding to signify whose job it is and what stage each task is in, in regards to completion (TBD, missing, done). Because these projects can involve a lot of changing, detailed information from dimensions to SKUs to links, sharing an excel file that can be updated in real time can really help cut back on emails and again, make planning in advance a breeze.
After you’ve planned and sent your campaigns, be sure to go back and look at the results so you can figure out what’s working and what’s not. Good luck and may the numbers be forever in your favor!
Jackie is one of the Co-Founders of DMD. She’s a data nerd and a quality content lover. Based in Dallas, Texas she also loves great music, fashion, and barbecue.
Interested in our content marketing services?
Contact us below!