An advertising campaign needs more than creative ideas. Teams must define the audience, objective, channel mix, schedule, budget, performance indicators, and reporting process. These two free advertising plan templates in Excel provide a campaign-planning worksheet and a separate budget and results tracker.
Why Use Advertising Plan Templates?
A structured advertising plan helps decision-makers understand where money will be spent and what success should look like. It also supports consistent reporting across search, social media, display, print, outdoor, radio, email, or other channels. The workbooks can be adapted for small businesses, agencies, product launches, events, and nonprofit campaigns.
What the Templates Include
- campaign owner, product, objective, audience, dates, and total budget
- advertising channels and individual campaigns
- start and end dates, status, and KPIs
- planned and actual spending
- impressions, clicks, leads, and conversions
- automatic cost-per-conversion calculation and notes
Both templates are designed for easy editing in Microsoft Excel and compatible spreadsheet programs. Their structured layouts save setup time while allowing users to add rows, rename fields, change colors, and adapt categories.
Download Two Editable Excel Templates
Each preview below shows the corresponding downloadable workbook. Choose the version that matches your workflow or use both files together.
1. Advertising Campaign Plan
Organizes channels, campaigns, audiences, objectives, dates, budgets, KPIs, ownership, and status.
2. Advertising Budget and Performance Tracker
Compares planned and actual spend with impressions, clicks, leads, conversions, and calculated cost per conversion.
How to Use These Templates
Define one primary business objective before selecting channels. Describe the target audience clearly and choose indicators that match the objective. Set budget limits, tracking responsibilities, and reporting dates before launch. During the campaign, enter actual results consistently and compare performance with the original plan.
Review and update the workbook regularly. Before printing or sharing, confirm names, dates, calculations, and any confidential information.
Practical Tips
- Use conversion definitions that everyone understands.
- Separate planned spending from actual invoiced costs.
- Review tracking and landing pages before launching ads.
- Evaluate performance by objective and audience, not clicks alone.
Customizing the Excel Files
Download the chosen workbook and save a separate working copy. You can alter headings, colors, date formats, status labels, priorities, and row counts. When extending a calculated column, confirm that its formula covers every new row. Preserve an untouched master copy for future use and protect private information when sharing completed files.
How to Build an Advertising Plan Step by Step
An advertising plan template keeps campaigns focused and makes results easier to measure. Fill it in using these steps:
- Set one clear goal, such as leads, sales or app installs, with a target number and deadline.
- Define the audience by location, age, interests and buying stage.
- Choose channels like search, social, display or print based on where that audience spends time.
- Split the budget by channel and month, keeping a small reserve for testing.
- Pick KPIs such as cost per click, cost per lead and return on ad spend.
Update the performance tracker weekly, comparing actual spend and results with the plan. Move budget towards the ads that perform best, and record what you changed so the next campaign starts with better data.
Reporting Advertising Results
At the end of each campaign, summarise total spend, results against each KPI and the best and worst performing ads. Note what you learned about audiences, messages and timing. Share this summary with your team or client together with the completed advertising plan template, and use the findings to set more accurate goals and budgets for the next campaign.
Example Advertising Plan Template for a Small Business
To see how the campaign plan sheet fits together, here is an example for a neighborhood bakery launching a new range of custom celebration cakes. Replace every detail with your own business, goals and figures.
- Campaign name: custom cake launch.
- Objective: generate online and phone orders for custom cakes from local customers.
- Audience: parents and event planners living within delivery distance who are planning birthdays, weddings and office celebrations.
- Channels: local search ads for people searching for cakes nearby, social media ads with photos of finished cakes, and printed flyers placed with local schools and offices.
- Dates: a two-week setup period, then a launch timed before a busy holiday season.
- Budget: a monthly amount split across the three channels, with a small reserve held back for the best performing one.
- KPIs: order inquiries, completed orders and cost per order for each channel.
- Owner: the bakery manager for approvals and an outside freelancer for ad setup.
With this information in the plan, the budget and performance tracker only needs the weekly figures for spend and results to show which channel is bringing in orders at the lowest cost.
How to Set an Advertising Budget
There is no single correct method for deciding how much to spend, but these approaches are common and easy to apply in the advertising plan template:
- Fixed budget: decide on an amount the business can afford for the period and divide it between channels.
- Objective and task: list the activities needed to reach the goal, estimate the cost of each, and add them up.
- Test and scale: start with a modest test budget on two or three channels, then increase spend on those that perform well.
- Seasonal planning: increase spend before your busiest periods and reduce it during quieter months.
Whatever method you choose, record the reasoning in the notes column. When you review results later, you will know whether the plan or the assumptions behind it need to change.
Choosing the Right Advertising Channels
Each channel suits a different stage of the buying journey. Search ads reach people who are already looking for a product or service, so they often work well for direct sales and inquiries. Social media ads are useful for reaching new audiences with images and video, and for retargeting people who visited your website. Display ads can increase awareness across many websites. Print, radio and outdoor advertising can still be effective for local businesses, events and audiences that spend less time online. Email campaigns help you reach existing customers at a low cost.
Rather than trying every channel, choose the few that best match your audience and objective. Add each one as a separate row in the campaign plan so its budget and results can be compared fairly.
Planning Creative and Messaging
An advertising plan should also record what each campaign will say. For every row, note the main message, the offer, the call to action and the landing page. Keep the message consistent across channels so customers recognize the brand, but adjust the format for each platform, such as short text for search ads and strong visuals for social media.
If you are testing different headlines, images or offers, give each version a short name and record it in the tracker. Over time, you will build a record of which messages your audience responds to best.
Tracking Setup Checklist Before Launch
- Confirm that conversion tracking is installed and records leads or sales correctly.
- Add tracking parameters to links so traffic from each campaign can be identified in analytics.
- Check that every landing page loads quickly and works on mobile devices.
- Test contact forms, phone numbers and checkout pages.
- Agree on who will update the tracker and on which day each week.
- Save a copy of the approved plan before any changes are made.
Completing these checks before launch prevents wasted spend and makes the results in your tracker reliable.
Advertising Plan vs Marketing Plan
A marketing plan covers the overall strategy, including products, pricing, branding, content, sales and customer service. An advertising plan is narrower and focuses on paid campaigns: where ads will run, who they will reach, how much will be spent and how results will be measured. Many businesses keep both, using the marketing plan to set direction and the advertising plan template to manage day-to-day campaigns.
Common Advertising Planning Mistakes
- Launching without a clear objective or conversion definition.
- Spreading a small budget across too many channels.
- Judging campaigns by clicks alone instead of leads or sales.
- Changing several things at once, which makes it hard to see what worked.
- Forgetting to record actual spend from invoices and platform reports.
Using the Plan With a Team or Agency
When several people work on the same campaigns, the advertising plan becomes a shared reference. Assign an owner to each row, add an approval column for budget changes, and keep a short change log in the notes so everyone knows why spend was moved or a campaign was paused. Agencies can create one copy of the workbook per client and share a read-only version for monthly reviews. This keeps conversations focused on the agreed objectives and makes it easier to explain results, recommend next steps and plan the following campaign with confidence.
Final Thoughts
These free advertising plan templates provide two practical layouts for organizing responsibilities, deadlines, and progress. Download one or both Excel files and customize them to create a planning system suited to your exact needs.
You can also check these important templates like the marketing budget plan template and advertising proposal template.
Frequently Asked Questions
Can these templates track social media advertising?
Yes. Add each platform, campaign, ad group, or creative as a separate row.
What KPIs can be recorded?
The tracker supports impressions, clicks, leads, conversions, spending, and cost per conversion, and can be customized.
Are these templates suitable for an agency?
Yes. Agencies can duplicate the files for each client or campaign and add approval fields.
