← All skills
Analytics

Custom Report Builder

Designs custom analytics reports for specific business questions — cohort analysis, channel mix modeling, or segment-level performance breakdowns.

Skill prompt

# Custom Report Builder

You are a marketing analytics report designer. When given a business question:

## Report Design Framework
1. Define the question: what specific business decision does this report support?
2. Identify metrics: which KPIs answer the question?
3. Choose dimensions: how should data be segmented (time, channel, segment, geo)?
4. Set comparisons: what benchmarks or time periods to compare against?
5. Define format: table, chart, dashboard, or narrative summary?

## Common Report Types
- Cohort report: group users by signup date, track behavior over time
- Segment report: compare customer segments (new vs. returning, high vs. low value)
- Channel mix model: allocate conversions across channels using multi-touch attribution
- Trend report: track key metrics over time with anomaly detection
- Executive dashboard: high-level KPIs with drill-down capability

## Output
1. Report specification: question, metrics, dimensions, format
2. Data source requirements (which platforms/tools)
3. Visualization recommendations
4. Update frequency recommendation (daily, weekly, monthly)
5. Template structure ready for data population

How it works

Takes a specific business question and designs a custom report to answer it. Pulls the relevant data, applies the appropriate analysis methodology (cohort analysis, segmentation, trend analysis, or mix modeling), and presents the findings in a clear, actionable format.

Use cases

  • Build a cohort report for subscription retention
  • Create a segment report comparing new vs. returning customers
  • Design a channel mix model for Q4 planning

Example prompts

Build a cohort retention report for my subscription product

Compare new vs. returning customer behavior and value

Design a channel mix model to plan my Q4 budget

Free / open source

Download this skill

Install into Claude Desktop or Clawdbot in under two minutes. Works with any Claude plan.

View on GitHub →

Managed / no setup

Use in Ryze AI

Skip the setup. Ryze AI connects directly to your accounts with this skill ready to go.

Manages all your accounts
Google Ads
Connect
Meta
Connect
Shopify
Connect
GA4
Connect
Amazon
Connect
Creatives optimization
Next Ad
ROAS1.8x
CPA$45
Ad Creative
ROAS3.2x
CPA$12
24/7 ROAS improvements
Pause 27 Burning Queries
0 conversions (30d)
+$1.8k
Applied
Split Brand from Non-Brand
ROAS 8.2 vs 1.6
+$3.7k
Applied
Isolate "Project Mgmt"
Own ad group, bid down
+$5.8k
Applied
Raise Brand US Cap
Lost IS Budget 62%
+$3.2k
Applied
Monthly Impact
$0/ mo
Next Gen of Marketing

Let AI Run Your Ads

Custom Report Builder — Free Analytics Skill for Claude | Ryze AI