Use the Klaviyo data source connector to create an overview dashboard to follow the complete customer journey in e-commerce. Create reports to track seasonal changes in purchase volumes and measure campaign success.
Before you begin
Before you build reports, you need to connect the data source to Supermetrics.
Connection instructions: See our Klaviyo connection guide.
Available metrics and dimensions: Find the full list of fields in our Klaviyo field documentation.
Popular queries
These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.
Track list subscription growth over time
See how new subscriptions to your lists have evolved day by day over the last 28 days, broken down by list — useful for identifying which lists are growing fastest and spotting any sudden drops in opt-ins.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last 28 days |
Metrics | New subscriptions to list |
Dimensions | Date, List |
Suggested visualization | Table |
Understanding the data
New subscriptions to list: The number of times someone opted into a list within the reporting period.
Date: Splits results by day so you can track subscription trends over time.
List: The name of the list, used to compare subscription growth across different lists.
Monitor email delivery and opens last week
See how many emails were received and how many were opened last week — useful for tracking delivery health and open rate trends across your email sends.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last week (Mon–Sun) |
Metrics | Emails received, Emails opened (unique) |
Dimensions | Date |
Suggested visualization | Table |
Understanding the data
Emails received: The number of times a recipient received an email within the reporting period.
Emails opened (unique): The number of unique recipients who opened an email.
Date: Splits results by day to track delivery and open trends over the week.
Analyze email campaign performance last month
Get a comprehensive view of last month's email campaigns — covering bounces, clicks, opens, unsubscribes, and WooCommerce order data — so you can evaluate the full impact of your campaigns on revenue.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last month |
Metrics | Emails bounced, Email click rate, Emails clicked (unique), Email open rate, Emails opened (unique), Email recipients, Unsubscribes from all emails, Woocommerce orders, Woocommerce order value |
Dimensions | Campaign send date & time, Content status, Subject |
Suggested visualization | Table |
Understanding the data
Emails bounced: The number of times an email soft or hard bounced.
Email click rate: Unique email clicks divided by received emails.
Emails clicked (unique): The number of unique recipients who clicked an email.
Email open rate: Unique email opens divided by received emails.
Emails opened (unique): The number of unique recipients who opened an email.
Email recipients: The number of recipients the email was sent to.
Unsubscribes from all emails: The number of times someone unsubscribed from emails globally.
Woocommerce orders: The number of times a customer completed checkout and created an order in your WooCommerce store.
Woocommerce order value: The total value of placed orders, inclusive of shipping and any applied discounts.
Campaign send date & time: The date and time the campaign was sent, used to identify each campaign.
Content status: The status of the campaign content at the time of the query.
Subject: The subject line of the email campaign.
Compare subscriber growth year over year
See how new list subscriptions have trended month by month this year compared to the previous year — useful for evaluating list growth strategies and identifying seasonal patterns in opt-in behavior.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Year to date |
Date range comparison | Previous period |
Metrics | New subscriptions to list |
Dimensions | Month |
Suggested visualization | Time series chart |
Understanding the data
New subscriptions to list: The number of times someone opted into a list within the reporting period.
Month: Splits results by month so you can compare subscription trends across the year.
More resources
You might also be interested in: