Free Paid Media Plan Template (Google Sheets Download)

You don’t need another deck about “growth.” You need a working sheet that tells you what to spend, what to test, and when to kill an underperforming ad without tanking pipeline. This free paid media template (and the playbook below) is built for operators - founders and marketing leads who care about CPL, CAC, and revenue, not screenshots of CTR.

A good media plan doesn’t sit in Notion. It runs the daily decisions behind your Google, Meta, and LinkedIn spend. The job-to-be-done is simple: put money into channels with the highest probability of turning into qualified pipeline at an acceptable CAC, and do it with guardrails so you don’t guess.

Your template has to connect creative, offers, conversion rates, and sales velocity into a single view. If it only shows campaign names and budgets, you’ll still be guessing. The structure I outline below lets you forecast, run controlled tests, and pace spend without end-of-month fire drills.

Also: plan for reality. CPLs drift, sales cycles stretch, and one creative pays the bills for six weeks then dies in two days. Your sheet should anticipate drift with ranges and thresholds. It’s not “set it and forget it”; it’s “set it, test it, kill it, scale it.”

Let’s map the core fields. You can mirror this in Google Sheets or Excel in five minutes. The point is clarity, not bells and whistles. Use one tab per channel (Google, Meta, LinkedIn) and one summary tab that rolls up forecasts and actuals.

At minimum, include these columns per experiment or ad set:

• Date range (start, end)
• Campaign / Ad set / Experiment name (versioned: CH-Objective-Offer-Hook-XX)
• Audience or keyword theme (exact if search; interest/LLA if social)
• Offer / CTA (e.g., Demo, Free Tool, Case Study, Discount)
• Creative concept (Hook, angle, asset type)
• Daily budget (planned)
• Spend (actual)
• Impressions, Clicks, CTR
• CPC (auto-calculated)
• Landing page CVR (session to lead)
• Leads (form fills), CPL (auto-calculated)
• Sales-qualified rate (lead → SQL/opp)
• Opps created, Cost per Opp (auto)
• Win rate (opp → closed-won)
• Revenue (from CRM, not platform)
• CAC (Spend ÷ New Customers)
• Payback (months) and LTV:CAC
• Status (Scale, Hold, Kill), Decision date, Owner

The summary tab simply rolls up per channel: planned vs actual spend, CPL range, Opps, CAC, and revenue. Use conditional formatting to flag any metric outside threshold bands. Color drives attention; numbers drive action.

Finally, add a small notes column for confounders: site outage, promo timing, competitor sale, or a creative that was disapproved for 48 hours. Your future self will thank you when reviewing anomalies.

Forecasting isn’t about precision; it’s about bounding reality. Start with ranges, not single-point estimates. For a given channel, set a baseline CPC and landing CVR from your last 30–60 days or industry-adjacent benchmarks. Then model a conservative and aggressive case so you know what “good” and “bad” look like before the month starts.

Example for search on Google: if CPC is $4–$6, landing CVR is 5–8%, and lead→opp is 20–30%, then your CPL range is roughly $50–$120 and CPO (cost per opp) $170–$600. put those bands right in the template. Your operators can then call a test successful when it beats the midline or holds within the band while creating more opps.

For paid social (Meta, LinkedIn), set expectations by objective. Traffic and video views are not proxies for pipeline. If your lead magnet averages 10–18% CVR from click to lead and your best B2B demo offer hits 3–7%, you’ll see completely different CPLs and downstream opp rates. Label offers clearly and evaluate them against their correct benchmark, not across objectives.

Creative and offer discipline is the most ignored line in most media plans. You can’t forecast or optimize if every ad is a one-off. Name and track creative concepts and offers like SKUs, and rotate them on a schedule so you aren’t flying blind when fatigue hits.

Use a simple naming pattern: Channel-Objective-Offer-Hook-Version. Example: META-LEAD-CaseStudy-SkepticProof-V3. That one line tells you what you’re testing without opening the ad library. In the template, each unique Offer+Hook pair should have its own row with budget, guardrails, and success criteria.

Plan rotation windows. If you know a concept burns out in 7–10 days at your spend level, prep two replacements before you launch. Don’t wait for the cliff.

Build a testable creative backlog

Maintain a backlog of 8–12 ready-to-launch assets per core offer: square video, vertical video, static carousels, and a long-form copy variant. Tag them by hook category (e.g., Social proof, ROI math, Time risk, Objection-flip). Your sheet should note which hooks are due next and the date they enter rotation.

Score each creative after 3–5 days on first-principles metrics: thumbstop (3s views or initial CTR), click intent (CPC relative to baseline), and conversion intent (CVR). The best creative isn’t the prettiest - it’s the one that moves a user one step closer to a qualified conversation.

Retire assets aggressively. If CPC is 30% above channel baseline or CVR is 30% below midline after minimum spend (see guardrails below), kill it. Your future CAC depends on this discipline.

Offers that map to funnel stages

Match offers to buying intent. Warm search terms can handle a “Book a demo.” Cold social audiences often need a low-friction step: calculator, quiz, audit, or a proof-led case study. Track each offer separately in the template with its own conversion and opp-creation assumptions.

For e-commerce, think category-specific bundles, price anchors, and first-purchase incentives you can test by cohort. For B2B, rotate between high-intent CTAs and mid-funnel assets that earn permission (e.g., ROI tool, benchmark report) without bloating CAC.

When offers are tagged and forecasted independently, budget shifts become obvious: starve underperformers without debating creative taste.

Testing cadence and kill criteria

Set minimum sample sizes and spend thresholds before launch. For instance, in Meta lead gen, require at least 2x target CPL in spend and 30–50 clicks before evaluation. In search, require 100–150 clicks for match-type tests. Note these thresholds in the template’s “Guardrail” column so anyone on the team can act without a meeting.

Define what “win,” “inconclusive,” and “loss” look like numerically. A win might be CPL ≤ 80% of baseline with stable CVR and quality metrics (opp rate within 10% of baseline). An inconclusive result gets one more rotation; a loss is killed and documented in the “Postmortem” column for pattern recognition.

Keep the kill switch near. If platform signals (limited learning, high first-24h CPC, poor quality ranking) all line up red on day two, don’t protect sunk costs - protect CAC.

Daily: scan the summary tab for pacing and red flags. You’re looking for budget underdelivery, sudden CPC spikes, and CVR cliffs. Make two kinds of edits only: quick fixes (bids, budgets, pausing an ad) and annotations (why did this move?). If you can’t justify a change in one sentence, don’t make it on a daily scan.

Twice weekly: rotate creative as scheduled and advance planned tests. Check guardrails and make scale/hold/kill calls with a short note. If something’s “working,” define that explicitly (CPL and opp rate vs baseline, not just CTR). Update the decision column with date and initials so tribal knowledge becomes institutional.

Weekly: review cohort quality in the CRM. Did last week’s LinkedIn doc ad flood you with job seekers instead of buyers? If the opp creation rate is off, treat it as a targeting or offer problem, not a platform problem. Move budget based on opp and CAC, not vanity signals.

Platforms optimize for their own metrics; you optimize for revenue. Push UTM parameters and offline conversions back into your CRM so you can trace channel → campaign → offer → opp → revenue. Otherwise, you’ll over-allocate to the cheapest clicks, not the best customers.

At minimum, capture lead source detail (channel and campaign), opportunity source, and contact-to-opportunity timestamps. Use those to calculate lead→opp and opp→win by channel and offer. Review time-to-first-touch and time-to-first-reply to spot friction in sales handoff.

If you don’t have this stitched, prioritize it. A lightweight HubSpot build with proper lifecycle stages and deal attribution will pay for itself fast. If you want it done for you, see how we implement CRM and RevOps foundations on our CRM implementation service page.

Random testing burns budgets. Build a roadmap the same way product teams plan sprints. Group tests by objective (reduce CPL, increase opp rate, improve AOV), then prioritize by expected impact and ease. In your template, each row should be tied to one of these objectives so you’re not mixing outcomes.

Types of tests worth running:

• Search: match type and query theme splits, exact vs phrase isolation, RSA pinning variants, intent sculpting with negatives.
• Social: hook category matrix (proof vs ROI vs objection), format swaps (UGC vs motion graphic), CTA variants (demo vs tool), audience warmth (remarketing ladder).
• Landing: headline promise, hero visual, proof placement, form friction (fields, multi-step), offer framing.

Decide statistical thresholds pragmatically. You don’t need a PhD to call a winner. Use relative deltas and guardrails: if variant B beats baseline by 25%+ on CPL with stable opp rate after minimum spend, promote it. If it’s within ±10%, call it inconclusive and test a bigger swing.

Set a daily pacing tracker in the summary tab: Planned MTD vs Actual MTD vs Target pace. If you’re more than ±10% off pace by mid-month, adjust daily budgets systematically, not emotionally. Avoid “catch-up” sprints in the last three days; they create expensive clicks and low-quality leads.

Use budget tiers per channel: a base layer that always runs (highest confidence themes), a test layer (10–20% of spend for experiments), and a scale layer you unlock only when a test holds for 5–7 days within your success band. The template should show which rows belong to which tier.

Account for seasonality and promotions in advance. If a launch is coming, pre-allocate and stock the creative backlog. Your sheet should have a “Flight” column with planned increases/decreases by week. Surprises happen; panic should not.

If your media plan lives in an agency’s folder and you see it once a month, you’re paying agency tax and renting an outcome. Ownership should be in-house - or with an operator who ships and reports like in-house. The difference shows up in CAC, not in pretty PDFs.

An operator’s incentive is to make one simple sheet run the business logic: forecast ranges, kill criteria, CRM revenue feedback, and a cadence that isn’t meeting theater. Agencies often optimize for retainers and deck cadence. There are excellent agencies, but the model itself adds layers you don’t need when you want decisions today.

