How well is your company performing in Social Media? How to do a Social Media Audit? Find answers to these questions and download this Social Media Audit Excel Spreadsheet template now!
This Social Media Audit spreadsheet in MS Excel is the first step when you want to bring your social media strategy to a higher level. After creation of the Spreadsheet, you need to write down all the social networks.
As you go through this a Social Media Audit Spreadsheet you’ll see that the spreadsheet will start automatically adding new columns. To start, create a column for each social network you are promoting your business in. Mention the URL to your profile on that social network, and owner. The ‘Owner’ records are very important in a later stage, if you want to go back to find all the Social Media that are promoting your business, and to see if they are still there. Therefore its highly important to keep track of this information. it allows you to know who owns the password and who is in charge of posting and engaging with followers on that social profile. The following columns can be found in the Social Media Audit Spreadsheet form:
- Profile Name;
- Last Activity;
- Posting Frequency;
- Referral traffic (monthly);
- % change last year;
- % change last month;
- Clicks / post;
- Clicks / post (previous month);
- Clicks change from previous month;
- Facebook reach;
- % change last week;
- Followers today;
- Followers last month;
- Followers change.
Using this Social Media Strategy template guarantees you will save time, costs and efforts!