All lessons in this course
Social media ROI formula
ROI means return on investment. It shows what you got for the money and time you spent.
A result above 0% means social media earned more than it cost. At 0%, returns equal costs. Below 0%, it cost more than it returned, at least for that period.
Formulas to copy
- ROI
ROI % = (return - cost) / cost x 100
- Return
Return = sales traced to social - product cost of those sales
- Cost
Cost = hours x value of one hour + tools + ads + paid help
- Sheet cell
=(B2-B3)/B3*100
- Tagged link
https://yourshop.com/serum?utm_source=instagram&utm_medium=social&utm_campaign=october
ROI worked example for a small shop
Example: Fenna Skincare is a small online shop. The numbers are invented, and the amounts are in no particular currency.
Fenna's goal for October was 50 traced orders. Social media brought 38 orders that Fenna can trace through tagged links and a discount code. They came to 1,900 in sales. The products in those orders cost 500 to make, so the return is 1,400.
ROI = (1,400 - 800) / 800 x 100 = 75%. Each 1 that Fenna spent returned 1.75.
| Cost | What it covers | Amount |
|---|---|---|
| Time | 20 hours of planning, filming, posting and replies, valued by the owner | 500 |
| Tools | Scheduler, design app and photo props | 120 |
| Ads | One promoted post | 180 |
| Total cost | Everything social media took this month | 800 |
Costs to count and returns to measure
An ROI without time looks better than it is. Count every hour, including your own.
Time
Hours for planning, writing, filming, posting and replies. Give each hour a value and keep it the same every month.
Tools and ads
Subscriptions, design apps, stock photos and any paid promotion.
Tagged links
UTM tags at the end of a link tell your website analytics which network and campaign sent the visitor.
Sales codes
A discount code you share only on social, such as FENNA10. Each use is a sale you can trace.
Leads
Enquiries, bookings and sign-ups that came through a social link.
A checkout question
A "How did you hear about us?" field finds people who never clicked a link.
UTM tags are three short labels added to a web address. Source names the network, medium names the kind of traffic and campaign names the month or offer. Use the same spelling every time, or your analytics splits one source into two.
SMART social media goals
A SMART goal is specific, measurable, achievable, relevant and time-bound. It turns a wish into a line you can check at the end of the month.
Link each goal to money or a contact where you can, such as orders, bookings or enquiries. Keep one awareness goal if your account is new, because sales need people who know you first.
Vague goal
- Grow on Instagram
- Get more engagement
- Be on TikTok
- Make sales from social
SMART goal
- Reach 6,000 accounts a month on Instagram by March
- An average of 8 comments per post by April
- Three TikTok videos a week for 12 weeks
- 40 orders with code FENNA10 between April and June
Limits of social media ROI
Some value never appears in a link. A customer sees five posts, then types your name into a search engine a week later. Another hears about you from a friend who follows you. Neither leaves a tag.
Treat ROI as the minimum, the part you can prove. Add the rest as notes in your monthly report, such as messages from customers, press requests and buyers who mention your posts.
ROI mistakes
MistakeNot counting your own time as a cost
FixLog your hours for one month and give each hour the same value.
MistakeCounting sales instead of profit
FixSubtract the product cost of those sales, or say clearly that you used sales.
MistakeClaiming every sale from a busy month
FixCount only sales you can trace with a tag, a code or a checkout answer.
MistakeCalculating ROI after one week
FixUse at least a full month, and compare the same months a year apart when you can.
Your task this week
- 1
Log every hour you spend on social media for the next seven days.
- 2
Add one tagged link and one social-only discount code to your next posts.
- 3
Write one SMART goal for next month with a number and a date.
You are done when your sheet holds a week of hours, one tagged link and one SMART goal.