Which lead source produced the appointment? Build an attribution record you can trust
Connect vendor IDs, UTM fields, campaign enrollment and appointment outcomes without overwriting the original source of an insurance lead.
·4 min read
A lead arrives from a vendor, receives two texts, replies to a callback campaign and books with an agent. If the CRM now labels the source only as 'Callback campaign,' the acquisition report loses the information needed to evaluate the vendor.
Attribution becomes useful when you separate where the person came from, which communications they received and what happened afterward. You do not need an elaborate model to begin; you need consistent fields and a clear question.
Keep acquisition source separate from campaign membership
Record the originating channel, vendor name, external lead ID and acquisition timestamp. For web traffic, retain the available UTM source, medium and campaign values at intake. Store identifiers as text so leading zeros and vendor prefixes survive imports.
A CRM campaign is an operational sequence, not a substitute for an acquisition source. Keep enrollment records with campaign ID, enrollment time and exit reason. Reenrolling the person later should add history rather than rewrite the original vendor.
Define the outcome and its timestamp
An appointment requested, an appointment booked and an appointment attended are different events. Choose the event you want to explain, then capture its time and stable contact or appointment identifier. Repeated reschedules should not appear as several newly acquired customers.
For example, a quote-request lead purchased on Monday may book on Thursday after a Wednesday reply. Preserve all three dates. They reveal acquisition age, follow-up timing and the delay between conversation and booking.
Start with two understandable views
A first-source view groups outcomes by the original acquisition channel. It helps answer which vendor or website generates useful opportunities. A latest-eligible-campaign view groups outcomes by a defined recent enrollment or interaction. It helps evaluate the follow-up process.
Neither view proves causation. A booked lead may have interacted with several campaigns and a phone call. Label the attribution rule, its lookback window and how overlapping activity is handled. Avoid presenting two attributed totals as additive revenue.
Reconcile a small sample before trusting the dashboard
Choose ten booked appointments and trace each from intake to outcome. Confirm source fields, duplicate merges, enrollment history and agent ownership. Check a contact that changed agents and another that returned after several months.
If records disagree, fix the intake mapping or outcome event before expanding the report. A beautiful chart built from overwritten fields produces confident but unreliable decisions. Keep unknown sources visible instead of assigning them to the most convenient channel.
Use the report to choose the next experiment
Compare sources on comparable cohorts: acquisition period, product interest, eligible audience and observation time. Include lead cost, delivered contacts, useful replies, booked appointments and attendance when those records are available.
Suppose Vendor A has more bookings but Vendor B has more attended appointments per dollar. That suggests a different purchasing decision than booking volume alone. Change one intake or follow-up variable at a time, document it, and evaluate after the agreed observation period.
Key takeaways
- →Preserve original source and vendor IDs through later campaign changes.
- →Record bookings, reschedules and attendance as distinct outcomes.
- →Publish the attribution rule alongside the report.
- →Audit real contact histories before using source metrics to buy more leads.
Put this into practice with Text2Sale
Import leads, create follow-up campaigns, organize replies, and connect texting, calling, and appointments in one workspace.
Frequently asked questions
Should I use UTM campaign as the CRM campaign name?
You can map the value into a separate acquisition field. Keep the CRM campaign's own identifier and enrollment history because one acquired lead may later enter several follow-up sequences.
Which attribution model is best for a small agency?
Begin with original-source reporting and a clearly labeled recent-campaign view. More complex weighting is useful only after source, interaction and outcome records are dependable.