Do you need advice on what to share?
ROI reports justify the resources allocated to social media campaigns.
In this article I’ll explore four important parts of a social media ROI report that decision makers want to see.
A Bird’s-Eye View of ROI Reports
Social media ROI reports are based on prescribed objectives, the progress of the social campaign tasked with meeting those objectives, the analysis of key performance indicators (KPIs) and whether the original objectives are met.
While traditional media (e.g., TV, radio ads and billboards) may have immediate results your clients and management can see, social media results usually take more time and are less apparent, making it difficult to convey the positive return on social investments.
The key to presenting a strong case for the ROI of social media campaigns is to track, analyze and present data that justifies the brand’s online investment.
In this article I’ll be discussing some of the key sections and data to include in your ROI report to do just that.
#1: Reiterate Objectives and Metrics
Before you started your social campaign, you and your client or management likely worked together to create a hierarchy of objectives, decided which social platforms to use to meet those objectives and established which metrics to use to track progress and success.
Some important metrics to look at and compare among platforms are reach and engagement. For example, note the number of Facebook fans exposed to the client or to other brands and sponsors. This allows you to convey the brand’s real reach and user reactions, and measure sentiment and virality.
In my ROI reports, I include primary metrics related to the client’s website, Facebook, Twitter and YouTube. You can include more platforms as you experiment and gather data and results from other platforms.
As a side note, I want to introduce you to some tools that may make your job easier.
Start with an Excel spreadsheet. You’re going to track a lot of data to compare and filter and compare again. Having a central place for that data makes analysis much easier.
Next, review the options below to find useful analytics for each platform.
Facebook Insights is available via a link on your page’s dashboard (and the data are invaluable when putting together your report).
#2: Share Data Analysis
When possible, download the data from relevant platforms to a CSV file and open it in Excel so you can categorize and compare it easily based on your KPIs.
While the majority of your report focuses on social media marketing, include a list of traditional media coverage over the same time period as well.
In sheet 1 of your spreadsheet, track how social media posts and traditional media were distributed over a specific time period and compare that time period for the same time last year. Include the percentage distribution of posts per season (e.g., winter/summer).
As you can imagine, it’s particularly important to pay attention to all audience interaction with your social updates.
Note every comment and all feedback on brand-related posts, whether negative, positive or neutral (color-coding these categories can help you keep track).
This record serves to identify sales opportunities, successes (and failures) in the purchase process and client feedback.
Put Google Analytics to Work for Your Business
Ever thought, "there's got to be a better way" when it comes to tracking your marketing activities? Are you forced to make decisions based on limited data? With the right training, you can use Google Analytics to measure all of your marketing efforts with certainty. You’ll stop the leaks in your ad spending, justify your marketing spend, gain the confidence you need to make better marketing decisions, and know what’s working at every step of the customer journey. Let the world's leading analytics pro show you the way. Check out our new Google Analytics for Marketers course from your friends at Social Media Examiner.
Because Facebook generally has a large influence on the success of a social campaign, it’s a good idea to report on your Facebook reach (the number of fans exposed to your updates).
Tell your client or management how Facebook posts (both organic and paid) impacted the overall reach to the primary and secondary target audiences and include the number of comments and shares. All of them together help measure sentiment and virality.
Another important way of showing success is to share the total number of fans and followers the brand gained as a result of the actions visitors carried out because of calls to action in your updates.
You should also keep a close eye on Twitter. Track hashtags to determine the reach and impact of tweets and retweets.
My company partnered with Fundesem Business School to host an event called #InternetCambiaTodo (Internet Changes Everything) and used a specific hashtag to assess the number of tweets that referred back to the brand.
We used Twitonomy to gather all sorts of key insights including the number of retweets with a brand mention, unique users, impressions, influential tweets, participation, common keywords and user location.
When you analyze data from the client’s website, you may need to look at various sources to discover where your traffic is originating. Keep track of general impressions and clicks on ads and banners you’ve placed for the brand, as well as how that incoming traffic completed or fell off the purchase path.
A boost in the number of people visiting the website increases the number of conversions and the chances that more people purchase your product or service. (And those numbers are directly related to the growth of social media fans and followers.)
Finally, tell your client which actions visitors completed once they entered the brand’s website and make recommendations on how to add more indirect value to the process.
Don’t worry if you don’t have much of the information mentioned here, you can substitute other relevant data that provides similar value.
#3: Report Co-Branding Results
What works for our company is creativity and co-branding. We implemented a contest for Mixcloud – Pioneer – Amnesia where the winner got to play one of the most important gigs on the planet.
Offering such a great prize guaranteed further reach and increased engagement on our posts, which we measured directly from each platform’s insights or analytics tools.
We were able to report that the contest resulted in 200,000 visits to the client’s website, exposure to our partner (Pioneer) among its potential target audience (the community of DJs, producers and electronic music aficionados), more than 25,000 new followers for the client’s Mixcloud account and 10,000 new followers for the sponsor.
Here is an example of how we presented our results for another co-branding campaign we did using the Talenthouse crowdfunding platform:
If you run online giveaways or contests in your campaign, report how many contests you host and the results of each. Be sure to show especially the growth in total number of new likes and comments, retweets, etc.
#4: Emphasize Return Actions
Your client and management really want to know whether the social media campaigns led to qualified leads and sales. Give them data on total sales, traffic and purchase intentions per week.
Include the type of audience that not only responded to the social updates, but also clicked through to the sales funnel as well.
Finally, calculate how may people purchased peripheral products including merchandise, images, DVDs, music, etc.
As you prepare a social media ROI report, your aim is to motivate the client or management to continue making a commitment to social media efforts.
Your client and management want to hear positive results of course, but don’t be afraid to present any negative mentions as well—just be sure to provide a solution for each negative instance.
Throughout your report, account for and promote any elements that support the investment (both time and money) made by your company, clients or sponsors (or to attract the latter to your brand).
Such elements aren’t purely social or digital, but rather anything that adds value to the organization (e.g., increased fans; more website traffic; or more leads, conversions and sales) and meets your overall objectives.
For maximum impact, use visual components in your report to convey important results, and share information in short, scannable paragraphs as often as possible.
When you’re ready to present your ROI results, PDF and PowerPoint are effective visual options to reinforce your findings.
What do you think? What other measurements would you include in your social media ROI report? How do you report on online investment results? Share your thoughts in the comments.