Adding a data source is an essential step to creating a report in Looker Studio. This article will guide you through the process of adding Klaviyo as a source.
The first step is to generate an API key from Klaviyo. This key is used to configure the data source in Two Minute Reports (TMR) configuration. Once the data source is added, you can create a new query config using the data source and build a Klaviyo report from scratch in Looker Studio.
With the data source in place, the report creation process is streamlined. This allows you to easily reduce your time creating reports.
Select Klaviyo in the TMR Portal
The first thing to do is to go through our portal and select the data source you want to add.
- Go to apps.gox.ai and Login to your account.
- Choose Two Minute Reports for Looker Studio (the blue one).
- Select your team. If you only have one team, you skip this and TMR automatically redirects you to the connectors page.
You will now see the connectors page.
- In the connectors page, find and select Klaviyo.
Generate an API Key from Klaviyo
It’s required for Klaviyo to enter an API key to connect to Two Minute Reports. The API key provided by Klaviyo is then entered in Two Minute Reports interface later on. Getting your connection details from Klaviyo is easy.
What is an API key?
- Go to your Klaviyo Dashboard and select the profile option below. Once you click that select the Settings option.
- Now, choose the API Keys option placed in the top bar of the dashboard.
- You will be able to view the previously created API keys, and you will have an option to Create a Private API Key. Select the corresponding option.
- Now, create a Private API Key Name for your new API Key and select the Access Level. For Two Minute Reports, you need to specify the Access level to Full Access Key and click Create, placed at the top right corner.
- After creating the API Key, click the Copy Key button next to the API Key you just created. You can then paste the key into your Two Minute Reports configuration. Store and note your Private Key safely as you need it later.
Authorize Your Klaviyo Account
The next series of steps is to configure your Klaviyo account with TMR.
Connect to Your Klaviyo Account
In this section, you need to login to your App Store account for authentication making sure it connects with TMR and Looker Studio.
- Under Data Sources, click +Add New button.
- Name your data source.
- Enter the API Key you acquired from the previous section.
- Click the blue Test Connection button.
- If successful, Two Minute Reports gives a prompt “Signed in! You may close this tab now.“
Configuring Your Klaviyo Account with TMR
- In the Query Configs section, click + Add New button. Choose the data source you added earlier. Click Next.
The next following steps is where you configure your App Store settings to TMR so that you can create reports in Looker Studio. You may configure the following parameters depending on your preference as TMR has imported them.
- Name your query config.
- Select your preferred Report Configuration.
- Select the appropriate Reporting Timezone.
- Data Options whether you want to Include missing time values or Replace blank metrics with zeros. This means metrics are still being reported as zero values.
- Click Save.
Once everything is finished, click Create Report. The next section is creating reports in Looker Studio.
Create a Klaviyo Report with TMR in Looker Studio
After connecting Klaviyo, you can create your own custom dashboard with TMR in Looker Studio. Looker Studio is a powerful data visualization tool that contains many features to help you reduce time creating reports.
- After clicking Create Report from the previous section, click blue Create Report from scratch button.
- You are redirected to Looker Studio. In Looker Studio, under Select Query Config, choose the configuration you created earlier (it should be the name you gave it). Under Select your Team, choose the appropriate team as well if the dropdown is showed to you.
- Click the blue Connect button in the upper right side of the page.
- You can now view the Firebase schema on Looker Studio. Click Create Report in the right side of the page.
Once everything is loaded, you are presented with a blank canvas. You can now create custom reports (adding dates and charts) in Looker Studio with your Firebase data.
If you want to learn about creating your own report, like adding dates and charts, read How to Create a Report in Looker Studio.
If you also want to learn the discrepancies of Klaviyo with TMR, read Understanding and Resolving Discrepancies in Klaviyo Data with Two Minute Reports.