blog post

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

Florian Cabirol
January 31, 2024
Import your Spotify Ads marketing data to Google Sheets : How-to, metrics and more...

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

This guide is designed to empower marketing professionals to seamlessly integrate their Spotify Ads data into Google Sheets using Catchr. By the end of this tutorial, you’ll be able to effortlessly visualize and analyze your advertising efforts, enabling more informed decision-making and strategy optimization.

How to Connect Your Spotify Ads Account to Google Sheets

Add a Source on Catchr

To start, navigate to the Catchr homepage. From there, select 'Source' in the left menu and click on 'Add a Source' at the top right corner. Choose Spotify Ads as your platform and proceed with the necessary identification steps to establish a connection between Catchr and Spotify Ads.

Adding a source on Catchr

Create a New Query

Open Google Sheets, locate "Catchr" in the menu, and select "New Query". This initiates the process of creating a new query to transfer your Spotify Ads data.

Select Your Data Source

In the query interface, select Spotify Ads as your desired source. If Spotify Ads isn't listed, you can easily add it by clicking on the "+" icon.

Selecting your data source

Select Your Account(s)

Head over to the "Select account(s)" section and pick the Spotify Ads account(s) you wish to pull data from.

Selecting your accounts

Choose Metrics and Dimensions

In the "Metrics" and "Dimensions" sections, pinpoint the specific data points you'd like to add to your query. Here are some examples of metrics and dimensions available for Spotify Ads:

Metrics:

  • Advertiser Id: Identifies the advertiser.
  • Spend: The total budget spent on campaigns.
  • Impressions: The number of times ads were displayed.
Choosing Metrics

Dimensions:

  • Country: Visitor's country.
  • Ad Set name: Name of the Ad Set.
  • Campaign Status: The current status of the campaign.
Choosing Dimensions

Ensure you select metrics and dimensions that match your analysis and reporting goals.

Set Date Range

Move to the "Date Range" tab to set your data’s timeframe. Catchr allows you to choose from preset ranges like "Last month" or "This year", or define your custom start and end dates.

Setting Date Range

Apply Filters

To further refine your data, use filters in the "Filters" tab by entering these fields:

  • Field: Advertiser Id
  • Operator: Equals
  • Value: Your specific advertiser ID
Applying Filters

Schedule & Customize Data Refreshness

Finally, visit the "Options" tab to set up automatic data refreshes for your query. Here, you can also engage features like "Appends rows" for adding new data or "Combine rows" for updating existing rows.

Scheduling Data Refresh

By following these steps, you’ll effortlessly integrate Spotify Ads data into Google Sheets, opening up a plethora of analytics possibilities.

Example of Google Sheets You Can Create to Use with Spotify Ads Source

By integrating Spotify Ads data into Google Sheets with Catchr, marketing professionals can develop robust sheets for comprehensive analysis and visualization. Here are a few examples of how you can leverage this data:

Campaign Performance Dashboard: Create a live dashboard that tracks key performance indicators (KPIs) like Spend, Impressions, Clicks, and Completion Rate over time. Use conditional formatting and charts to identify trends and make adjustments to your campaigns in real-time.

Audience Insights: Combine Spend and Impressions data with Dimensions like Country or Ad Set name to glimpse into your audience's behavior and preferences. Tailoring your ads based on these insights can significantly enhance campaign effectiveness.

Budget Tracking: Construct a sheet that closely monitors campaign spend against the budget. This enables quick adjustments to ensure optimal allocation of resources across campaigns.

Ad Creative Analysis: Evaluate which creatives are performing best based on metrics like Clicks, CTR, and Completion Rate. This analysis can inform future creative directions and optimize campaign outcomes.

With Catchr’s integration, the possibilities for in-depth campaign analysis and optimized decision-making become limitless. By tapping into this powerful data, you can craft strategies that significantly amplify your Spotify Ads results.

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