What this template is for
Use the sheet whenever a search campaign is built or rebuilt, or a structure change adds ad groups or moves keywords between them. Small edits inside a live campaign, such as a few negatives after a search terms review, belong in the change log instead.
The sheet sits between documents that already exist. Above it, the campaign brief sets the objective, the audience, the budget and the primary KPI; the sheet copies those rather than restating them. Beside it, the paid campaign launch SOP runs the procedure of building, verifying tracking and going live, and its peer review step is where this sheet is used: the reviewer compares the platform with the sheet line by line. After launch, the Google Ads account audit scorecard grades the live account, and the search campaign build capstone practises the same decisions as an exercise. None of them is the blank, row-by-row record a builder fills before anything exists in the platform. In a brand-new account, the tutorial on setting up a new Google Ads account settles the layer this sheet assumes is already in place: ownership, access, links, auto-tagging, conversion actions and shared lists.
The point of the sheet is not paperwork. Most build errors are cheap to catch on paper and expensive to catch in the account: a keyword on the wrong match type, a negative that blocks the ad group it was meant to protect, a campaign optimising to a conversion action that counts page views. A reviewer reading a sheet finds them in minutes; a reviewer clicking through the interface often does not find them at all.
The template
Copy the table into a spreadsheet, one tab per section, and keep the field names. The keywords, negatives and ads sections become their own tabs with one row per item; the rest fit on a cover tab.
| Field | What to write |
|---|---|
| Campaign settings | Campaign name from the naming convention, network, locations and location option, languages, ad schedule, and the brief the campaign descends from |
| Structure map | Each campaign and ad group, the theme it holds and why it is separate from its neighbours |
| Keywords and match types | One row per keyword: ad group, keyword, match type and the intent it represents |
| Negative keywords | One row per negative: level (account list, campaign or ad group), match type, the reason, and the shared list it belongs to |
| Responsive search ads | Per ad group: headlines, descriptions, which are pinned and why, final URL and display path |
| Assets | Sitelinks, callouts, structured snippets, call and lead form assets, with the level each applies at |
| Bidding | Bid strategy per campaign, the target if any, and the conversion volume that justifies the choice |
| Budget and pacing | Average daily budget per campaign, the monthly figure it implies and who may change it |
| Conversion actions | The primary actions campaigns optimise to and the secondary actions they report on |
| Tracking and URLs | Final URLs, tracking template or URL suffix, UTM parameters and auto-tagging status |
| Build sign-off | Builder, reviewer, review date, launch date and the QA reference |
Keep the sheet with the brief, and version it when the campaign changes materially after launch.
How to fill each section
Campaign settings
Start with the name, and take it from the account's convention rather than inventing one. The naming conventions guide explains how a name carries market, campaign type, intent and product as fields, so reports can split spend without manual tagging. Then record the settings that are easy to get wrong and hard to see afterwards: whether the Display Network is included, the location targets and whether the campaign serves to people in the area or also to people interested in it, the languages, and the ad schedule.
Structure map
List each campaign and each ad group with one line on what it holds and one line on why it is separate. The account structure guide explains the principle: separate where you need different control (a different budget, bid target, message or landing page), and consolidate where you do not, because automated bidding learns better from pooled data. The "why separate" column is the test. If the honest answer is "because the keywords look different", the ad groups probably belong together.
Keywords and match types
Write one row per keyword with its ad group, its match type and the intent it represents. The intent column is what makes the sheet reviewable: a reviewer can see that a keyword is commercial or informational, local or national, and judge whether it sits in the right ad group. The keyword match types guide explains how broad, phrase and exact match behave now that match typesSettings that decide how closely a search must match a keyword for the ad to enter the auction. cover close variants and meaning, and why the search terms report rather than the keyword list shows what actually triggered an ad. Record the reason for any broad match keyword.
Negative keywords
Record each negative with its level, its match type and its reason. The negative keywords guide covers where Negative KeywordsKeywords that stop an ad from showing for searches containing them. should live: shared lists at account level for searches the business never wants (jobs, free, competitors' support queries), campaign negatives that keep brand searches out of non-brand campaigns, and ad group negatives that route a search to the ad group with the best answer. Negatives do not match close variants the way positive keywords do, so plurals and misspellings need their own rows.
Responsive search ads
For each ad group, write the headlines and descriptions in full, mark any that are pinned, and say why. The responsive search ads guide explains how a Responsive Search AdA Google Ads search ad built from multiple headlines and descriptions combined at auction time. is assembled from the assets supplied, why headlines must read well in any combination, and what pinning costs in flexibility. Pin only where a message must appear, such as a regulated statement or a price promise the landing page keeps. Write the final URL beside each ad so the reviewer can check the page matches the ad group's intent.
Assets
List every asset, its text and the level it applies at. The ad assets guide describes each type and how account, campaign and ad group levels inherit, which matters because an asset at a lower level replaces rather than adds to the one above. AssetsExtra information such as sitelinks, callouts and phone numbers that Google Ads can add to an ad. should add information the ad does not already carry. If a call or lead form asset is left out deliberately, write the reason, so a reviewer does not add it back.
Bidding
Record the strategy for each campaign, the target if one is set and the conversion volume that justifies the choice. The Smart Bidding strategies guide explains what Smart BiddingGoogle Ads' automated bid strategies that set each auction's bid from conversion signals. needs to work and how to set a target CPA or target ROAS from evidence rather than hope. A new campaign with little conversion history usually starts on a strategy without a target and moves to one later; write the condition that triggers the change, so it happens on evidence. The CPC calculator and CPA calculator help check that a budget and a target are consistent with each other.
Budget and pacing
Write the average daily budget per campaign, the monthly figure it implies and the person allowed to change it. The budgets and pacing guide explains how daily spend varies around the average and how the monthly limit works, which is why finance should see the monthly figure and not only the daily one.
Conversion actions
Name the primary actions every campaign optimises to and the secondary ones it only reports on. The conversion tracking setup guide covers creating and verifying them. A campaign optimising to a soft action, such as a page view, will find people who view pages; the sheet is where that choice is made visible before bidding acts on it.
Tracking and URLs
Record final URLs, the tracking template or final URL suffix, the UTM values and whether auto-tagging is on. Take UTM values from the house convention in the UTM and naming convention templates so the campaign appears in analytics under the same name it carries in the platform.
Build sign-off
Write who built the campaign, who reviewed it, the review date, the launch date and the reference of the QA record. The paid campaign launch SOP describes the review and first-day checks; the sheet records that they happened.
Filled example
Below, the sheet's cover tab and short extracts of the keyword, negative and ad tabs are completed for an invented business. The figures, names and settings are illustrative.
Lowmoss Garden Rooms: first non-brand search campaign build sheet
| Field | Lowmoss's build sheet |
|---|---|
| Campaign settings | UK_SEARCH_GENERIC_GARDENROOMS_MIXED. Search Network only, no search partners or Display. Locations: postcode areas EH and G plus a 20-mile radius of the Livingston yard, "presence" only. English. Ads Monday to Saturday, 07:00 to 21:00. Brief: LGR-Q2-NB |
| Structure map | Brand campaign UK_SEARCH_BRAND_ALL_EXACT (existing, unchanged). New campaign with three ad groups: OFFICE (working from home in the garden), ROOM (general garden room searches), PRICE (cost and price searches, separate because they go to the price guide and lead with the fixed-price promise). One campaign for both regions because the same install team serves both and budget is shared |
| Keywords and match types | OFFICE: "garden office" phrase, "insulated garden office" exact, "home office in the garden" phrase. ROOM: "garden room" phrase, "insulated garden room" exact, "garden studio" phrase. PRICE: "garden room prices" phrase, "garden office cost" phrase. Intent: commercial, local install. No broad match until the first search terms review |
| Negative keywords | Account list "Never": jobs, careers, diy, plans, kit, second hand, used (phrase). Campaign: lowmoss (phrase, keeps brand in the brand campaign); shed, summer house, log cabin (products not made). Ad group: "price", "prices", "cost" as negatives in OFFICE and ROOM to route price searches to PRICE |
| Responsive search ads | One ad per ad group, twelve headlines and four descriptions each. PRICE pins "Garden Offices From £14,950" to position 1 because the price guide shows that figure; nothing else pinned. Final URLs: /garden-offices, /garden-rooms, /prices |
| Assets | Campaign sitelinks: Price guide, Project gallery, Planning permission, Book a site survey. Account callouts: Fully insulated, Installed in three days, Ten-year structural guarantee. Structured snippet "Types": Garden offices, Studios, Gyms. Call asset on the ad schedule. No lead form asset: quotes need a site photo upload the form cannot take |
| Bidding | Brand: manual CPC, unchanged. Non-brand: Maximise conversions without a target for the first six weeks; expected 35 to 50 quote requests a month at this budget. Move to target CPA once 30 days hold at least 30 primary conversions |
| Budget and pacing | Non-brand £70 a day, about £2,130 a month; brand £15 a day. Performance lead may change by up to 20% once a week; larger changes need the marketing manager |
| Conversion actions | Primary: quote request submitted; calls from the call asset lasting 90 seconds or more. Secondary: brochure download, site survey page view |
| Tracking and URLs | Auto-tagging on. Final URL suffix utm_source=google&utm_medium=cpc&utm_campaign=uk_search_generic_gardenrooms_mixed. Final URLs checked live, no redirects |
| Build sign-off | Built by Ailsa Brodie on 3 April; reviewed by Martin Kerr on 4 April against the launch checklist (ticket MKT-212); launch 7 April, 07:00 |
The review caught one error: "garden studio" had been added as exact match in the sheet's draft, which would have missed searches such as "garden studio with toilet" that the sales team wanted. It went live as phrase match, and the first search terms review two weeks later added "greenhouse" and "playhouse" to the campaign negatives with the reason "products not made".
Common mistakes
- Building first, writing the sheet afterwards. A sheet copied from the account records the errors as decisions. Fill it before the build so the review can change something.
- No reason column. Ad groups, negatives and pins without reasons get undone by the next person who cannot see why they exist. One line of reason per row is enough.
- Splitting by keyword shape rather than by control need. Ad groups that share a budget, a target, a message and a landing page usually belong together; splitting them thins the data bidding learns from.
- Negatives that block the campaign's own keywords. A campaign negative that matches a positive keyword silently stops it serving. Check every negative against the keyword tab before launch.
- Optimising to a soft conversion. A page view or a scroll counted as primary teaches bidding to find browsers. Primary actions should be the outcomes the brief cares about.
- A target with no evidence. A target CPA chosen from the brief's wish rather than from conversion history starves or overspends the campaign. Write the condition that introduces a target.
- A stale sheet. A sheet that no longer matches the account misleads every reviewer who trusts it. Version it when the campaign changes.
The campaign brief that the sheet descends from and the other planning documents are in the templates library.
