Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesMarketing & GrowthAdvertising & Paid MediaGoogle Ads Campaign Planner

SpreadsheetAdvertising & Paid MediaFree

Google Ads Campaign Planner

Plan search campaigns by ad group: keywords, bids and budget, with forecast clicks, leads and cost per lead.

Shown with sample data

Colour

Google Ads Campaign Planner

Plan search campaigns by ad group: keywords, bids and budget, with forecast clicks, leads and cost per lead.

Monthly budget needed
$4,395
Forecast leads
245
Blended cost per lead
$17.94
Viable ad groups
4
Monthly spend by campaign type
  • Product$2,652
  • Problem$1,016.80
  • Brand$399
  • Competitor$327.60
Share of monthly spend by campaign type
  • Product$2,65260%
  • Problem$1,016.8023%
  • Brand$3999%
  • Competitor$327.607%

How to use it

  1. 1Group keywords by intent, one theme per ad group.
  2. 2Use Keyword Planner for volume and cost-per-click estimates.
  3. 3Enter the most you can pay for a lead.
  4. 4Launch the groups marked Viable first.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

See what a budget should buy before you spend it. For each ad group enter search volume, expected click-through rate, cost per click and conversion rate; the sheet forecasts clicks, spend, leads and cost per lead, and flags groups that cost more than you can afford to pay.

Who it’s for

  • Building a search campaign from scratch
  • Asking for a paid media budget
  • Checking a keyword is worth bidding on

What’s included

  • Ad groups sheet: One row per ad group.
  • Summary by Campaign type sheet: Monthly spend and Clicks and the number of entries for each campaign type, calculated from the Ad groups sheet.

How to use it

  1. 1Group keywords by intent, one theme per ad group.
  2. 2Use Keyword Planner for volume and cost-per-click estimates.
  3. 3Enter the most you can pay for a lead.
  4. 4Launch the groups marked Viable first.
Related searchesgoogle ads plannerppc budgetsearch adskeyword plannercost per lead

Details

Format
Spreadsheet
Category
Advertising & Paid Media
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAdvertising & Paid MediaFree

Google Ads Campaign Planner

Plan search campaigns by ad group: keywords, bids and budget, with forecast clicks, leads and cost per lead.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Advertising & Paid Media
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More advertising & paid media templates

View all
Ad Spend & ROAS Tracker2 sheets

Spend

$965

Conversions

84

Blended ROAS

6.6

Spend over time
SpreadsheetAdvertising & Paid Media

Ad Spend & ROAS Tracker

Track daily ad spend, conversions and return on ad spend across platforms.

10 min setupPreview
Media Plan & Flowchart2 sheets

Total budget

$76,500

Planned impressions

6,195,748

Blended CPM

$12

ABCD
1ChannelPlacementObjectiveMonth 1
2Paid searchGoogle, non-brandConversion$6,000
3Paid socialMeta, prospectingConsideration$5,000
4Paid socialMeta, retargetingConversion$1,500
5VideoYouTube in-streamAwareness$4,000
Plan
SpreadsheetAdvertising & Paid Media

Media Plan & Flowchart

Budget by channel and month with planned impressions, cost per thousand and share of spend.

10 min setupPreview
Meta Ads Campaign Planner3 sheets

Total budget

$8,600

Forecast conversions

259

Blended CPA

$33

Forecast ROAS by ad set
6.1
4.1
3
2.2
1.5
Cart abandoners: 7 daysCustomers: new collectionRetargeting: 30-day site visitorsLookalike 1%: purchasersBroad: women 25–45, US
SpreadsheetAdvertising & Paid Media

Meta Ads Campaign Planner

Turn budget and CPM, CTR and conversion assumptions into impressions, clicks, conversions, CPA and ROAS for every ad set.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