For Analytics Teams & Developers
Raw access to your podcast data for custom analysis, AI integration, and custom dashboards. Discover insights not possible with standard reports.
Example of a custom analytics dashboard built with our API.
Raw Data Access
CSV downloads and JSON API for all podcast metrics. Complete control over your data analysis.
AI & LLM Integration
MCP support for seamless integration with Claude, ChatGPT and other AI tools for automated insights.
Custom Analytics
Build custom dashboards, ML models and predictive analytics for deeper podcast insights.
Direct Database Access
Use SQL queries for custom analyses of your podcast data. Full access to all structured data tables.
Available Data Tables
Episodes
All episode metadata, publication dates, and performance metrics
Audience Metrics
Demographic data, geographic distribution, and listener behavior
Platform Data
Platform-specific metrics from Spotify, Apple Podcasts, and more
Time Series
Time-based data for trend analysis and historical comparisons
Example SQL Queries
-- Top 10 episodes by plays from Apple Podcasts data
SELECT
m.episode_id,
m.ep_name,
m.ep_collection_name,
m.ep_release_date,
SUM(d.aed_playscount) as total_plays
FROM openpodcast.appleEpisodeMetadata m
JOIN openpodcast.appleEpisodeDetails d
ON m.account_id = d.account_id AND m.episode_id = d.episode_id
GROUP BY m.episode_id, m.ep_name, m.ep_collection_name, m.ep_release_date
ORDER BY total_plays DESC
LIMIT 10;
Enterprise Database Access
Full SQL access to all podcast data available for analytics teams and developers.
Ready for Deeper Analysis?
Get full API access, CSV exports and MCP integration for your analytics projects.
Request Access Now