How to Tell Whether Social Media Is Bringing Customers
A free weekly worksheet for separating views, visits, inquiries and actual sales—with a way to decide what to change next.
Start with one action you can actually observe
A useful social-media report connects a post to the next customer action and then records what happened. For a café, that could be a tracked order or a customer mentioning the post at checkout. For a venue, it might be a suitable couple requesting a tour. Choose one action before counting followers. Keep views as an attention measure, not a sales total.
The restaurant discussion linked below asks exactly this question: videos received views, but the person helping the café could not see a clear business change. That is evidence of a question being asked, not proof of how often it happens or of any strategy working.
Give each post a job
Write down the post, its intended customer, the offer shown and the next step. For example: a bakery’s morning pastry sequence → people close enough to visit → today’s menu and opening hours. A landscaper’s patio project → homeowners in the service area → an inquiry about similar work. A wedding venue tour → couples considering that location → availability and tour request.
Keep a simple private record with one row per post and a second record with one row per inquiry or sale. The downloads below give you both. Do not put customer names or contact details in a shared marketing sheet; use a reference ID that your team can match to its private customer records.
Use links and customer answers together
If your website analytics supports campaign tags, label the link you control with a consistent source, medium and campaign, such as utm_source=instagram, utm_medium=organic_social and utm_campaign=autumn_menu. Use utm_content only when a distinct link genuinely identifies a specific post or placement. Google’s documentation below explains these traffic-source fields.
A shared bio link cannot reliably tell you which video prompted the visit. Record it as Instagram bio traffic unless you have additional evidence. Ask an optional question at inquiry or checkout: “How did you first hear about us?” Keep the customer’s answer alongside the recorded link source. If someone says a friend sent a video, keep both pieces of information instead of forcing one attribution label.
For a physical business, Google Business Profile interactions can add context. Its call metric counts clicks on the call button; direction requests are requests, not verified arrivals. Record those separately from completed calls, visits and orders. Do not add them together as customers.
Keep the outcome record honest
For every inquiry, record whether it matched your location and service, whether someone responded, and whether it led to a booking or purchase. An inquiry becomes qualified when it meets criteria you set in advance, such as relevant service, service area and realistic timing. Only enter revenue after the transaction occurs; keep refunds separate. One purchase with several touchpoints stays one purchase.
Record unknown source as unknown. A zero means you checked and observed none; a blank means the information is missing. This distinction prevents a missing report from looking like poor performance. Delayed bookings should remain open until the decision is resolved rather than being counted as losses at the end of a short reporting window.
Review the step that is failing
Use the same reporting interval for comparable posts. If few relevant people see the content, examine the subject, first frame and distribution. If people watch but do not visit the profile, make the business and its relevance clearer. If they visit the profile but do not take the next step, check location, offer and link. If suitable inquiries arrive but no one replies, fix follow-up before making more videos.
If inquiries are the wrong fit, clarify the service or availability before the click. If the right people inquire but do not buy, investigate price, timing, experience and offer fit; editing alone may not be the constraint. Change one major variable at a time and note it in the worksheet so the next review has context.
Use ratios without pretending they prove causation
You can calculate qualified inquiries divided by observed campaign visits, and purchases divided by qualified inquiries, when the records refer to the same cohort and window. Keep the numerator and denominator next to the ratio. Three inquiries from a small number of visits can be useful to investigate, but it is not a stable forecast.
Compare time and costs with actual business outcomes. Weather, seasonality, events, promotions and referrals can change sales alongside social activity. This worksheet supports better decisions; it does not establish how many sales would have happened without the content. For a venue with a long booking cycle, review open inquiries over time. For a café, also record current availability and service hours.
Get help applying it
Want help applying this to your business? Tell us what you sell, who you want to reach, and what material you already have. Cole can discuss whether working together makes sense. Sending an inquiry does not enroll you in a course or commit you to a purchase.