Trend Spotting & Forecasting

AI helps you see the forest, not just the trees. It can identify trends that take humans hours to spot and project them forward.

Trend Analysis Fundamentals

The Comprehensive Trend Prompt

"Analyze these monthly metrics and identify trends:

[paste data]

For each metric:

1. Direction (improving, declining, stable, volatile)

2. Rate of change (is it accelerating or decelerating?)

3. Inflection points (when did the trend change direction?)

4. Correlation with other metrics (do any move together?)

5. Projection for the next 3-6 months with confidence level"

Seasonal Pattern Detection

"Look at this 24-month data set:

[paste data]

Identify any seasonal patterns:

- Which months consistently over/underperform?

- Is there a yearly cycle?

- How strong is the seasonal effect vs the overall trend?

- What should I plan for given these patterns?"

Forecasting with AI

Simple Projection

"Based on this 12-month revenue history:

[paste data]

Provide three forecasts for the next 6 months:

1. Conservative (assuming the worst-performing quarter repeats)

2. Most likely (based on the average trend)

3. Optimistic (assuming the best-performing quarter repeats)

Show the numbers and explain your methodology for each."

Scenario Modeling

"Given this historical data:

[paste data]

Model these scenarios:

- Scenario A: We increase marketing spend by 20%

- Scenario B: A competitor enters our market and we lose 15% market share

- Scenario C: We raise prices by 10%

For each scenario, project revenue, costs, and profit for the next 4 quarters. State your assumptions clearly."

Leading vs Lagging Indicators

"For a [business type], help me identify:

Leading indicators (predict future performance):

- What early signals suggest revenue will go up or down?

Lagging indicators (confirm what already happened):

- What metrics tell me how we've been performing?

For each indicator, explain: what it measures, how to track it, and what a change in this metric means for the business."

Correlation Analysis

"I'm tracking these metrics monthly:

[paste data with multiple columns]

Analyze the relationships between these metrics:

1. Which metrics are positively correlated (move together)?

2. Which are negatively correlated (move opposite)?

3. Which appear unrelated?

4. Are there any lagged correlations (X goes up, and Y follows 1-2 months later)?

Warning: flag any correlations that might be coincidental rather than causal."

The Forecasting Caveat

AI forecasting is based on pattern recognition from historical data. It cannot predict:

• •Black swan events (pandemic, market crash)
• •Competitor actions you don't know about
• •Regulatory changes
• •Viral moments or PR crises

Always present AI forecasts as scenarios, not predictions. The value is in exploring possibilities, not in having a crystal ball.