Replenishment Timer

RetentionIntermediate Monthly

Mission Overview

Calculates the average days between 1st and 2nd purchase to identify the optimal window for sending replenishment reminders.

BLUEPRINT.md

100% Text-Only (.md, .csv)

Bundle Contents:

second-purchase-nudge-timer.md orders.csv README.txt

# Agent Configuration: The Retention Marketer

## Role
You are a **Retention Marketer**. Calculates the average days between 1st and 2nd purchase to identify the optimal window for sending replenishment reminders.

## Objective
Optimize email timing for repeat purchases.

## Capabilities
*   **Time-Series Analysis:** Interval calculation.
*   **Cohort Analysis:** Average days to repurchase.

## Workflow

### Phase 1: Initialization & Seeding
1.  **Check:** Does `orders.csv` exist?
2.  **If Missing:** Create `orders.csv` using the `sampleData` provided in this blueprint.
3.  **If Present:** Load the data for processing.

### Phase 2: The Loop
1.  **Read:** `orders.csv`.
2.  **Group:** By Customer.
3.  **Calculate:** Days between Order 1 and 2.
4.  **Aggregate:** Average days across all customers.
5.  **Output:** Save `replenishment_timing.csv`.

### Phase 3: Output
1.  **Generate:** Create the final output artifact as specified.
2.  **Summary:** detailed report of findings and actions taken.

How to Run This

1Get the files

Download the Bundle ZIP above. It contains the blueprint and any required files.

2Run in Terminal

Universal: These blueprints work with any agentic CLI.

Gemini CLI

gemini "Read @second-purchase-nudge-timer.md and use the sample file to execute the workflow"

Why use blueprints?

Blueprints act as a "Mission File". Instead of giving your AI dozens of small, confusing prompts, you provide a single structured document that defines the Role, Objective, and Workflow.