A 5-step worksheet for turning scattered website, inquiry, and follow-up data into one practical decision each week.
When a small business loses a lead, the cause is often ordinary: an old service page, a form notification sent to the wrong inbox, or a promised follow-up with no date.
Reviewing website analytics, email, social media, and sales notes separately makes those handoffs easy to miss. The missing piece is not another dashboard. It is a repeatable weekly check that connects discovery to follow-up.
This is not a software-selection or process-mapping exercise. It is a recurring check for businesses that already receive inquiries and need to see where the customer path broke this week.
The following review takes 30 minutes. It moves through five stages: demand, website experience, inquiries, follow-up, and one test for the coming week. Use the tools you already have, meet at the same time each week, and finish with a named person responsible for a specific change and a date to review the result.
If your business receives only a few inquiries each month, keep the weekly operational check but judge trends across several weeks. One quiet week is not automatically a problem.
Before You Start: Define the Scorecard
Use one sheet of paper or one shared document. Agree on two definitions before the timer starts:
- Inquiry: a real person asking about a product, service, availability, price, or next step.
- Qualified inquiry: an inquiry that reasonably fits the customers, services, location, budget, or timing your business can support.
Use the same definitions and compare similar periods — for example, Monday through Sunday against the previous Monday through Sunday. That consistency matters more than building a perfect attribution model.
Minutes 0–5: Read the Demand Signals
Start where potential customers first encounter the business. That may be search, paid advertising, social media, referrals, calls, a marketplace profile, or foot traffic influenced by an online listing.
Do not inspect every metric. Ask four questions:
- Where did prospective customers find us this week?
- Which source or page changed the most compared with a similar period?
- Was the change concentrated in one service, location, campaign, or landing page?
- Did anything happen that might explain it, such as a promotion, outage, event, or referral?
Record one primary demand signal, the strongest source or entry page, and one possible explanation. Write down the likely reason, but mark it unconfirmed until the evidence supports it.
If search matters to your business, Google’s Search Console Performance report guide explains how to review the queries and pages producing impressions and clicks. Remember that attention is not the same as intent: an impression, view, or click does not prove someone was ready to buy.
Minutes 5–10: Check Whether the Website Did Its Job
Next, test the path a serious prospective customer is most likely to take. Open the key page on a phone. If time allows, check it on a desktop too.
Can a visitor quickly understand who the offer is for, what the business provides, and what to do next? Test the main phone, email, booking, and form actions. Send a clearly labeled test inquiry if that is the safest way to confirm the full handoff, including the confirmation message and internal notification.
Then review one important landing page. Look for a mismatch between the promise that brought the visitor in and the next step on the page. Check for outdated information, unclear buttons, broken actions, or a form that asks for more information than the business needs at first contact.
Analytics can show that a page has traffic without showing why visitors hesitate. If you already use a behavior-analysis tool, review only the relevant page or action. Microsoft’s Clarity documentation explains options such as heatmaps and session recordings; use any such tool with appropriate privacy and consent settings.
Record one defect or point of friction and whether you trust the measurement. Fix a broken path before debating design preferences.
Minutes 10–15: Account for Every Inquiry
Bring together inquiries from forms, calls, email, direct messages, referrals, and booking tools. You do not need a complicated CRM to do this. A simple list works if it is complete.
Record:
- total genuine inquiries
- qualified inquiries
- irrelevant or spam inquiries
- inquiries with an unknown source
- one question, objection, or need that appeared more than once
Do not confuse a larger inquiry count with a better week. A small number of well-matched inquiries may be more useful than a larger group the business cannot serve. Keep “source unknown” as a visible category instead of leaving the field blank. A recurring unknown tells you the intake process needs attention.
Repeated customer questions are also marketing data. If several people ask the same basic question, the answer may belong on a service page, booking screen, confirmation message, or FAQ.
Minutes 15–20: Find the Follow-Up Gaps
Open the inbox, CRM, or spreadsheet where you manage active opportunities. Every genuine inquiry should have a named owner and a dated next action.
Look for:
- a new inquiry still waiting for its first response
- an active opportunity with no owner
- a promised follow-up that is overdue
- a prospect with no next action or date
- one stage where several opportunities appear to be stuck
List no more than three urgent follow-ups. Assign each one to a person and add a date.
Avoid adopting a universal response-time benchmark that does not fit your business. The practical standard is whether you meet the expectation you set and prevent inquiries from being forgotten. If the business promises a same-day reply, the review should show whether that promise is being kept.
Minutes 20–30: Choose One Small Test
Use the final 10 minutes to choose the smallest change supported by what you observed. Do not leave with a long wish list.
If we [make one change] for [a specific audience or customer path], we expect [one measure] to move in [one direction], because this week we observed [evidence].
Then record the owner, start date, review date, and one guardrail — something that must not get worse while you improve the main measure.
Possible tests include:
- shortening a form after repeated incomplete submissions
- clarifying a service page after several prospects ask the same question
- routing inquiries to a backup person when the main contact is unavailable
- adding the next step and response expectation to a confirmation message
- repairing a broken mobile action before paying for more traffic to the page
Change one thing at a time when possible. If you change the page, offer, audience, and follow-up process together, it becomes much harder to tell what influenced the result. A low-traffic business may need to run the same test for more than one week; the weekly review can still confirm that it is operating correctly.
Copy This Weekly Scorecard
- Review period and comparison period:
- Primary demand signal and direction:
- Strongest source or entry page:
- Customer path tested:
- Website defect or friction found:
- Total and qualified inquiries:
- Inquiries with unknown source:
- Unanswered inquiries or opportunities with no next action:
- Main bottleneck in one sentence:
- One test, measure, and guardrail:
- Owner and review date:
The U.S. Small Business Administration’s Manage Your Business guide includes a marketing-and-sales section that can help connect this weekly check to a broader plan.
3 Rules That Keep the Review Useful
First, compare like with like. A holiday week, promotion, outage, or unusual referral can distort a simple week-to-week comparison. Note the context before drawing a conclusion.
Second, fix the handoff before adding more volume. More traffic won’t fix a broken form, an unclear offer, or an inquiry nobody owns.
For a broader view of how discovery, website experience, content, and follow-up work together, see the ADPH guide to building a digital growth system.
Third, end with a decision, not a report. The value of the review is not perfect attribution. It is the discipline of finding the most important break in the customer journey, assigning a response, and checking whether the change helped.
Thirty focused minutes will not answer every marketing question. It can, however, stop small gaps from becoming expensive habits — and give the owner a clear place to begin next week.
Allan Diel Caranguian (allan@adph-consulting.com) is the lead consultant at ADPH Consulting, where he helps service businesses, nonprofits, real-estate professionals, and growing teams connect their websites, search visibility, and day-to-day marketing operations. He also builds and maintains websites. Connect with him on LinkedIn.
Photo courtesy Curated Lifestyle for Unsplash+