1
of 5— Export Your Campaign Data
Use Google Sheets with AI Formulas for Email Analytics
Step 1: Export Your Campaign Data
From your ESP, export campaign performance data as CSV. Most ESPs export a format like:
| Campaign Name | Send Date | List Size | Delivered | Opens | Unique Opens | Clicks | Unique Clicks | Unsubscribes | Revenue |
|---|
Import to Google Sheets: File → Import → Upload CSV → Import data.