Skip to main content

Dental marketing campaign tracking starts with a simple distinction: an inquiry, a booked appointment and an attended visit are different events. Record them separately, keep unknown sources visible, and agree on what your team will count before comparing campaigns.

The worksheet below helps a practice owner review a small campaign using aggregate counts. It does not need patient names, contact details or treatment information. Keep any individual records in the practice's approved system; this is a campaign review, not a second patient database.

Set the counting rules before the campaign#

Give each campaign a name your front desk can recognize, such as “Spring office announcement.” Record its channel, start date, review date and the person responsible for the report. If several channels carry the same message, decide whether you are reviewing the whole campaign or each channel separately.

Then define three stages:

  • Inquiry: a person contacts the practice about the campaign's purpose. Decide whether repeat calls from the same person count as one inquiry or several interactions. For this worksheet, count one inquiry per person within the review period.
  • Booked: an inquiry results in a recorded appointment. A request for a time is not yet a booking. Count a rescheduled appointment once under the rule your team has chosen.
  • Attended: the booked visit is recorded as attended by the review date. A booking still in the future stays booked; it has not reached this stage.

Use the same rules throughout the comparison. Your existing system may define these terms differently, so explain the mapping rather than quietly changing the numbers.

Copy this blank campaign worksheet#

Complete one record per campaign and review period. The fields describe the report; no patient rows belong in it.

Field
Your entry
Check before using it
Campaign and channel
______
Does everyone recognize the same campaign?
Start and review dates
______
Do counts cover the stated period?
Report owner
______
Who can resolve a missing or conflicting count?
Recorded campaign cost
______
Which costs are included or still missing?
Attributed inquiries
______
Is the source supported by your chosen rule?
Attributed bookings
______
Are duplicate and rescheduled visits handled consistently?
Attributed attended visits
______
Has attendance actually been checked?
Inquiries with unknown source
______
Are they kept outside the campaign total?

If you are considering Postmarkr as one channel, ask our team about mailing suitability. Describe the general job without patient details, recipient lists or letter files. This worksheet does not establish that a mailing provider is appropriate for patient information.

Record the source without forcing an answer#

Ask a simple question your staff can use consistently, such as “What prompted you to contact us?” Record the answer in your approved system. A campaign-specific reply code or a dedicated contact route can help identify the source, but a missing code is not evidence that the person never saw the campaign.

Agree on a short source list: the named campaign, another known source, multiple sources, and unknown. Keep the original answer available within the practice process so staff do not have to guess what a broad category means.

Dental Intelligence's lead-tracking article (opens in new tab) discusses recording referral sources when assessing marketing. The useful reporting decision is yours: choose a rule and disclose its limits. A person who saw a letter and later found your website should not automatically become two acquired patients.

A worked example with fictional counts#

Suppose a practice reviews one office-announcement campaign. The following figures are invented to demonstrate the worksheet; they are not Postmarkr results or a forecast.

Stage
Recorded count
What it means
Campaign-attributed inquiries
20
Source matched the practice's chosen rule.
Booked from those inquiries
12
An appointment was recorded.
Attended by the review date
8
Attendance was checked.
Still booked for a future date
3
Outcome remains pending.
Booked but not attended
1
No attended visit is counted.
Other inquiries with unknown source
5
Excluded from the campaign-attributed total.

The 12 bookings reconcile to eight attended, three future and one not attended. The five unknown-source inquiries remain visible without being assigned to the campaign.

To calculate recorded cost per attributed inquiry, divide the campaign cost included in your report by the attributed inquiry count. For recorded cost per attended visit, divide that same cost by the checked attended-visit count. Leave the calculation unresolved if its cost or count is incomplete, or if the denominator is zero.

These calculations describe the report at its review date. They do not establish profit, patient lifetime value or the visits that would have happened without the campaign.

Read the report before deciding what to repeat#

If inquiries are recorded but bookings are not, inspect the reply process and the completeness of the records before blaming the message. If bookings are mostly in the future, wait for the relevant outcomes rather than treating them as attended visits.

Look at cost completeness too. A printing or media invoice may omit design work or staff time. State what is included so a cheaper-looking campaign is not simply the one with fewer recorded costs.

Finish the review with one decision, an owner and a next review date. You might improve source capture, inspect unanswered inquiries or continue a bounded test. Keep the worksheet and its counting rules together so the next review compares the same stages. For related practice communication, see our dental mailing guides.

ready