blog post

Explore your Spotify Ads KPI with PowerBi : How-to, templates and metrics

Florian Cabirol
January 29, 2024
Explore your Spotify Ads KPI with PowerBi : How-to, templates and metrics

Quick steps to create a Spotify Ads report with Google Sheets:

You can easiliy create a Spotify Ads report following this step :

  1. Get informations from the data integration from our Spotify Ads connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Spotify Ads data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Spotify Ads report with Looker Studio:

You can easiliy create a Spotify Ads report following this step :

  1. Get informations from the data integration from our Spotify Ads connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Spotify Ads at the end of the page.

The tutorial

Quick steps to create a Spotify Ads report with PowerBI:

You can easiliy create a Spotify Ads report following this step :

  1. Get informations from the data integration from our Spotify Ads connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Spotify Ads at the end of the page.

The tutorial

Unlock the full potential of your Spotify Ads marketing data by integrating it with PowerBI. In this tutorial, you'll learn how to seamlessly link your Spotify Ads account with PowerBI using Catchr. By the end, you'll be able to visualize and analyze your marketing data effectively, making data-driven decisions with ease.

How to Connect your Spotify Ads account to PowerBI

Add a source on Catchr

Navigate to the Catchr homepage and select 'Source' from the left menu, then click on 'Add a Source' located at the top right corner.

Pick the 'Spotify Ads' platform and follow the authorization process to establish a connection between Catchr and Spotify Ads.

Adding a source on Catchr

Create the request to transfer Spotify Ads data to PowerBI

  • Within Catchr, click on 'API' in the left menu.
API section on Catchr
  • First, change the export format to "PowerBI".
Export format selection for PowerBI
  • Under the "Source" tab, choose 'Spotify Ads' as the desired platform.
Source platform selection
  • Select the specific account and any accompanying KPIs you wish to extract data from. Multiple selections are allowed.
Account and KPI selection
  • Choose the metrics and dimensions for your data request. You can opt for several metrics and dimensions.
Metric and dimension selection
Additional metric and dimension selection
  • Remember, if you're using a predefined template from Catchr, ensure that all necessary dimensions and metrics are selected for the template to load your data automatically.
  • Select a time frame for your data extraction from Spotify Ads, which can be a custom or predefined period.
Time frame selection
  • Add filters to your request if required.
Filter addition
  • Adjust necessary options for your request, which vary by platform.
Options configuration
  • Once everything is set, an URL for the data request will be displayed. You can preview your data by clicking on "Preview" at the top right.
Data request URL and preview
  • Review the data preview, which will be available shortly after.
Data preview
  • If you're satisfied, copy the generated URL for use in the next steps of connecting to PowerBI.
Copy data request URL

Import the Spotify Ads data and KPI to PowerBI

PowerBI Desktop:

To import Spotify Ads data in PowerBI Desktop, initiate the process through 'Get Data' followed by 'Web'.

  • Stay in basic mode and paste the copied URL from Catchr.
Get Data option in PowerBI Desktop
Pasting the URL in PowerBI Desktop
  • Click 'OK'. It may take a few minutes for PowerBI to import your data.

After importing, you can refine your data using PowerBI Query and begin creating a dashboard. Once ready, publish and share your dashboard with colleagues or stakeholders.

PowerBI Web App:

To use a dataset in PowerBI Web App, first publish it from the PowerBI Desktop, then access it in the browser to create new reports.

Example of Metrics You Can Use with the PowerBI Integration for Spotify Ads

PowerBI's analytical prowess, used with Catchr's integrative features, dramatically expands the capabilities for visualizing and interpreting your Spotify Ads data. Here we illustrate conceivable applications, embracing a scope of Key Performance Indicators (KPIs) that can help you inspect advertising performance, user engagement, and budget allocation more deeply.

Imagine tracking your campaign success over time with metrics like 'Spend' and 'Impressions', or evaluating user engagement with 'Clicks' and 'Completion Rate'. By coupling these metrics with PowerBI's robust visualization tools, you can produce dynamic reports and dashboards that accurately reflect the impact and efficiency of your marketing initiatives on Spotify.

The flexibility of time-based metrics allows for trend analysis, a succinct way to observe changes and patterns. For example, using 'Year month day hour', one can pinpoint the peak times for user interaction, which might lead to strategic ad placement decisions.

Understanding the reasons behind ad rejections or issues using detailed data like 'Ad Set Reject Reason' and 'Ad Set Serving Issues' empowers marketers to take corrective actions and optimize their future campaigns.

For a closer look at the full range of Spotify Ads metrics available for PowerBI integration, visit the complete list on Catchr's Spotify Ads metrics page.

By completing this tutorial, you are now able to not only connect Spotify Ads data to PowerBI via Catchr but also use the insights garnered to fuel your marketing strategies and decisions. As always, ensure the accuracy, authoritativeness, and trustworthiness of your reporting for the most effective use of the data at hand.

No items found.

In this Spotify Ads template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this Spotify Ads template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Spotify Ads

Import your Spotify Ads marketing data to Google Sheets : How-to, metrics and more...

Unlock the full potential of your Spotify Ads data with our detailed guide on integrating it into Google Sheets via Catchr. This tutorial is tailored for marketing professionals looking to dive deep into their advertising metrics, offering a step-by-step process for data visualization and analysis. Learn how to connect your Spotify Ads account, select crucial metrics and dimensions, and create dynamic reports for real-time campaign monitoring and optimization. Ideal for those aiming to enhance their advertising strategies through insightful data analysis, ensuring every dollar spent is maximized for optimal campaign performance.

Florian Cabirol

Explore your Spotify Ads KPI with PowerBi : How-to, templates and metrics

Learn how to integrate your Spotify Ads marketing data with PowerBI using Catchr in this step-by-step tutorial. Unlock the full potential of your advertising data with effective visualization and analysis tools, enabling you to make informed, data-driven decisions for optimizing your Spotify Ads campaigns.

Florian Cabirol

Connect Spotify Ads to Looker Studio: How-to, templates and metrics

Integrate Spotify Ads and Looker Studio to unlock powerful data analysis and optimization for successful advertising campaigns.

Maxence PERRIN