◆ Excel · report

KPI Monitoring

Flag rows where cost, clicks or conversions are missing so we don't report misleading KPIs: add conditional formatting…

2heights
6tasks
3roles do it

The same job, four heights

do it · improve it · decide · become
AExecute — “help me do it”Flag rows where cost, clicks or conversions are missing so we don't report misleading KPIs: add…+
Flag rows where cost, clicks or conversions are missing so we don't report misleading KPIs: add conditional formatting to highlight blanks in Cost, Clicks, or Conversions, and create a filter view showing only flagged rows for ops to review.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Before ops takes this on, reduce back-and-forth: add an error column that explains which field…+
Before ops takes this on, reduce back-and-forth: add an error column that explains which field is missing, color-code severity (Cost missing = red), and include a quick formula count of flagged rows by channel so the report owner sees the scale of the problem that would make a stakeholder hesitate to trust the KPIs.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

3 of them
Flag rows where cost, clicks or conversions are missing so we don't report misleading KPIs to stakeholders.
Produce a one-page KPI dashboard for the CEO that shows liquidity, runway, and burn rate at a glance.
Establish and monitor KPIs for post-market surveillance so I can escalate products that show safety signals above our thresholds.

Who does this

3 roles
Digital Campaign ManagerFinance ManagerRegulatory Affairs Analyst

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.