4 Spreadsheet tips for Social Media Managers

Do you struggle with Spreadsheet? Many of us do! However, it’s still pretty simple way to keep track of the quantitive aspects of the social media accounts that you’re managing.

So what exactly are Excel functions? Functions show a relation between a set of inputs and a set of outputs, where each input has exactly one output. In Excel, functions take the data from your workbook (the input) and turn them into information (the output) through a specific syntax. For example, you may be familiar with something like SUM.

SUM

Syntax refers to the way the function is ordered, so that it returns a result. Each function starts with an equal sign (=) and are followed by the name of the function itself. Example: =SUM(A1, A2) This means that the cell you entered this function into will add the contents of cell A1 and A2. Pretty easy, right? Now, we’ll try something a little more complex. Say you want to find out how many Likes the post of a 2 months long campaign obtained.

Go to Functions in the upper bar-> select SUM-> select the cells that you want to sum.

spreadsheet social media

These functions are all particularly useful when you’re trying to get a day count to average something like engagement over a period of time. You would use a function similar to: =A1/(DAYS(“4/1/14”, “1/1/14”)) Where A1 is your engagement number and your date range is from January 1 to April 1.

IF

IF is a function that is useful when you have True/False criteria and you want to do one thing when the criteria are True and something different when the criteria are False.
Example: =IF(A1>10, “yes”, “no”) In the above example, if the value in cell A1 is greater than 10, the function would return the word “yes”. This comes in handy when you want to find specific data.

COUNTIF

COUNTIF lets you count items based on a set of criteria and SUMIF lets you sum items based on a set of criteria. Example: =COUNTIF(A2:A5,”apples”) Here, Excel will count how many cells in the A column contain the value “apples”. This comes in handy when you want to count or add cells based on specific data.

SUMIF

Example: =SUMIF(B2:B25,”>5”) In this function, if the value of a cell in the B column is greater than 5, Excel will add those values together.
You could find out how many Tweets you sent between April 10 and April 15 with COUNTIF. If you wanted to find the total engagement on those same Tweets, you would add up all the retweets, mentions, @replies and favorites in between those two dates using a SUMIF.

Helpful?
Hope it was 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s