If you’re comparing, here’s a neutral primer: what’s the overhead, who pushes the buttons, and who is accountable for pipeline? We’ve summarized those trade-offs on our agency vs operator comparison page.

Anton Chisliuk · AI Marketing Ops is an AI-first outsourced marketing operator. One senior person runs your stack - SEO, paid, outbound, HubSpot, and automation - without the account-manager layer. Proof over pitch: for Cleverence (B2B SaaS), we scaled from 0 to ~80K organic visits/month and 0 to ~2K inbound leads/month, with paid CPLs in the $2–6.50 range. If you want a second set of eyes on your sheet and channel math, grab a free Growth Audit - we’ll stress-test your assumptions and pacing.

Automate alerts and hygiene, not strategy. Use rules or webhooks to ping Slack when CPL crosses a threshold for 48 hours, when spend is 20% off pace for the week, or when a new opp hits from a fresh campaign (so you can tag it correctly). That’s where tools shine: faster awareness.

Build simple workflows to pause spend if a landing page 404s or if form conversion craters after a deploy. If you’re running multiple markets, automate currency normalization and daily roll-ups so you compare apples to apples in the summary tab.

Don’t auto-scale budgets on small data. A few lucky conversions can trick rules into doubling spend. Keep the human in the loop for scale/kill decisions; use automation to surface the decision, not to make it. When in doubt, two clicks in the sheet beat a runaway rule.

Day 1–2: Set baselines and ranges for CPC, CVR, lead→opp, and opp→win. Fill your summary tab and guardrails. Load your first batch of 6–10 creative assets per offer, already named by hook.

Day 3–7: Launch core campaigns with minimum viable budgets and two tests per offer (format or hook). Enforce thresholds. Annotate anomalies. If something is red for two days within guardrails, kill it and move the next asset from the backlog.

Day 8–14: Shift 10–20% of spend to the best performer(s) that held for 5–7 days. Ship a landing page tweak for the next best concept to rescue CVR. Confirm opp quality in CRM before you scale again. Rinse and repeat.

Write ad copy from a skeptical buyer’s POV. Don’t celebrate your product; neutralize their risk. “5-minute setup, no engineer needed” beats “AI-powered platform.” Your creative naming will show you which skepticism-killers work; bias toward those.

Shorten feedback loops with sales. When a wave of low-fit leads hits, it’s often a misaligned offer or audience, not a “bad week.” Build a 10-minute Friday sync with sales to tag themes and update your opp rate assumptions.

Document what you learned. Two lines per killed test: hypothesis and the next thing you’ll try. Your future CAC is the compound interest of small, written learnings.

A paid media template is not paperwork. It’s a decision system: forecast, launch, measure, and move money with clear guardrails. When your sheet ties offers, creative, and CRM revenue together, you stop arguing about CTR and start compounding wins on CAC and pipeline.

If you want this level of rigor without adding headcount, our performance marketing work brings the same operator cadence - daily pacing, weekly creative rotation, and CRM-backed decisions - to Google, Meta, and LinkedIn.

Author: Anton Chisliuk - Leads, sales, content, and systems - one senior operator.

- What channels does this template support?

Google Ads (search, PMax), Meta (Facebook/Instagram), and LinkedIn out of the box. The columns are channel-agnostic, so you can add TikTok, YouTube, or programmatic - just keep the same forecast and decision structure.

- How much data do I need before making a scale or kill decision?

Use guardrails: at least 2x target CPL in spend and 30–50 clicks for social; 100–150 clicks for search match-type tests. Then call a win if CPL beats baseline by ~25% with stable opp rate for 5–7 consecutive days.

- Should I optimize for leads or opportunities?

Opportunities. Leads are a waypoint. Track lead→opp and opp→win in your CRM and make budget moves based on cost per opportunity and CAC, not just CPL. Cheap leads that don’t convert are the most expensive line on your P&L.

- How do I handle seasonal spikes or promotions?

Pre-flight in the sheet: increase test layer budget, stock extra creative for 2–3 hooks, and set higher CPC/CPL bands for the promo window. After the window closes, revert to baseline pacing and re-check opp quality before scaling anything that “won” during the promo.

- What if my CRM isn’t set up for attribution?

Start simple: capture UTM source/medium/campaign on lead creation, map to opportunity source, and ensure closed-won has the original UTM data. Then add offline conversions and deal revenue over time. Even partial attribution beats flying blind.

- How many simultaneous tests should I run?

Keep a test layer at 10–20% of spend. Within that, 2–4 parallel tests per channel is manageable. If you can’t explain what you’re learning from each test in one sentence, you’re running too many.

- Do I need fancy tools to use this template?

No. A clean Google Sheet and platform dashboards are enough. Use automation for alerts and hygiene only. Strategy and scale/kill calls should live in the sheet and your weekly cadence.