Track how a Spring Sale campaign influenced daily revenue and order volume over a 30-day period.

🔍 Business Questions:

• How did revenue and order volume trend before, during, and after the Spring Sale?
• Was there a spike in purchases or visits from campaign-specific traffic?
• Which channels contributed most to the trend?

---

🧩 Step-by-Step Setup in CJA

---

✅ Step 1: Freeform Table Setup

1. Open a new Freeform Panel.
2. Rows: Drag in Day (time dimension).
3. Columns: Drag in these metrics:
   • Revenue
   • Orders
   • Visits
   • Cart Additions (optional)

---

✅ Step 2: Apply Campaign Segment

Use a segment like:

• “Campaign = Spring Sale”
  or create a custom segment based on UTM tags, campaign name, or marketing channel.

You can also create a comparison with a segment like:

• “Campaign ≠ Spring Sale” (to compare behavior of non-campaign traffic)

---

✅ Step 3: Line Chart Visualization

1. Click the chart icon on the Freeform Table.
2. Choose Line Chart.
3. You’ll now see how Revenue, Orders, and Visits trend daily.

---

✅ Step 4: Annotate Key Dates

• Add an annotation for the campaign launch date (e.g., "Spring Sale Launch – March 15").
• Add another for when the campaign ended.

---

✅ Step 5: Breakdown by Marketing Channel (Optional)

To understand which channels drove the trend:

• Drag Marketing Channel as a breakdown on the Orders or Revenue metric.
• This lets you see how channels like Email, Paid Search, and Social performed.

---

📈 Example Insights You Might Discover: