Tempio

Media plan template for Healthcare

Free download as CSV and Markdown. Nothing sits in front of the file: no form, no account, no email address.

The files

What it is

The media plan with five columns a clinic, provider or health product needs: which service line the row sells, who it is aimed at, what the platform will not let you target, the reference of the review that cleared its claims, and what the row counts as a result.

Everything else is the general plan, unchanged. One row per line of spend, budgets as integers in minor units, one currency named per row, and a target column that ships blank because the number is yours.

When to use it

Use it when the audience you would most like to reach is the one the platform will not let you build, which is the normal condition of health advertising. A plan written as though condition-based targeting were available will be rebuilt in the launch week, and the rebuild always costs more than writing it correctly the first time.

Write it before anything is built, and re-read it whenever a service line changes what it offers or a platform changes what it permits. Both happen more often than a quarterly rhythm catches, and the plan is the only place every affected row is listed together.

Every field, and what belongs in it
TypeHow to fill it
ChannelTextThe platform the row runs on, one per row. A channel carrying two service lines carries two rows, because the two will not share a review or an attendance rate.
CampaignTextThe campaign name written the way the ad account will display it, so spend by service can be traced without a translation step.
ObjectiveTextWhat the row is bought for: prospecting, retargeting, retention, a launch. One per row, because a row with two objectives is judged on whichever one reads better.
AudienceTextWho the row is aimed at, written inside the targeting the platform will actually permit: a location radius, a life stage, an interest that is not a health signal.
Service lineTextThe service or product this row sells: a clinic service, a device, a programme, a software product. It sets the claim review, the audience type and the definition of a result at once.
Audience typeTextWho the row is aimed at: a patient, a carer, a referring practitioner, an employer. The four respond to different messages and only some of them can be reached by the obvious targeting.
Targeting limitsTextWhat the platform will not permit for this row, named rather than implied: no health-condition targeting, no personalised wording, restricted age or location rules. It stops a plan assuming an audience it cannot build.
Claim review referenceTextThe identifier of the review that cleared this row's claims, with the date. A row with no reference is a row whose wording nobody has read against what the service can actually say.
Result definitionTextWhat this row counts: an enquiry, a booked appointment, an attended appointment, a referral. Written here because the four differ by a wide margin and are often reported as one.
Flight startDate (YYYY-MM-DD)The first day the line is meant to spend, and never earlier than the date its copy cleared review. ISO order so a sheet sorts it and two people read the same day.
Flight endDate (YYYY-MM-DD)The last day, inclusive. A line with no end date is a line nobody reviews, and an unreviewed line is the one still carrying last year's wording.
Budget (minor units)IntegerThe budget for this row in the currency's smallest unit, so 1,500.00 appears as 150000. Whole numbers, because a decimal column drifts a cent per row and the practice's total then disagrees with its own records.
CurrencyISO 4217 codeThe code this ad account is charged in; a practice usually has one, and a second normally means a second entity. Two currencies sharing a column with no codes cannot be summed, and a sheet that does it anyway is wrong without saying so.
Primary metricTextThe one number the row is judged on. For a provider this is usually a cost per attended appointment, because an enquiry that never arrives has cost money and delivered nothing.
TargetNumberThe value you are holding the row to. Blank in the file on purpose: it needs your own enquiry-to-attendance rate, which varies by service line more than any published figure can.
OwnerTextThe person who answers for the row. In a provider this is often split between marketing and the clinical lead who owns the wording; name one of them and say who reviews.
NotesTextWhat the next person needs: the waiting list that is already full, the practitioner on leave, the platform policy that changed last month. Also where to record that a figure is a guess.

The audience you can build, not the one you want

Health advertising is the category where the obvious plan is usually not a plan you can run. The audience a clinic would most like to reach is defined by a condition, and condition-based targeting is exactly what platform policy removes. A plan written as though it were available is not optimistic; it is a plan that will be rebuilt in the launch week, and the rebuild is always more expensive than writing it correctly the first time.

So the targeting limits column is filled in before the audience column, and it is written in words rather than implied. No health-condition targeting. No personalised wording that implies the platform knows something about the reader. Age and location rules where they apply. Then the audience column is written inside those limits, which usually means geography, life stage, and whatever the creative can do to make the right person recognise themselves without the targeting having to.

That last part is the real work of this category, and it is worth saying plainly in the plan: when the audience cannot be narrowed, the message does the narrowing. A row whose audience is broad and whose creative is precise is normal here, and it is not a weaker plan than one with a clever audience — it is the only plan available.

One service line per row

The service line column sets almost everything else. Different services have different claim reviews, different audiences, different attendance rates and different capacity, and a plan that blends two of them produces a cost per result that describes neither.

It also sets who the row is aimed at, which is why audience type is its own column. A patient, a carer, a referring practitioner and an employer are four different readers. They respond to different messages, they are reached in different ways, and only some of them can be reached by the targeting that is available. Blended into one row, the cheapest of them absorbs the budget and the most valuable one is judged by an average it never earned.

Claims are reviewed, and the review has a date

Every row carries a claim review reference, with the date it was given. The reference is the identifier of the review that read this row's wording against what the service can actually say — outcomes, timeframes, comparisons, anything that reads as a promise.

The date matters as much as the reference. Services change what they offer, practitioners change, evidence changes, and platform policy changes. When any of those move, the reference is what lets you list every affected row in one pass rather than reading every ad in every account and hoping nobody missed one.

Where a row's wording has not been reviewed, the row is not ready, and the honest thing is to leave the reference blank and the row out of the flight rather than to start and catch up later. Advertising that ran before it was read is the one category of mistake here that cannot be undone by turning it off.

Count the appointment that happened

The result definition column exists because an enquiry, a booked appointment, an attended appointment and a referral are four different events, and in most providers a large fraction of the people who enquire never arrive.

Judging a row on enquiries funds whatever is best at producing enquiries, which is frequently not what is best at filling a clinic. If the practice management system records attendance — and most do — count attendance, and write the same words in the row that the system uses, so the plan and the report can be put beside each other without a translation step.

This is also why the target column ships blank. The enquiry-to-attendance rate varies by service line more than any published figure can capture, and it is a fact about your reception process, your waiting times and your reminders as much as about your advertising. Read it from your own system, then write the target in.

Capacity is part of the plan

The last thing a general media plan does not have to think about: a clinic can be full.

Before a budget is committed to a service line, check that there are appointments to give. Write the position in the notes — weeks to the next available appointment, or the number of slots a week — and make it part of the pre-flight check rather than something discovered when the enquiries arrive. A row pointed at a service with a six-week wait is not an ambitious plan; it is a plan to spend money creating a queue and a set of disappointed people.

The reverse is worth planning for too. A service line with spare capacity has a different job for its advertising, and it will often justify a higher cost per attended appointment than a busy one, because the marginal appointment is genuinely worth more. Say so in the notes rather than forcing every row to answer to the same number.

Before you commit the plan

Six checks. Every row names one service line and one audience type. Every row states what the platform will not let you target. Every row carries a claim review reference with a date. Every result definition matches an event your own system records. Every budget is an integer in minor units with its currency named. And capacity is written against every row carrying a budget, so that the plan cannot quietly promise more appointments than exist.

The general template, and other industries

Templates that go with it

Related reading

Questions

Put frontier AI to work on every ad account you run.

Tempio connects your ad accounts into one workspace and hands your own AI the numbers and the tools. Every change it writes is a draft until you approve it, or until a rule you wrote does.

Request early access
  • Read and draft by default. Approve is a separate permission you grant.