Introduction
Export your attribution data for deeper analysis in Excel, Google Sheets, or business intelligence tools. Pro users can export up to 5,000 orders at a time.
How to Export
- Go to Attribution dashboard
- Set your desired date range
- Apply any filters (source, medium, campaign)
- Click the Export CSV button
- Your browser will download the CSV file
Export File Contents
The CSV file includes these columns:
| Column | Description | Example |
| order_id | Shopify order ID | 5678901234 |
|---|---|---|
| order_number | Order number shown to customer | #1042 |
| order_date | Date and time of purchase | 2026-01-15 14:32:00 |
| customer_email | Customer email (if captured) | john@example.com |
| revenue | Order total | 149.99 |
| currency | Currency code | USD |
| source | utm_source value | |
| medium | utm_medium value | paid |
| campaign | utm_campaign value | winter_sale |
| content | utm_content value | video_ad_1 |
| term | utm_term value | running shoes |
| landing_page | Full URL of first page | /products/shoes |
| referrer | Referring website | facebook.com |
| gclid | Google click ID | abc123… |
| fbclid | Facebook click ID | xyz789… |
| ttclid | TikTok click ID | tik123… |
Export Limits
| Plan | Max Orders per Export |
| Free | Not available |
|---|---|
| Basic | Not available |
| Pro | 5,000 orders |
| Agency | 10,000 orders |
For larger exports, break your date range into smaller chunks.
Using Exported Data
In Excel
- Open Excel
- File → Open → Select your CSV
- Data will load in columns
- Use Pivot Tables for analysis
Sample Pivot Table:
- Rows: source, medium
- Values: Sum of revenue, Count of order_id
In Google Sheets
- Open Google Sheets
- File → Import → Upload
- Select your CSV file
- Choose “Replace spreadsheet”
Sample Formulas:
=SUMIF(F:F, "facebook", E:E) // Total Facebook revenue
=COUNTIF(F:F, "email") // Count of email orders =AVERAGEIF(G:G, "paid", E:E) // Average paid order value
In Data Studio / Looker
- Create new data source
- Upload CSV file
- Create charts and dashboards
- Schedule regular exports for fresh data
Automating Exports
API Access (Agency Plan)
Agency plan users can access attribution data via API:
GET /api/attribution?shop=yourstore.myshopify.com&days=30Response includes JSON array of orders with attribution data.
Scheduled Reports
Coming soon: Automated weekly/monthly CSV exports via email.
Data Privacy Notes
- Exported data contains customer emails
- Handle according to your privacy policy
- Don’t share raw exports publicly
- Delete exports when no longer needed
—