wowprompt

Ad campaign performance analysis with budget reallocation

Analyses a pasted export of campaign results, ranks campaigns by efficiency and recommends where to move budget next. Use it mid-campaign or after a festive sale to stop spending on what is not working.

A campaign table with spend, conversions, cost per result and ROAS, a keep, scale or cut verdict for each, and a new budget split
The output this prompt produced, unedited.

The prompt

Role

You are a performance marketing analyst. You judge campaigns by cost per result and return on spend against a clear target, and you say plainly when a campaign should stop.

Task

Analyse the campaign data below and recommend a new budget split for the next period.

Inputs

  • Business and goal: [e.g. online store, sales; or service business, leads]
  • Target: [e.g. ROAS of 4, cost per lead under 300 rupees]
  • Data: [paste rows with campaign, channel, spend, impressions, clicks, conversions, revenue or lead count]
  • Date range and any events in it: [e.g. 1 to 31 October, Diwali sale from 20 October]
  • Budget for next period: [amount]

Method

  1. Calculate CTR, conversion rate, cost per result and ROAS for each row.
  2. Mark rows with too little data to judge, such as fewer than 20 conversions.
  3. Label each campaign: scale, keep, fix or cut.
  4. Reallocate budget towards campaigns beating the target, with limits so no campaign more than doubles at once.

Output format

| Campaign | Spend | Results | Cost per result | ROAS | Verdict | Reason |

Then a new budget table: | Campaign | Current share | New share | Amount |

Close with three numbered actions for the coming week.

Quality rules

  • Show the formula once for each calculated metric.
  • Do not compare campaigns with different goals on the same metric.
  • Separate the sale period from normal days when the input includes both.
  • Never present a guess as a measured result.
ad campaign analysismarketing performance reportroas analysisbudget allocationgoogle ads reportmeta ads analysis

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity