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

TemplateObjectData ModeBest ForWhat You'll Analyze
Campaign Performance (Default)campaignsSnapshotEmail effectivenessSend timing, status, audiences
Flow AnalyticsflowsSyncAutomation analysisTrigger types, flow status
Audience SegmentslistsSyncList managementSubscriber lists, opt-in processes
Subscriber ProfilesprofilesSyncContact databaseEmail/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

  1. Create a new dataset in Scoop
  2. Select Klaviyo from the application list
  3. Enter your Klaviyo API key (starts with pk_)
  4. Choose your analysis template or customize
  5. Save and extract data

Getting Your API Key

  1. Log in to your Klaviyo account
  2. Go to Settings > API Keys
  3. Click Create Private API Key
  4. Give it a name (e.g., "Scoop Analytics")
  5. Select Read Only access for the scopes you need
  6. 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.

FieldDescription
Campaign IDUnique identifier (prefixed with KL)
Campaign NameName of the campaign
Statusdraft, scheduled, sent, cancelled
Send TimeWhen the campaign was sent
Created DateWhen the campaign was created
Updated DateLast modification date
AudiencesTarget audiences (JSON)

Flows

Automated email/SMS sequences and triggers.

FieldDescription
Flow IDUnique identifier (prefixed with KL)
Flow NameName of the automation flow
Statusdraft, manual, live
Trigger TypeWhat triggers the flow (list, segment, metric)
Created DateWhen the flow was created
Updated DateLast modification date

Lists

Subscriber lists and audience segments.

FieldDescription
List IDUnique identifier (prefixed with KL)
List NameName of the subscriber list
Created DateWhen the list was created
Updated DateLast modification date
Opt-in Processsingle_opt_in or double_opt_in

Profiles

Individual subscriber contact information.

FieldDescription
Profile IDUnique identifier (prefixed with KL)
EmailSubscriber email address
PhonePhone number for SMS
First NameSubscriber first name
Last NameSubscriber last name
Created DateWhen the profile was created
Updated DateLast 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