Chart Deep Dive
When to Use
- A metric spiked or dropped unexpectedly
- You need to understand what’s driving a trend
- Preparing a detailed, evidence-backed analysis for stakeholders
- Investigating differences between user or event segments
Instructions
Step 0: Identify the Chart
- Accept a chart URL or chart ID
- If the user provides a URL, use
Amplitude:get_from_url to extract the chart ID
- If no chart identifier is provided, ask explicitly for the chart URL or ID and stop
Step 1: Retrieve and Validate Chart Data (Mandatory)
- Use Reading chart data to retrieve the chart definition and data
- If chart data cannot be retrieved or is empty, do not proceed
- Explain what’s missing (time range, event, filters, permissions)
- Ask the user to correct the chart or provide a valid chart
Capture and restate:
- Metric being measured
- Time range and granularity
- Chart type (e.g. time series, funnel, retention)
- Existing filters, segments, or breakdowns
Step 2: Identify the Pattern and Change Window
Use Analyzing chart to characterize what’s happening:
- Spike / Drop: Sudden change on specific date(s)
- Trend: Gradual increase or decrease over time
- Seasonality: Recurring weekly or monthly patterns
- Anomaly: Deviation from recent baseline or historical behavior
Explicitly identify:
- The window of change (start/end)
- Direction and magnitude of the change
- Baseline period used for comparison (default: previous equal-length period)
Step 3: Investigate Likely Drivers (Bounded)
Instead of broad slicing, use guided segmentation:
- Use Finding the right event properties to identify the most relevant properties for explaining the change
- Select up to 9 high-signal properties (e.g. platform, country, plan, version)
- Re-run Analyzing chart with these properties in mind to determine:
- Which segments contribute most to the change
- Whether the pattern is localized or broad-based
- Only fetch up to 3 charts at a time when using
Amplitude:query_charts
Avoid testing more than 9 properties in aggregate unless the user explicitly asks for deeper exploration.
Step 4: Correlate with Context (Required for Anomalies)
For spikes, drops, or unexpected shifts, gather contextual signals in the same timeframe:
- Use Getting experiments to identify active experiments or flags
- Use Getting deployments to identify releases or rollouts
- Use Searching for content to surface annotations or relevant documentation
- Use
Amplitude:get_feedback_insights to search customer feedback trends that might explain the change
- Use
Amplitude:get_feedback_mentions to pull in specific customer mentions if there's a likely feedback trend tied to what's being explained.
Determine whether any contextual changes align temporally with the chart pattern.
Step 5: Synthesize Findings
Present a structured, decision-ready analysis:
What Happened
Clear description of the observed pattern and magnitude
When
Exact timeframe and comparison baseline
Primary Hypothesis
Most likely explanation based on chart data and contextual signals
Supporting Evidence
- Key metrics
- Segment contributions
- Relevant experiments, deployments, or annotations
Alternative Explanations
1–3 plausible alternatives and why they are less likely
Impact
Quantify impact where possible (users, events, conversion, revenue proxy)
Recommended Next Step
One clear follow-up action (e.g. deeper segment, experiment review, instrumentation check)
Always include:
- Chart name
- Chart ID
- Link back to the chart
- Coverage (e.g. properties tested, segments analyzed)
Best Practices
- Always compare against a clear baseline period
- Distinguish observations from hypotheses
- Prefer high-signal segmentation over exhaustive slicing
- Note data quality issues (low volume, incomplete periods, heavy “(none)” values)
- Do not create or edit charts unless the user explicitly asks
1---2name: analyze-chart3description: Performs deep analysis of a specific Amplitude chart to explain trends, anomalies, and likely drivers. Use when a metric looks unusual, investigating a spike or drop, or understanding the "why" behind numbers.4---5
6# Chart Deep Dive
7
8## When to Use
9
10- A metric spiked or dropped unexpectedly
11- You need to understand what’s driving a trend
12- Preparing a detailed, evidence-backed analysis for stakeholders
13- Investigating differences between user or event segments
14
15## Instructions
16
17### Step 0: Identify the Chart
18
19- Accept a chart **URL or chart ID**
20- If the user provides a URL, use `Amplitude:get_from_url` to extract the chart ID
21- If no chart identifier is provided, ask explicitly for the chart URL or ID and stop
22
23---
24
25### Step 1: Retrieve and Validate Chart Data (Mandatory)
26
27- Use **Reading chart data** to retrieve the chart definition and data
28- If chart data cannot be retrieved or is empty, **do not proceed**
29 - Explain what’s missing (time range, event, filters, permissions)
30 - Ask the user to correct the chart or provide a valid chart
31
32Capture and restate:
33- Metric being measured
34- Time range and granularity
35- Chart type (e.g. time series, funnel, retention)
36- Existing filters, segments, or breakdowns
37
38---
39
40### Step 2: Identify the Pattern and Change Window
41
42Use **Analyzing chart** to characterize what’s happening:
43
44- **Spike / Drop**: Sudden change on specific date(s)
45- **Trend**: Gradual increase or decrease over time
46- **Seasonality**: Recurring weekly or monthly patterns
47- **Anomaly**: Deviation from recent baseline or historical behavior
48
49Explicitly identify:
50- The **window of change** (start/end)
51- Direction and magnitude of the change
52- Baseline period used for comparison (default: previous equal-length period)
53
54---
55
56### Step 3: Investigate Likely Drivers (Bounded)
57
58Instead of broad slicing, use **guided segmentation**:
59
601. Use **Finding the right event properties** to identify the most relevant properties for explaining the change
612. Select **up to 9 high-signal properties** (e.g. platform, country, plan, version)
623. Re-run **Analyzing chart** with these properties in mind to determine:
63 - Which segments contribute most to the change
64 - Whether the pattern is localized or broad-based
65 - Only fetch up to 3 charts at a time when using `Amplitude:query_charts`
66
67Avoid testing more than 9 properties in aggregate unless the user explicitly asks for deeper exploration.
68
69---
70
71### Step 4: Correlate with Context (Required for Anomalies)
72
73For spikes, drops, or unexpected shifts, gather contextual signals in the same timeframe:
74
75- Use **Getting experiments** to identify active experiments or flags
76- Use **Getting deployments** to identify releases or rollouts
77- Use **Searching for content** to surface annotations or relevant documentation
78- Use `Amplitude:get_feedback_insights` to search customer feedback trends that might explain the change
79- Use `Amplitude:get_feedback_mentions` to pull in specific customer mentions if there's a likely feedback trend tied to what's being explained.
80
81Determine whether any contextual changes align temporally with the chart pattern.
82
83---
84
85### Step 5: Synthesize Findings
86
87Present a structured, decision-ready analysis:
88
891. **What Happened**
90 Clear description of the observed pattern and magnitude
91
922. **When**
93 Exact timeframe and comparison baseline
94
953. **Primary Hypothesis**
96 Most likely explanation based on chart data and contextual signals
97
984. **Supporting Evidence**
99 - Key metrics
100 - Segment contributions
101 - Relevant experiments, deployments, or annotations
102
1035. **Alternative Explanations**
104 1–3 plausible alternatives and why they are less likely
105
1066. **Impact**
107 Quantify impact where possible (users, events, conversion, revenue proxy)
108
1097. **Recommended Next Step**
110 One clear follow-up action (e.g. deeper segment, experiment review, instrumentation check)
111
112Always include:
113- Chart name
114- Chart ID
115- Link back to the chart
116- Coverage (e.g. properties tested, segments analyzed)
117
118---
119
120## Best Practices
121
122- Always compare against a clear baseline period
123- Distinguish **observations** from **hypotheses**
124- Prefer high-signal segmentation over exhaustive slicing
125- Note data quality issues (low volume, incomplete periods, heavy “(none)” values)
126- Do **not** create or edit charts unless the user explicitly asks