Connect Spotify Ads to Power BI

Authorize Catchr with the Spotify user who can access the advertising business and ad account. In Catchr’s Power BI query builder, select daily campaign delivery before adding ad-set and ad detail and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping account, campaign grain and completed reporting dates clear in the model.

Catchr exposes campaign, ad set and ad reporting with impressions, spend, clicks, reach, frequency, starts and completes. Additional fields cover listening progress and music promotion outcomes where Spotify makes them available. Choose fields that apply to the campaign objective and format; a metric that is unavailable for an ad type should not be treated as zero performance.

Ad completes measure ads played to the end. Paid listens apply to eligible cost-per-completed-listen campaigns. Streams measure subsequent music listening associated with music promotion, rather than completion of the advertisement itself. Keep ad consumption and music outcomes in separate sections so a client can see both delivery and the response to the campaign.

The Conversion Rate field requested by Catchr is Spotify's listener conversion metric: it relates to people streaming the promoted content after ad exposure. It is not a website purchase rate. Do not label it as sales conversion or use it to calculate purchase ROAS. For website outcomes, add a separately configured analytics source such as Google Analytics and keep its attribution definition visible.

Compare the same account, campaign level, dates and metric definition first. Use daily rows for a selected-period report and check whether another chart is showing lifetime results. Recalculate CTR from total clicks and impressions instead of adding percentages, and do not sum daily reach as if every listener were different. Also check the Spend field's unit: a raw value expressed in micros must be divided by 1,000,000 before currency formatting. Verify it against an account export before applying that conversion.

Spotify's daily reporting API can include the current day, and Catchr requests the selected end date through the following midnight for daily reports. Today's figures can still change as delivery and reporting continue. Compare completed days for stable client reporting, and distinguish the dashboard's last refresh from the time Spotify last updated the underlying results.

Yes. Add Spotify Ads alongside Google Ads or Facebook Ads. Align date ranges and currencies, then compare delivery and cost metrics with matching definitions. Keep Spotify listening outcomes separate from website purchases, and avoid adding platform reach figures to claim a deduplicated audience across channels.