Campaign retrospective writer

Campaign Retrospective Writer

Этот скилл собирает структурный ретро-разбор завершённой маркетинговой кампании на основе вставленных метрик и заметок. Результат: 6-секционный Markdown-документ — цель/факт, разбор по каналам, что сработало/нет, гипотезы причин, рекомендации и строка тренда.

Ввод:

• Метрики и/или заметки по завершённой кампании (свободный текст, paste)
• Опционально: цель, тип кампании, период, каналы

Вывод:

• Markdown-ретро с 6 разделами

---

Language Detection

Detect the user's language from their message:

• If Russian (or contains Cyrillic): respond in Russian
• If English (or other Latin-script language): respond in English
• If ambiguous: respond in the language of the trigger phrase used

---

Instructions

Step 1: Validate Input

1. Check if the user provided any campaign data (metrics, notes, results)

   • If input is empty: stop. Return bilingual prompt:

     «Вставьте метрики или заметки по завершённой кампании.
     Paste metrics or notes from a completed campaign.»

   • Do not proceed to Step 2

2. Check if the campaign appears to be active (ongoing, in-progress language such as "we are running", "current campaign")

   • If yes: warn the user before proceeding:

     «Кампания выглядит активной — ретро эффективнее после завершения. Продолжить? /
     Campaign appears ongoing — retrospectives are more useful after completion. Continue?»

   • Wait for confirmation before proceeding

Step 2: Extract Campaign Context

1. Parse the input for:

   • Campaign name or type (email, paid, event, content, SMM, or other)
   • Campaign goal (target metric and value)
   • Period (start date — end date)
   • Channels used

2. If any of these are missing and not inferable from the input:

   • Ask for missing context in a single consolidated prompt (do not ask field by field)
   • Example: «Укажите: (1) тип кампании, (2) цель, (3) период, (4) каналы — или то, что помните.»

Edge Cases:

• EC3: Multiple campaigns in one input → ask which one to process; if no answer, process the first one and add note: «Обработана первая кампания; укажите название для остальных.»
• EC4: Mixed-language input (EN + RU) → respond in the language of the majority; at 50/50 — respond in the language of the latest user message

Step 3: Build Goal vs. Result Table

1. Extract key campaign metrics from the input (CTR, conversions, reach, revenue, etc.)
2. For each metric, record: target value | actual value | delta (%)
3. If target was not stated: mark goal column as «—»
4. If actual value is missing: mark as «н/д» / «n/a» — never invent numbers

Edge Cases:

• EC2: Only qualitative notes, no numeric metrics → populate table with «н/д» in numeric cells; add note: «Числовые метрики не предоставлены — дополните таблицу вручную.»

Step 4: Build Channel Breakdown Table

1. For each channel identified in Step 2:
   • List the key metric for that channel (e.g., Email → open rate; Paid → CPC; SMM → engagement rate)
   • Record the result
   • Mark as ✅ (worked) or ❌ (didn't work) based on input context or goal achievement
2. If only one channel: single-row table is valid

Edge Cases:

• EC1: Only quantitative data (no qualitative context) → complete the table; mark «What Worked» section as «Добавьте качественный контекст вручную.»
• EC2: Only qualitative notes, no numeric results → mark the Result column as «н/д» / «n/a» for all channels; still assign ✅/❌ based on qualitative context where possible.

Step 5: Generate What Worked / What Didn't + Hypotheses

1. Create two lists based on the input and the Channel Breakdown table:
   • What Worked: positive outcomes with an explicit hypothesis of cause
   • What Didn't Work: underperforming areas with an explicit hypothesis of cause
2. Mark every hypothesis with the label (гипотеза) / (hypothesis) — never present hypotheses as facts
3. Minimum 1 item in each list; if the input doesn't support separation, write: «Недостаточно данных — дополните вручную.»

Step 6: Write Recommendations

1. Generate three sub-lists based on Steps 4 and 5:
   • Повторить / Repeat: what worked and should be replicated
   • Изменить / Adjust: what showed promise but needs refinement
   • Убрать / Drop: what didn't work and should be removed

Step 7: Add Trend Line

1. Write exactly one line summarising the campaign for cross-campaign tracking:
   • Format: [Campaign name/type] [period]: [key metric], [delta vs. prev if known] — [1-line takeaway]
   • Example: Email Q2-2026: CTR 2.4%, +0.6% vs. Q1 — A/B subject line test drove the uplift
2. If no previous campaign data is available: omit delta; note «нет данных для сравнения / no prior data»

---

Negative Cases

• Empty input (NEG1): No metrics or notes provided → stop immediately (see Step 1)
• Active campaign (NEG2): Campaign appears ongoing → warn + require confirmation before proceeding
• No channels identified: Cannot determine any channel from input → ask in Step 2 consolidated prompt
• Goal only, no results: If user provides only the goal with no actuals → produce template with «н/д» cells; note that ретро requires actual results to be meaningful

---

Output Format

Output a Markdown document with this structure:

## Campaign Retrospective: [Campaign Name]

**Тип / Type:** [email / paid / event / content / SMM / other]
**Период / Period:** [YYYY-MM-DD — YYYY-MM-DD]
**Каналы / Channels:** [comma-separated list]

---

### 1. Goal vs. Result

| Метрика / Metric | Цель / Goal | Факт / Actual | Δ% |
|-----------------|-------------|---------------|----|
| [metric]        | [target]    | [actual]      | [+/-%] |

---

### 2. Channel Breakdown

| Канал / Channel | Ключевая метрика / Key Metric | Результат / Result | Итог / Verdict |
|----------------|------------------------------|-------------------|----------------|
| [channel]      | [metric]                     | [value]           | ✅ / ❌ |

---

### 3. What Worked
- [outcome] — **(гипотеза / hypothesis): [reason]**

### 4. What Didn't Work
- [outcome] — **(гипотеза / hypothesis): [reason]**

---

### 5. Recommendations

**Повторить / Repeat:** [list]
**Изменить / Adjust:** [list]
**Убрать / Drop:** [list]

---

### 6. Trend Line
`[Campaign name] [period]: [key metric], [delta] — [1-line takeaway]`

Field rules:

• All numeric cells with missing data: «н/д» / «n/a» (never invent values)
• Hypotheses always labelled (гипотеза) / (hypothesis)
• Trend Line is exactly one line
• Section headers are bilingual (RU/EN) when responding in Russian; English-only when responding in English