Analyst / business owner

KPI drop investigator

Immediate result: A structured investigation plan that rules out data issues first, then segments to find the cause.

Problem it solvesA key number dropped overnight and everyone has a theory.

Add this skill to

You paste

Checkout conversion fell from 3.1% to 2.2% on Tuesday

You get

Check 1: did the analytics event or app version change Tuesday?

Decompose: sessions → add-to-cart → checkout start → payment success

If only Android 5.12 dropped: the release is the prime suspect.

About this skill

About KPI drop investigator

When a key number drops overnight, everyone has a theory and nobody has a method. This skill investigates in the right order: first ruling out data problems such as tracking changes, pipeline delays or definition changes, then breaking the metric into its components and segmenting by platform, country, channel, app version and new versus returning users. It ranks the likely causes and gives the query to confirm each. Following it stops teams from 'fixing' a drop that was really a broken event. To use it, paste the skill into your assistant and send the metric, how much it changed, when, and any data you have by segment; the reply opens with “Is it real?”.

KPI drop investigator AI skill for Analyst / business owner: you paste "Checkout conversion fell from 3.1% to 2.2% on Tuesday" and get "Check 1: did the analytics event or app version change Tuesday?"
KPI drop investigator — example input and the first lines it returns. Works in ChatGPT, Claude and Gemini.
Job profile
Data & analytics · Analyst / business owner
Works in
ChatGPT, Claude, Gemini, Copilot, Claude Code
Format
Agent Skills (SKILL.md)
Price
Free, no sign-up
Install instructions

Copy, paste, send

  1. Cold email writerCopy skillCopied ✓1 Copy the skillPress Copy skill.
  2. ANY AI ASSISTANTSKILLPaste here, then press Enter2 Paste it into a new chatChatGPT, Claude, Gemini or Copilot.
  3. ANY AI ASSISTANT3 Send your inputSend the metric.
The skill — paste this into your AI assistant
# Skill: KPI drop investigator

You are running the "KPI drop investigator" skill for me. I work as: Analyst / business owner. What I need from you: a structured investigation plan that rules out data issues first, then segments to find the cause.

## When I send you the metric, how much it changed, when, and any data I have by segment
1. Check data problems first: tracking changes, pipeline delays, definition changes.
2. Break the metric into components (e.g. traffic × conversion × order value).
3. Segment by platform, country, channel, version and new vs returning.
4. Rank the likely causes and the query to confirm each.

## Reply in this format
- Is it real? (data checks)
- Metric decomposition
- Segments to check
- Likely causes ranked
- Queries to run

## Rules
- Use only the facts I give you; mark anything you had to assume with [ASSUMPTION].
- If something essential is missing, ask me one short question, then continue.
- No preamble or filler: start with the result.

Confirm you're ready in one line, then wait for me to send the metric, how much it changed, when, and any data I have by segment.

Then sendThe metric, how much it changed, when, and any data you have by segment. For example: Checkout conversion fell from 3.1% to 2.2% on Tuesday

ChatGPT

  1. Fastest: paste the skill as your first message in a new chat, then send your input.
  2. To keep it: open a Project, choose Instructions (or Settings → Personalization → Custom instructions for every chat) and paste it there.
  3. To share it with a team: create a custom GPT and paste the skill into its Instructions.
  4. In the Codex app: copy the skill's folder into ~/.codex/skills/ (or Customize → Skills → Add → Create skill).

Claude

  1. Fastest: paste the skill as your first message in a new chat, then send your input.
  2. To keep it: create a Project, open Project instructions and paste the skill.
  3. As a Claude Skill: download the skill's ZIP, then in Claude open Settings → Skills → Add → Upload skill and choose the file.

Gemini

  1. Fastest: paste the skill as your first message in a new chat, then send your input.
  2. To keep it: open Gems → New Gem, paste the skill into Instructions and save.

Microsoft Copilot

  1. Fastest: paste the skill as your first message, then send your input.
  2. In Microsoft 365 Copilot, save it as a prompt or paste it into an agent's instructions to reuse it.

Any other assistant

  1. Paste the skill as the system prompt or first message in any chat assistant (Perplexity, Meta AI, DeepSeek, Mistral, local models).
  2. Coding agents that read the Agent Skills format (SKILL.md) can load the downloaded file from their skills folder.

Install it permanently

Upload it to Claude, add it to ChatGPT's Codex app, clone it into Claude Code, or download the SKILL.md for any agent. Full guide with screenshots →

Download the ZIP and upload it in Claude. Claude then uses the skill on its own whenever a request matches.

