Free Marketing Campaign Tracker Template (Excel and Google Sheets)

Before adding data from a platform, write down the decision this campaign record should help you make. For example, are you deciding whether to repeat the campaign, change channels, keep a partner, increase the budget, or stop an activity? Your decision will guide what evidence you need to track and when to review it.

Next, write your campaign hypothesis in a way that can be tested. For example: A coordinated creator and podcast launch will increase qualified trials and branded demand among operations leaders during September. This doesn't guarantee causality, but it helps your team know which activities, costs, outcomes, direct responses, and search signals to track together.

Choose one main outcome and a few supporting signals. For example, an awareness campaign might focus on reach, branded demand, and customer-reported discovery. A consideration campaign could track engaged visits, product exploration, demo requests, and direct responses. For a conversion campaign, focus on qualified trials, purchases, or pipeline, and always show the attribution method.

• Start by making a clean copy of the template. Keep the fictional example until you understand how the formulas work, then replace the sample rows instead of editing around them.
• Use stable IDs like CMP-001, ACT-001, and COST-001. While names might change, these IDs help keep your data connected and your history accurate.
• Pick one reporting currency and note the original transaction reference. If your campaigns use different currencies, set the conversion date and source before you compare costs.
• Set your organization’s reporting time zone. If you don’t, platform, analytics, and finance dates might place the same activity in different periods.
• Assign someone to be responsible for every campaign and every data source. If no one owns a field, it often gets ignored.
• Decide which platform metrics you can compare. Don’t combine reach, impressions, and views into a single total just because you have all three.
• Set your weekly check-in, campaign closeout date, and portfolio review date before you launch the campaign.

This marketing tracker separates planning, delivery, costs, outcomes, evidence, and definitions so each part of the record stays clear.

The Activities tab keeps impressions, reach, views, engagements, and clicks in separate columns because each platform defines and counts them differently. For example, on the same platform, an impression might mean repeat exposure, while reach shows unique accounts. A video view depends on playback rules, and engagement rate might use impressions, reach, followers, or views as its base.

Keep the original metric name and its source date. When comparing creators, content, or campaigns, make sure you compare similar metrics. If leadership wants a summary, show separate groups or use a clearly defined index instead of adding views and reach together and calling it audience.

Cost metrics only make sense if both the numerator and denominator are accurate. CPE means actual campaign or activity cost divided by comparable engagements. CPM is actual cost divided by comparable impressions, then multiplied by 1,000. If you don’t have the denominator, leave the metric blank instead of making it zero.

An outcome is a business result you can see, like a qualified trial, purchase, demo request, pipeline amount, retained customer, branded search, or another agreed metric. Attribution is the method you use to link some of that outcome to marketing. The workbook tracks both, because just looking at the value can give a false sense of certainty.

Label your methods clearly, like last non-direct click, UTM campaign, promo code, customer-reported source, sales-assigned source, platform-reported conversion, matched holdout, or no attribution. Also, add any limitations in simple language. For example, say if a platform reports conversions within a seven-day click window or if there are overlaps with GA4 totals. This is more helpful than just adding a confidence badge without explanation.

Keep direct evidence next to click-path evidence, not mixed together. For example, a customer might say they heard about your business on a podcast but later convert through branded search. By keeping the direct response, search session, and outcome separate, your team can compare them instead of letting one overwrite the others.

The sample campaign in the workbook, called Spring Launch, is fictional. It includes creator partnerships, a podcast placement, paid social, and an event. The campaign plan lists a hypothesis about qualified trials and branded demand, a $32,000 planned budget, owners, dates, and a closeout decision.

The Activities tab shows what each channel delivered, without forcing every row to use the same metrics. For example, creator videos track views and engagements, paid social tracks impressions and clicks, and event attendance is recorded in the notes instead of as a social metric. Costs are linked to the campaign and, when possible, to the specific activity.

The Outcomes tab tracks qualified trials and purchases, along with their source and attribution method. Direct Signals includes privacy-safe HDYHAU and promo-code totals. Brand Signals compares a set branded-search baseline with the observation window and notes that other activities or seasonality could also explain the results.

The dashboard compares planned and actual costs, delivery, raw channel data, and outcomes for each campaign. It doesn’t pick a winner. The decision column shows what the team decided and why, keeping the conclusion linked to the evidence available at that time.

As a marketing reporting template, the workbook supports different review cadences without mixing weekly upkeep with campaign, monthly, or quarterly decisions.

• Nobody can explain which copy is current or who changed a formula.
• The weekly refresh consumes more time than interpreting the result.
• Campaign, activity, cost, and outcome IDs no longer reconcile across owners.
• Platform history disappears before the team captures it, or screenshots become the archive.
• Leadership asks a follow-up question that requires rebuilding the report from raw exports.
• Direct responses, brand signals, and offline activity live in separate files and never reach the same review.
• The team cannot give an AI assistant or developer governed access without sharing the whole workbook.

This is why it’s helpful to move from a campaign spreadsheet to a managed marketing record. Brandwave lets you track campaigns, activities, creators, costs, success metrics, direct evidence, and brand-demand signals all on one timeline. The current automation covers Instagram, YouTube, TikTok, X, LinkedIn, and Reddit, but you can add other channels too. You can access the same record through the web app, HTTP API, and MCP server for authorized AI assistants.

A system won’t replace the need for clear definitions or good judgment. But it does remove fragile links and repeated copying, so your team can focus on making decisions. Check out Brandwave pricing or compare it with other marketing dashboard and reporting tools.