SOCIAL MEDIA ANALYSIS

Click here to find out what this is about, and how it can help your business

Most businesses use social media, but do we have a plan? Do we know how our social media is performing, and is it achieving our objectives? This is often something which we just don’t know. These spreadsheets are designed to help us find out.

We have created spreadsheets for five different ‘social media’ platforms. LinkedIn, Facebook, Twitter, YouTube, and Google Analytics (which monitors hits to our websites). So how do these work? They are all designed to accept data which you can export from each of the sites, which show data from your account. Simply download each set of data from each site periodically, copy the data, and then paste the values into the respective spreadsheet. (Just remember to use paste VALUES and not normal paste).

There is also a sixth spreadsheet, which will combine data from each of the five others, and then allow you to assign points to each social media ‘action’. So for example, how do you rate a Facebook like compared to a LinkedIn share? We each need a plan with our social media, and assigning value to each target action, is a good way to help us to determine our plan. Once this is done, the spreadsheet takes all of the actions on all of the sites, and converts them into points. It then compares the points over the year, to give us a good indication as to where we have been successful, and where we need to focus some effort.

So please download any of the spreadsheets you wish, they are all free and have no ‘pay to unlock’ content, although we do ask that you sign up to receive our monthly email newsletter to receive the sixth spreadsheet which compares platforms. Please follow the instructions on each spreadsheet to get the most out of them, and take a look at the demo videos (links on the spreadsheets). You can compare your download to the version shown below, to make sure you have the latest version.

We hope that these really help you.

 

 

LINKEDIN COMPANY PAGE ANALYSIS

Version 1.002

This is the first version of this type of spreadsheet (linked with the Social Media Report). Any instructions on how the future spreadsheets have been updated, and how to switch over to them, will appear here.

FACEBOOK ANALYTICS REPORT

Version 1.002

This is the first version of this type of spreadsheet (linked with the Social Media Report). Any instructions on how the future spreadsheets have been updated, and how to switch over to them, will appear here.

TWITTER STATISTICS ANALYSER

Version 1.002

This is the first version of this type of spreadsheet (linked with the Social Media Report). Any instructions on how the future spreadsheets have been updated, and how to switch over to them, will appear here.

YOUTUBE ANALYTICS REPORT

Version 1.002

This is the first version of this type of spreadsheet (linked with the Social Media Report). Any instructions on how the future spreadsheets have been updated, and how to switch over to them, will appear here.

GOOGLE ANALYTICS BREAKDOWN

Version 1.002

This is the first version of this type of spreadsheet (linked with the Social Media Report). Any instructions on how the future spreadsheets have been updated, and how to switch over to them, will appear here.

The spreadsheets above are all free to download, now sign up to receive our monthly newsletter, and receive the final spreadsheet below.

SOCIAL MEDIA ANALYTICS REPORT

Version 1.002

This is the first version of this type of spreadsheet. Any instructions on how the future spreadsheets have been updated, and how to switch over to them, will appear here.

If you’re wondering how the final spreadsheet works, take a look at this demo video, where we explain how all of these spreadsheets work together to give you an overall view of your social media.

You don’t need to use all of the social media spreadsheets to use the final spreadsheet, but you will need to use at least two of them to compare, one if you just want to see the points.

If you’d like to discuss your own custom made spreadsheet, click the button below.

Please help us share the word about these free downloads by sharing this page on your preferred social media site. We’ve even made it easier for you, simply use the links below. Thanks very much!