A PPC search term report shows what people actually searched before clicking an ad, not just the keywords you selected. This guide provides a repeatable search term report template, decision rules, and simple calculations for separating valuable queries from research traffic, landing-page gaps, irrelevant clicks, and match-type problems.
Overview
Search term analysis is one of the most practical forms of PPC keyword optimization. Your keyword list describes the targeting you intended to use; the search term report reveals how that targeting behaved in real auctions. Reviewing the two together can uncover new converting targets, wasted spend, unclear ad group themes, and gaps between an ad promise and its landing page.
Google Ads and Microsoft Ads may use different report names, columns, or interface labels over time. The underlying workflow remains similar: export the available query data, preserve the keyword and match-type context, evaluate business value, and record a specific action. Do not judge a query from clicks alone. A term with few clicks may have generated a valuable lead, while a high-click term may simply be consuming budget without meaningful outcomes.
A useful review classifies each query into one of five groups:
- Converting target: The query is relevant and has produced a meaningful conversion or strong evidence of commercial value.
- Research term: The query is relevant but appears early in the decision process or has not generated enough data for a firm conclusion.
- Landing-page gap: The query is valuable or clearly relevant, but the current ad and page do not address its specific need well.
- Irrelevant traffic: The query does not fit the offer, audience, geography, or business model.
- Match-type or structure problem: The query is related to the keyword but belongs in another ad group, campaign, or targeting approach.
This classification prevents a common mistake: adding every relevant query as an exact-match keyword or adding every poor query to a negative keyword list without checking why it appeared.
How to estimate
Use the report as a triage worksheet rather than as a simple list of keywords. Start with the date range and conversion definition used in your account, then calculate the cost and outcome measures that matter for the campaign.
Core calculations
- Cost per conversion: Cost ÷ conversions. Use only when the conversion count is meaningful enough to interpret.
- Conversion rate: Conversions ÷ clicks × 100. This helps compare queries with different click volumes.
- Return on ad spend: Conversion value ÷ cost. Use when revenue or another defensible conversion value is available.
- Cost share: Query cost ÷ total campaign or ad group cost × 100. This shows whether a weak query is materially affecting spend.
- Value per click: Conversion value ÷ clicks. This can help compare terms before they have enough conversions for a stable cost-per-conversion view.
For a simple decision estimate, define a target cost per conversion or target return before reviewing the rows. For example, if your target cost per lead is 80 currency units and a query has spent 120 units with no conversion, it deserves investigation. That does not automatically prove the query is poor: tracking may be incomplete, the query may need more time, or the conversion path may involve offline follow-up. The calculation identifies where to investigate, not what to assume.
Use this worksheet structure:
| Query | Keyword | Match type | Ad group | Intent | Conversions | Conversion value | Cost | Action | Owner | Review date |
|---|---|---|---|---|---|---|---|---|---|---|
| Exact user query | Triggering keyword | Recorded type | Current group | Intent category | Selected goal count | Assigned value | Spend | Decision | Responsible person | Next check |
Adding an evidence note and confidence level is also useful. A query with one conversion and little spend may be promising but low confidence. A query with repeated conversions and a consistent cost may justify a stronger action.
Inputs and assumptions
Before you analyze a PPC search term report, confirm that the inputs can support a fair decision. At minimum, record the following:
- Reporting period: Choose a period that includes enough recent activity to be useful while avoiding unnecessary mixing of old and new landing pages, offers, or bidding settings.
- Conversion definition: Separate primary business outcomes from secondary actions when possible. A form start, page view, or phone click should not automatically be treated like a qualified lead or purchase.
- Attribution and delays: Recent clicks may not yet show their full outcome. Note the normal delay between a click and a recorded conversion in your sales process.
- Value model: Use recorded revenue when appropriate. If you use assigned values for leads, document the assumption so later reviews remain comparable.
- Keyword context: Preserve the triggering keyword, match type, ad group, campaign, device, and location where available. A query can be suitable in one campaign and unsuitable in another.
- Business fit: Check product availability, service area, margins, lead quality, and eligibility rules before labeling a query valuable or irrelevant.
Intent should be classified from the query and the offer together. Useful categories include transactional, commercial investigation, informational, navigational, local, job-seeking, support-related, and competitor-oriented. The labels are less important than applying them consistently. “Pricing,” “buy,” “quote,” and “near me” may indicate stronger commercial intent for some businesses, but context still matters.
When a query is irrelevant, verify whether the problem is broad targeting, ambiguous wording, or an omitted negative keyword. Add a term to a shared negative keyword list only when the exclusion is appropriate across the campaigns that use that list. A campaign-specific negative may be safer when the same word is useful elsewhere. Review the negative keyword list guide for a maintenance workflow.
When a query is relevant but appears in the wrong ad group, consider restructuring rather than excluding it. A clearer thematic group can support a more specific ad and landing page. The choice between tightly separated groups and broader thematic organization should reflect volume, message differences, and management effort; the SKAGs versus thematic ad groups decision matrix can help document that choice.
Worked examples
Example 1: A converting target
Suppose the query is “commercial accounting software demo.” It triggered a broader keyword in a software campaign, generated 18 clicks, cost 72 currency units, and produced two qualified demo requests with an assigned value of 300 units each. The calculated cost per conversion is 36 units, and the estimated return on ad spend is 600 ÷ 72, or 8.33.
The action could be to add the query as a deliberately managed keyword in an appropriate ad group, check that the ad and landing page use compatible language, and continue monitoring it separately. Record the source row so you can compare performance before and after the change. Adding a query does not guarantee better results; it simply gives the term clearer management and reporting context.
Example 2: A landing-page gap
Consider “same-day replacement laptop battery.” The query is commercially relevant, but the destination page only describes standard delivery and does not confirm availability or timing. If the query receives clicks without conversions, pausing it may remove useful demand before the real problem is tested. A better action is to verify fulfillment, create or select a page that addresses the need, align the ad message with what is actually available, and then review the query after enough new data has accumulated.
Example 3: Irrelevant traffic
Imagine a business selling paid accounting software receives “accounting course free.” The query indicates a learning or free-resource need rather than software purchase intent. If the business does not serve that audience, mark it as irrelevant and add an appropriate negative keyword at the narrowest sensible level. Check nearby queries before applying a broad exclusion, because “course” might be relevant to another offering.
Example 4: A structure problem
A campaign for residential cleaning receives “office cleaning contract.” The query may be valuable to the business, but it does not belong in a residential ad group. Classify it as a structure problem, then decide whether a business-services campaign, tailored ad, and dedicated landing page are justified. If not, exclude it from the residential campaign and document why.
When to recalculate
Search term analysis should be a recurring operating process, not a one-time cleanup. A weekly review is useful for high-spend campaigns, newly launched campaigns, seasonal promotions, or accounts where irrelevant traffic can consume budget quickly. A monthly review may be sufficient for lower-volume campaigns, provided significant queries are not waiting too long for action.
Recalculate the worksheet after meaningful changes to bids, budgets, match-type coverage, ad copy, landing pages, conversion tracking, geography, or audience settings. Also revisit it when business inputs change, such as product availability, margins, lead qualification rules, or acceptable acquisition cost. If reporting fields or attribution terminology change in Google Ads or Microsoft Ads, map the new fields to your worksheet before comparing periods.
Finish each review with four practical steps:
- Filter for high-cost, zero-conversion queries and validate tracking before making exclusions.
- Filter for converting or high-value queries and decide whether they need dedicated keyword, ad, or landing-page treatment.
- Group irrelevant terms into a documented negative keyword list, checking campaign scope before applying exclusions.
- Set an owner and review date for every “investigate” decision so unresolved rows do not remain in the worksheet indefinitely.
Save the reviewed report with its date range, conversion settings, and notes. Compare the next period with the previous one, focusing on cost efficiency, conversion quality, and the actions taken rather than only on click volume. This creates a practical feedback loop for PPC search term optimization and makes the report useful again whenever campaign inputs, market demand, or business priorities change.