AIプロンプト： アナリティクス＆インサイト

I need a marketing dashboard for [business type].

Channels I use: [list marketing channels]
Reporting frequency: [daily/weekly/monthly]
Audience for dashboard: [who sees this — CEO, marketing team, client]
Current tools: [Google Analytics, HubSpot, etc.]
Biggest question leadership asks: [what they always want to know]

Design a dashboard with:
1. 5-7 KPIs that belong on the top row (with target benchmarks)
2. Supporting metrics organized by channel
3. The exact charts/visualizations for each metric (line, bar, pie, etc.)
4. Comparison views: this period vs. last period, and vs. goal
5. One 'early warning' metric that predicts problems before they happen
6. A 3-minute walkthrough script for presenting this dashboard

Analyze these campaign results and tell me what to do next:

[Paste campaign data: impressions, clicks, conversions, spend, CTR, CPC, ROAS, etc.]

Campaign type: [paid ads/email/social/content]
Campaign goal: [awareness/leads/sales]
Budget: [total spend]
Time period: [how long the campaign ran]
Benchmarks: [industry averages if known]

Provide:
1. Performance summary: what worked and what didn't (be specific)
2. The single biggest lever to improve results
3. Budget reallocation recommendation with exact percentages
4. 3 hypotheses for why underperforming elements failed
5. A/B test recommendations for the next campaign iteration
6. A 'stop, start, continue' action list

Help me understand which marketing channels are actually driving results.

Channels: [list all active channels with monthly spend]
Sales cycle length: [average time from first touch to conversion]
Conversion tracking: [what I can currently measure]
CRM/tools: [what tools I use for tracking]
Biggest attribution confusion: [what I can't figure out]

Advise me on:
1. Which attribution model fits my business (first-touch, last-touch, linear, etc.) and why
2. How to set up that model in my current tools
3. Channel interactions I'm probably missing
4. A simplified attribution framework I can implement this week
5. What to do when channels can't be directly attributed (brand, content, PR)
6. How to present attribution findings to stakeholders who want simple answers

Help me build a cohort analysis for [business/product].

Cohort definition: [how to group users — signup month, acquisition channel, plan type]
Key metric to track: [retention, revenue, engagement, etc.]
Time period: [how far back to analyze]
Data I have access to: [describe available data fields]
Goal: [reduce churn / increase LTV / improve activation]

Build:
1. A cohort table structure I can create in [Sheets/Excel/SQL]
2. The exact formulas or queries to calculate cohort metrics
3. How to read the cohort table — what patterns to look for
4. 3 insights that cohort analysis typically reveals (with examples)
5. Actions to take based on common cohort patterns
6. A visual format recommendation for presenting findings to the team

Help me find where I'm losing potential customers in my funnel.

Funnel stages with conversion rates:
[Stage 1]: [name] — [number entering] — [conversion rate to next stage]
[Stage 2]: [name] — [number entering] — [conversion rate to next stage]
[Stage 3]: [name] — [number entering] — [conversion rate to next stage]
[Stage 4]: [name] — [number entering] — [final conversion rate]

Industry: [your industry]
Traffic sources: [where visitors come from]

Analyze and provide:
1. Which stage has the biggest leak and why it matters most
2. Benchmark comparison: how my rates compare to industry averages
3. 3 specific fixes for the leakiest stage (with expected improvement)
4. Micro-conversion additions between stages to diagnose friction
5. Segment analysis: which traffic sources have the best/worst funnel flow
6. A 2-week experiment plan to improve the weakest stage by 15%+

Generate my monthly marketing report from this data:

[Paste key metrics: traffic, leads, conversions, revenue, spend by channel]

Reporting month: [month/year]
Previous month data: [for comparison]
Goals for this month: [targets that were set]
Report audience: [CEO/board/marketing team/client]

Create:
1. An executive summary (3-4 sentences covering the headline story)
2. Performance vs. goals table with red/yellow/green status indicators
3. Channel-by-channel breakdown with trend arrows
4. Top 3 wins with evidence
5. Top 3 concerns with recommended actions
6. Next month's priorities and projected outcomes
7. One chart recommendation that tells the most compelling story from this data