Klaviyo

With TMR's Klaviyo connector, you can track email performance, optimize campaigns, and build data-driven reports — all directly in Google Sheets.

Before connecting your Klaviyo account, confirm you have the required permissions in place.

Required permissions

To connect your Klaviyo account with Two Minute Reports, ensure the following:

• Your Klaviyo user role must be Admin, Owner, or Manager.
• You need a private API key with read-only scope to enable the connection (see Step 3 below).
• Keep your API key safe and secure to avoid unauthorized access or data loss.

Learn more about user roles and privileges in Klaviyo's help article.

Once you confirm these prerequisites, follow the steps below to connect Klaviyo data to Google Sheets through Two Minute Reports.

Step 1: Install and launch Two Minute Reports

Install the add-on first if you have not already:

• Install Two Minute Reports in Google Sheets

When installation is complete, open your spreadsheet and launch TMR from Extensions → Two Minute Reports → Launch. You can then connect your Klaviyo data to Google Sheets.

Step 2: Create a new connection for your Klaviyo account

In the TMR sidebar:

1. Click Menu at the top left and go to Connections.
2. Click Add to create a new connection.

When the Adding New Connection dialog appears, complete these steps:

1. Select the Klaviyo connector from the list.
2. Authenticate by entering the API key from your Klaviyo dashboard (see Step 3).
3. Enable the Klaviyo accounts you want to use with this connection.

Choose Klaviyo from the connector list, then continue with API key authentication.

Step 3: Generate the API key from the Klaviyo dashboard

Open profile settings

In your Klaviyo dashboard, open your Profile menu, then choose Settings.

Open API keys

Under the Account menu, select API keys. You can view previously created keys or create a new one.

Create a private API key

Click Create Private API Key. Enter a name for the key. Under Select Access Level, choose Read-Only Key (read-only access for every API scope), then click Create.

Copy your private API key

On the confirmation screen, copy or download your private API key.

Authenticate in Two Minute Reports

Paste the API key into the Authenticate step in the TMR connection dialog. Click Test Connection.

When authentication succeeds, you will see your account name, ID, connection name, and status.

Enable accounts

Enable the toggle for each Klaviyo account you want to query. You cannot extract data from disabled accounts.

Click Refresh Connections so enabled accounts appear in the TMR sidebar.

You can now extract email marketing KPIs in Google Sheets for actionable campaign insights.

Step 4: Fetch Klaviyo data in Google Sheets

To pull specific campaign data, create a query in Data Queries:

1. Click Add and select the Klaviyo account(s) to analyze.
2. Choose metrics and dimensions that match your campaign goals.
3. Pick a date range for the period you want to track.
4. Configure sorting and filters to focus on the data that matters.
5. Click Run Query to load results into your sheet.

Manage multiple Klaviyo accounts

You can manage multiple Klaviyo client accounts in one place. Select one or more accounts when creating a query.

Alternatively, go to the Clients section: add a client, map their Klaviyo account(s), then click Save & Close so the mapping is available for future queries.

Once data is in Google Sheets, use pivot tables, VLOOKUP(), and charts to analyze and visualize email marketing performance.

Step 5 (Optional): Schedule automatic data refresh

Keep reports up to date and share them on a schedule:

• Scheduling auto-refresh in Google Sheets

Next steps

• Running queries
• Managing reports
• Google Sheets troubleshooting
• Understanding and resolving Klaviyo data discrepancies

To pull Klaviyo data into Looker Studio:

1. Click Open in Looker Studio, then click + Create Report.

2. A query config panel will appear. Do one of the following:

Already have a query config? Select it from the dropdown and skip to step 3.

Creating a new query config: Enter a name, select the accounts you want to include from the dropdown, then click Save.

3. Choose Create report from scratch to build a custom report, or select one of the pre-built templates to get started quickly.

4. In the Looker Studio connector panel, select your team and choose the required query config from the dropdown. Click Connect in the top-right corner.

5. You'll land on the Looker Studio dashboard. Drag and drop the available Klaviyo metrics and dimensions onto your canvas to start analyzing your data.