Design an Offline Lead-Source Capture Process for Local Campaigns

Overview

Why offline attribution gets lost

A printed flyer, a shop sign, a local event, a referral, and a paid social campaign can all lead to a phone call or walk-in. If staff record only the customer’s name and sale amount, the business later has no reliable way to understand which activity generated interest. Guessing from memory is tempting, but it creates confident-looking reports with weak evidence.

Offline source capture is not about assigning perfect credit to every sale. It is about collecting enough consistent information to make practical budget decisions. A short question asked at the right moment, combined with a small source list and a way to record uncertainty, is often more valuable than an elaborate attribution model nobody maintains.

Create source choices customers can understand

Start with the channels the business actually uses. Examples include shop signage, printed flyer, local event, customer referral, Google search, social media, WhatsApp, repeat customer, and other or not sure. Avoid creating separate categories for every tiny campaign before staff can reliably distinguish them.

Use two fields when necessary: “How did you first hear about us?” and “What prompted you to contact us today?” A customer may have known the business for months but acted after seeing a recent offer. Those answers describe different stages. If you only need one field, choose the question that best matches the decision you want to make and keep the wording stable over time.

Ask without steering the answer

Train staff to ask neutrally: “May I ask how you heard about us?” Avoid leading questions such as “You saw our Instagram offer, right?” which encourage customers to agree. Make “not sure” an acceptable answer. Do not pressure people to disclose personal details or imply that a purchase depends on answering.

For phone enquiries, ask after the immediate need has been acknowledged rather than opening with an interrogation. For walk-ins, a small prompt at checkout or on an enquiry form may work better. If the customer mentions more than one source, record the answer according to a documented rule—for example, first-known source plus current prompt—rather than letting each employee choose whichever channel they prefer.

Give every source a practical definition

A source dictionary prevents inconsistent coding. “Referral” might mean a person directly recommended the business; it should not automatically include a customer who saw a public review. “Google search” should not be used for a person who clicked a paid ad if the staff can distinguish that. “Social media” should not be split by platform unless the customer knows or tracking evidence supports the detail.

Keep the dictionary short and include examples of borderline cases. If a new campaign requires a category, add it deliberately and note the date it became available. Do not rename old categories mid-reporting period without a mapping, because a change in labels can look like a change in performance.

Reconcile source records with outcomes

Record the source near the time of the enquiry, then connect the enquiry to a final outcome using a non-sensitive reference such as an enquiry number or order ID. Outcomes may include sale, appointment booked, quote sent, no response, not a fit, or still open. The source and outcome should be separate fields: a referral can produce no sale, and a paid campaign can produce a high-value sale.

At a regular interval, compare a sample of enquiry records with the sales or booking system. Look for missing source values, inconsistent categories, duplicated enquiries, and outcomes that were never updated. Reconciliation is more reliable than asking staff to reconstruct the month at month-end. Keep the process small enough that it can be completed on schedule.

Interpret the results cautiously

A source with many enquiries is not automatically the best source. Compare qualified enquiries, conversion, revenue where appropriate, and the cost of the activity. Include the observation period and denominator. Ten sales from 100 enquiries is different from ten sales from 20 enquiries, but small counts can also be unstable.

Remember that a customer’s answer is self-reported and may not capture every influence. A poster may have built awareness while a search result prompted the visit. Use source data as one evidence stream alongside campaign spend, tracked links, and staff observations. Avoid attributing all revenue to the last touch unless that is an explicit and consistently applied reporting convention.

A simple weekly operating routine

Assign one person to check missing values and obvious miscoding once a week. Review the top source categories, the share marked not sure, and whether outcomes are being updated. If “other” becomes large, inspect examples before adding more categories. If staff skip the question when busy, simplify the prompt or move it to a better point in the journey.

Document the source dictionary and reporting rule beside the sheet or CRM. Revisit it when the business adds a new channel, changes the sales process, or opens another location. The goal is not perfect scientific attribution; it is a repeatable record that helps the business make less speculative decisions about local marketing.

Practical checklist

• Ask a neutral question and allow uncertainty.
• Separate how a customer first heard about the business from what prompted action.
• Reconcile source values with outcomes and treat attribution as evidence, not certainty.

Conclusion and next steps

Begin with a short source list and train staff to ask the same neutral question. After several weeks, reconcile enquiry records with sales and inspect the “other” and “not sure” categories before adding complexity. The result will not prove exactly which channel caused every purchase, but it will replace memory-based guesses with a more consistent evidence base.