Connecting to Data · Legacy self-service product
Klaviyo
Analyze email campaigns, flows, and subscriber engagement
Connect Klaviyo to Scoop to analyze your email marketing performance, track campaign effectiveness, understand automation flows, and measure subscriber engagement.
AI-Assisted Setup
When connecting Klaviyo to Scoop, choose "Guide me with AI" for an intelligent, guided setup experience.
Available Analysis Templates
| Template | Object | Data Mode | Best For | What You'll Analyze |
|---|---|---|---|---|
| Campaign Performance (Default) | campaigns | Snapshot | Email effectiveness | Send timing, status, audiences |
| Flow Analytics | flows | Sync | Automation analysis | Trigger types, flow status |
| Audience Segments | lists | Sync | List management | Subscriber lists, opt-in processes |
| Subscriber Profiles | profiles | Sync | Contact database | Email/SMS contacts, lifecycle |
Example Questions You Can Answer
Campaign Performance:
- "How many campaigns did we send this month vs last month?"
- "What's the distribution of campaign statuses (sent, scheduled, draft)?"
- "When are we sending most of our campaigns?"
- "How has our campaign volume trended over time?"
- "Which audiences receive the most campaigns?"
Flow Automation:
- "How many flows are currently live vs draft?"
- "What trigger types are we using most (list, segment, metric)?"
- "When were our flows last updated?"
- "How has our automation complexity grown over time?"
- "What's the breakdown of flow statuses?"
Audience Management:
- "How many subscriber lists do we have?"
- "Are we using single or double opt-in?"
- "When was each list created?"
- "How has our audience structure evolved?"
Subscriber Analysis:
- "How many total subscribers do we have?"
- "What percentage have both email and phone?"
- "What's our subscriber acquisition trend?"
- "When were subscribers last updated?"
Need Something Different?
If the templates above don't match your needs, select "Something else" and describe what you want to analyze. For example:
- "I want to track campaign sends by day of week"
- "I need to see flow performance over time"
- "I want to analyze subscriber growth by month"
Scoop's AI will recommend the right configuration for your specific use case.
Snapshotting for Campaign Analysis
Campaigns change over time - they move from draft to scheduled to sent. Configure your Campaigns extract as a Snapshot dataset to:
- Track campaign creation and send timing
- Monitor status transitions over time
- Analyze send frequency patterns
- Compare campaign volumes week-over-week
Pro Tip: Enable snapshotting for campaigns to track your email marketing velocity and identify optimal send times.
Connecting Klaviyo to Scoop
- Create a new dataset in Scoop
- Select Klaviyo from the application list
- Enter your Klaviyo API key (starts with
pk_) - Choose your analysis template or customize
- Save and extract data
Getting Your API Key
- Log in to your Klaviyo account
- Go to Settings > API Keys
- Click Create Private API Key
- Give it a name (e.g., "Scoop Analytics")
- Select Read Only access for the scopes you need
- Copy the API key (starts with
pk_)
Security Note: API keys provide read-only access to your Klaviyo data. Never share your private API key publicly.
What Data You Get
Campaigns
Email campaign metadata and performance tracking.
| Field | Description |
|---|---|
| Campaign ID | Unique identifier (prefixed with KL) |
| Campaign Name | Name of the campaign |
| Status | draft, scheduled, sent, cancelled |
| Send Time | When the campaign was sent |
| Created Date | When the campaign was created |
| Updated Date | Last modification date |
| Audiences | Target audiences (JSON) |
Flows
Automated email/SMS sequences and triggers.
| Field | Description |
|---|---|
| Flow ID | Unique identifier (prefixed with KL) |
| Flow Name | Name of the automation flow |
| Status | draft, manual, live |
| Trigger Type | What triggers the flow (list, segment, metric) |
| Created Date | When the flow was created |
| Updated Date | Last modification date |
Lists
Subscriber lists and audience segments.
| Field | Description |
|---|---|
| List ID | Unique identifier (prefixed with KL) |
| List Name | Name of the subscriber list |
| Created Date | When the list was created |
| Updated Date | Last modification date |
| Opt-in Process | single_opt_in or double_opt_in |
Profiles
Individual subscriber contact information.
| Field | Description |
|---|---|
| Profile ID | Unique identifier (prefixed with KL) |
| Subscriber email address | |
| Phone | Phone number for SMS |
| First Name | Subscriber first name |
| Last Name | Subscriber last name |
| Created Date | When the profile was created |
| Updated Date | Last activity date |
Analysis Examples
Campaign Velocity
Track your email marketing output over time:
- Campaigns sent per week/month
- Status distribution trends
- Peak send times
Automation Coverage
Understand your flow strategy:
- Active vs draft flows
- Trigger type distribution
- Automation growth over time
Subscriber Growth
Monitor your audience:
- New subscriber acquisition
- Multi-channel coverage (email + SMS)
- List distribution
Best Practices
- Start with Campaigns: Campaign data shows immediate marketing activity
- Enable Snapshotting: Track how campaigns move through statuses
- Combine with Flows: Understand the balance between manual and automated sends
- Monitor Profiles: Track subscriber growth alongside campaign performance
Troubleshooting
Connection Issues
- Verify your API key starts with
pk_ - Ensure the API key has read access to the required objects
- Check that your Klaviyo account is active
Missing Data
- Some metrics require Klaviyo's paid plans
- Performance metrics may require additional API endpoints
- Profile data respects Klaviyo's privacy settings
Rate Limits
Klaviyo has tiered rate limits. If you see rate limit errors:
- Scoop automatically retries with backoff
- Large extracts may take longer during peak times
- Contact support if persistent issues occur