Download ZIP

Quick setup

  1. In Claude, open Settings → Skills (under Customize).
  2. Click Add → Upload skill.
  3. Choose the ZIP — don't unzip it — and make sure the skill is switched on.
Claude Settings with Skills selected under Customize, and the Add menu open showing Upload skill, Create a skill, Create with Claude and Record your screen

Repositoryscienceofapps.com/skills/ai-skills.git · all 200 skills, one folder each, plain git over HTTPS

What it does

The steps it follows

  1. Check data problems first: tracking changes, pipeline delays, definition changes.
  2. Break the metric into components (e.g. traffic × conversion × order value).
  3. Segment by platform, country, channel, version and new vs returning.
  4. Rank the likely causes and the query to confirm each.
What you get back

The reply format

  • Is it real? (data checks)
  • Metric decomposition
  • Segments to check
  • Likely causes ranked
  • Queries to run
FAQs

Questions about KPI drop investigator

What does the KPI drop investigator skill do?

A key number dropped overnight and everyone has a theory. The skill fixes that: a structured investigation plan that rules out data issues first, then segments to find the cause.

How do I install KPI drop investigator in ChatGPT, Claude or Gemini?

Copy the skill and paste it as the first message of a new chat, then send your input. To keep it, paste it into a ChatGPT Project or custom GPT, a Claude Project or a Gemini Gem, or upload the SKILL.md file as a Claude Skill.

What do I send KPI drop investigator after installing it?

Send the metric, how much it changed, when, and any data you have by segment. If something essential is missing, the skill asks you one short question and then continues.

Is the KPI drop investigator skill free?

Yes. It's free to copy, use and adapt, with no sign-up, and works in the free versions of ChatGPT, Claude, Gemini and Copilot.

More for data & analytics
Analyst presenting to leadership

Data story writer

ProblemAnalysis gets presented as charts with no story, and leaders can't act on it.

You paste

Findings: repeat customers 22% of buyers but 51% of revenue; repeat rate fell 4 pts

You get

Headline: Repeat customers are a fifth of buyers but half our revenue — and we're losing them.

Recommendation: fund a 6-week retention test before more acquisition spend.

Caveat: one quarter of data.

Immediate resultA one-page summary: the headline, three supporting points, the 'so what' and a recommendation.

Analyst / planner

Simple forecast builder

ProblemTeams need a forecast by Friday and either guess or overbuild a model.

You paste

Monthly orders Oct 2025–Sep 2026, forecast Oct–Dec 2026

You get

History: +3% a month, with a Diwali spike (Oct–Nov ≈ 1.4× normal).

Method: seasonal naive × trend — simple and explainable.

Base Nov 2026: 18,900 · low 16,800 · high 21,000

Immediate resultA transparent forecast with method, formulas, base, high and low cases.

Product analyst

Event tracking plan

ProblemAnalytics is full of badly named events nobody trusts, and key actions aren't tracked at all.

You paste

Food delivery app: search, add to cart, checkout, payment, rating

You get

search_performed — on results load — {query_length, results_count, filters_used}

payment_failed — gateway error — {method: upi|card|cod, error_code}

Exclude: delivery address, phone, typed search text.

Immediate resultA tracking plan: events, properties, naming convention and the questions each answers.

Free PDF · 74 pages · 2 editions

The Laws of UX, in one field guide

60 research-backed principles in 6 categories — what each one means, why it works on the human brain and how to use it on your own screens. Written by Sushant Singh, founder of Science of Apps, who has scaled consumer apps to lacs of users and spent 10+ years leading product across startups and digital businesses in the US, EU & India.

Pick your edition
Free. No card, no paywall — just your email.
Free PDF · 74 pages

Get Laws of UX by email

Choose your edition

You’ll also get occasional UX psychology tips. Unsubscribe anytime. Privacy policy

Free PDF · 90 pages · 2 editions

100+ Subscription Paywalls, decoded

110 real paywalls from top apps, taken apart, rated out of 5 and decoded with the Laws of UX — plus the frameworks, copy and checklists to ship your own. By Sushant Singh, founder of Science of Apps.

  • 110 paywalls rated
  • 34 Laws of UX
  • 12 frameworks

Which paywall scored 4.8 out of 5, and which scored 2.6? It’s all inside.

Pick your edition
Free. No card, no paywall — just your email.
Free PDF · 90 pages

Get 100+ Paywalls, Decoded by email

Choose your edition

You’ll also get occasional UX psychology tips. Unsubscribe anytime. Privacy policy