“We don’t have a choice on whether we do social media, the question is how well we do it?” – Erik Qualman
This is the start of your Social Media Report Template.
Enter your basic information in the form fields below.
If you already have social media and management tools select the appropriate option from the dropdown below. This will take you directly to the Report process.
If not, don’t worry. Select the appropriate option from the dropdown below and this will take you through to setup.
This social media report template will also need you to use some management and analytical tools alongside your social media accounts.
Once you have done the research set yourself up accounts in tandem with this Social Media Report Template checklist.
Management accounts ensure that your social media strategy runs smoothly. They automate posting and take the stress away from posting on-time.
There are lots of 3rd party posting apps, Saas, and management tools out there.
These are some of the more popular options (many of them have both free and premium options):
Much like the social media channels themselves, the tool you should use depends on what you want to achieve.
Get researching and once you have set up an account with your tool of choice enter it into the form field below.
Create a calendar to keep track of your content.
Many of the management tools have a calendar incorporated into the software. The image below features Hootsuite’s calendar. Having a content calendar provides a space for you to manage ALL of your content which is important if you are using multiple tools.
Using a content calendar such as Google Calendar or Airtable also allows you to invite people to view the calendar. This is really useful if you plan of bringing in a content creator or social media manager.
Within Google Calendar anyone with access can view and edit based events.
Another useful calendar tool is Airtable. Check out the Youtube video below to understand how to create a content calendar within Airtable.
Organize analytic tools for social media channels.
Whilst we appreciate that there are a variety of analytical tools out there. This Social Media Report template will use Google Analytics as its reference point for using analytical tools.
For the record, some other options are:
Google Analytics shows you what content your audience responds to and the social networks they prefer. By analyzing this data you can drive more traffic and leads to your social media channels and ultimately your business or brand.
Think about what you want to achieve with social media.
If you have a business plan and marketing strategy then open those documents and revise the core values, mission, vision, and future plans. Bear all of that information in mind when constructing your goals for social media.
Ensure that your social media objectives align with your overall company vision, mission, and marketing strategy. Be as specific as possible whilst ensuring that the goals are measurable, attainable, relevant, and time-bound.
Refine your ideas into three specific targeted goals.
Here are some examples of goals:
When you are ready, write down your goals in the form fields below.
What is the mission statement of each of your social profiles?
Track progress, see what content is working and bringing in traffic and what isn’t.
You will need to wait one month after setting up your social media platforms before progressing to this next section. There is a due date set-up that will let you know when it is time to complete the report. However, feel free to have a look through each of the tasks to get an idea of what to monitor throughout the coming month.
Use this section to guide you in measuring the impact of your social media marketing efforts.
Analyzing the raw data on campaign performance helps you determine which tactics are working.
Gather organic data.
Download the excel sheet and use it as a template and or the subtasks to create your own document to record all data.
To recap, metrics are important because they tell if a campaign or strategy is successful over time.
You can edit this sub-checklist to include the key metrics you want to track.
Use this section to record any stand out results.
Highlighting the standout results is great for comparing data between different months. It is also very useful when choosing future content, setting goals, and optimizing your social media strategy.
The information you record in this section will be used to analyze progress of your social media channels. Keep your goals, missions, and overall vision in mind when filling out the next tasks.
You will use the data inputted into this section to compare it to assess the overall progress of your social media.
Wondering which social media metrics you should focus on for your analysis?
There are a variety of success metrics or Key Performance Indicators (KPIs) to choose from. A good way to direct your analysis is by focusing on your overall goals and missions.
Compare the data you have gathered with your goals and mission.
Use the form fields below to record the key takeaways and ideas for improvement.
When determining the key takeaways consider the following:
How many people are participating, how often are they participating, and on what channels are they participating?
If you have a website or e-commerce store, is social media getting people to visit your site? What do they do once they’re on your site?
Is there any conversation about your brand within your industry, if so, how much?
Establish four ideas for improvement.
How will you optimize the performance and progress across your social media channels?
You have identified a number of opportunities to improve your social media channels.
More often than not, carefully reviewing performance metrics and evaluating interaction with audiences highlights some ways in which you can optimize service delivery.
Transform these opportunities built of your key takeaways and ideas for improvement into clear action items.
If you’ve connected with Zapier then complete this task to export the report.
Export your report using Zapier.
Below Process Street has outlined how you can send your audit report from Process Street to Google Documents using the application Zapier.
Once you have created the Zap, whenever you run this checklist an external report will be generated automatically with one click.
Create a free account with Zapier here.
Finally, confirm the date of the next social media report.
We recommend conducting social media reports once a month and have a due date for one month from now built into this checklist. This means that you will be reminded in a month’s time to run the Social Media Report Template again.