How to forecast sales from your social media activity

Key takeaways

Forecast sales from social media by multiplying your own funnel ratios: expected reach or profile visits, times the share who enquire, times the share who buy, times average order value. Use the last three to six months of your own numbers, not industry averages, and check the forecast against actuals every month.

• Forecast = visits × enquiry rate × sale rate × order value.
• Use 3 to 6 months of your own ratios.
• Plan staff for the enquiries the forecast implies.
• Compare with actuals monthly and adjust.

Why forecast sales from social media?

Forecasting turns social media from a cost into a planned source of revenue. It lets you set a budget against expected sales, plan who will answer enquiries, and spot quickly when something changes. A forecast that is roughly right is far more useful than none.

• How UK businesses can turn social media followers into customers
• The business case for consistent social media

How do you build the forecast?

Start from the stage you can best predict, usually profile visits or website sessions from social, then apply your own ratios. Use a three- to six-month average for each ratio to smooth out unusual months.

• Profile visits next month: 800.
• Visit to enquiry: 3% = 24 enquiries.
• Enquiry to sale: 25% = 6 customers.
• Average order value: £900 = £5,400 forecast sales.
• All figures are illustrative.

• Social media sales funnel: from first follow to first sale

How do you forecast the effect of changes?

Model a change by adjusting one ratio at a time. If faster replies are expected to lift enquiry-to-sale from 25% to 33%, the same 24 enquiries give 8 customers, or £7,200. Keep the assumption modest and test it, rather than assuming every improvement at once.

How does the forecast help with staffing?

The forecast tells you how many enquiries to expect, which tells you how many hours replying and quoting will take. If a campaign is forecast to double enquiries, plan who will answer them before it runs. Unanswered enquiries are the most expensive way for a forecast to fail.

• Who handles social media enquiries? Fixing the handover

How do you check the forecast?

Compare forecast and actual at each stage every month. If visits were right but enquiries were low, the path or offer changed. If enquiries were right but sales were low, follow-up or price changed. The stage that missed tells you where to look.

• Track social media conversions in GA4, step by step

What are the limits of forecasting?

Forecasts depend on platforms behaving as before, and they do not: reach changes with algorithm updates, seasons shift demand, and one viral post distorts a month. Treat the forecast as a range, review it monthly and do not commit fixed costs on the top of the range.

• Social media reach dropped? What to check first

What does this look like in practice?

A pattern we see: a business runs a campaign that doubles enquiries for a fortnight, but nobody planned for the volume and many go unanswered. A one-line forecast before the campaign would have shown the hours needed.

• See client work
• Social Media Marketing for UK businesses
• The follower conversion scorecard: find where buyers drop out

Forecast checklist

• Collect three to six months of funnel numbers.
• Calculate average ratios.
• Forecast each stage for next month.
• Plan staffing for forecast enquiries.
• Compare with actuals monthly.
• Use a range, not a single number.

Next step

Write next month's forecast on one line using your own ratios, and put a reminder in your diary to compare it with actuals.