AnalyticsGoogle Ads analysisIntermediateAnalyses your data

Budget pacing and impression-share analysis

Checks whether a budget is on pace for the month and whether lost impression share is budget-limited or rank-limited, using the figures you provide.

For: Performance marketers, Marketing analysts, Growth marketers · Works with: Google Ads, Any capable chat model (ChatGPT, Claude, Gemini, others)

Public beta. This prompt was drafted with AI assistance and checked by automated rules, but it has not been reviewed or tested by a person yet. Treat it as a starting point and check the output. It is hidden from search engines while in beta. Use the “Was this prompt useful?” box to tell us what works.

Your prompt

Act as a paid-search analyst. Month: October 2026. Total monthly budget: 10000 USD. Today is day 17 of 31. Campaign data (campaign | spend to date | daily budget | search impression share | lost IS (budget) | lost IS (rank) | conversions): Campaign | Spend | Daily budget | IS | Lost IS budget | Lost IS rank | Conversions Brand | 800 | 50 | 92% | 4% | 4% | 120 Non-brand | 4300 | 250 | 38% | 31% | 31% | 52 Competitor | 900 | 60 | 12% | 5% | 83% | 3 Tasks: 1. Assumptions: note how you treat daily budget overspend allowances, seasonality and whether impression-share columns are complete. 2. Pacing: compute spend to date as a share of budget and of the month elapsed; project month-end spend with a simple linear method and state that it is simplistic. 3. For each campaign, explain what the impression-share columns suggest about budget limits versus rank limits, and where more budget might add volume versus where it probably will not. 4. List the questions to answer before shifting budget (marginal returns, conversion lag, seasonality). 5. Suggest a cautious reallocation experiment, not a permanent change. 6. List missing data that limits the conclusion. Rules: do not invent projected results or ROI figures. If columns are missing or not provided, say so. Verify the pacing arithmetic. Impression share explains opportunity, not profitability, and shows correlation rather than causation; say so.

Customize

The fields start with example values so you can see how the prompt works. Everything stays in your browser.

Month under review.

Total budget.

Currency.

Today's day number.

Number of days.

Paste your table. The default is small fictional sample data so the preview works; replace it with your own export.

Example of what to expect

Illustrative only. It describes the kind of result this prompt aims for; real output varies by tool, model and run.

A pacing calculation with a clearly labelled linear projection, per-campaign reading of budget- vs rank-lost share, questions to answer before shifting budget, a cautious test proposal and missing data. (Illustrative.)

Expected format: Pacing table, per-campaign interpretation, questions, experiment, caveats.

How to use it

  1. Use real spend-to-date from the platform.
  2. Treat the projection as rough.
  3. Test reallocations on a small share first.

Limitations

  • Linear projections ignore weekday and seasonal patterns.
  • More budget does not guarantee more profitable volume.

Platform notes

Google Ads

Official docs read · checked 2026-10-11

Google Ads field names and units (for example cost expressed in micros in the API) must be confirmed in Google's reference; the GAQL overview page we read does not list them.

General notes on Google Ads
  • GAQL uses SELECT/FROM/WHERE/ORDER BY/LIMIT. Confirm resource and field names (for example cost fields, which are expressed in micros) in the API reference; the overview page does not list them.

Any capable chat model (ChatGPT, Claude, Gemini, others)

Official docs read · checked 2026-10-11

Works in any capable chat model. Paste a small anonymised export and recompute the key numbers yourself: chat models can misread columns or miscalculate.

General notes on Any capable chat model (ChatGPT, Claude, Gemini, others)
  • These prompts are plain text and work in any chat assistant. For analytics prompts, paste a small, anonymised export; a chat model can misread columns or miscalculate, so recompute key numbers yourself.

Source, license and attribution

Origin
Original by MarketerTools
Publisher
MarketerTools
License
Original work by MarketerTools, free to copy and use. Informed by the linked documentation; no third-party text is reproduced.
Platform assumptions checked
2026-10-11

Documentation and references behind this prompt

These informed the structure and the platform notes. A reference is not a license, and no third-party prompt text is copied here.

Spotted an attribution error, or are you a source owner with a request? Use the chat button at the bottom right and quote prompt ID ana-012. We will correct or remove it.

  • AnalyticsIntermediateAnalyses your data

    Google Ads campaign diagnostic against CPA or ROAS targets

    Compares campaigns against your target, separates volume, efficiency and conversion-rate drivers, and highlights what the data cannot explain.

    Google Ads · Any capable chat model (ChatGPT, Claude, Gemini, others)

  • AnalyticsIntermediateAnalyses your data

    Budget reallocation scenarios with saturation caveats

    Builds transparent what-if scenarios for moving budget between channels, with simple assumptions about diminishing returns clearly labelled.

    Any capable chat model (ChatGPT, Claude, Gemini, others) · Google Sheets / Excel

  • AnalyticsIntermediateAnalyses your data

    Google Ads search-terms report: wasted spend and negative keywords

    Groups search terms by pattern, estimates wasted spend from your data and proposes negatives, with a protected 'do not negate' list and match-type cautions.

    Google Ads · Any capable chat model (ChatGPT, Claude, Gemini, others)