Skip to content
Platform

Exporting Analytics Data

4 min readUpdated Nov 20263 steps

You can take your visitor figures out of the Platform and work with them in Excel, Google Sheets, Power BI or any other tool. This works for Podcatchers, the mobile website and the app.

Exports always follow what you have selected on the page: the period and any filters (tours, languages, devices) you set.

Every Insights page has an Export button at the top. Choose:

  • PNG image or JPEG image — for a presentation or an e-mail,
  • PDF document — for a report.

The export contains the charts and figures as you see them on the screen.

The tables at the bottom of the Insights pages Tours, Languages, Stops, Clips and Alarms have two download options:

OptionWhat you get
Export to ExcelAn .xlsx file with the table exactly as it is shown on the page
Source data (CSV)A .csv file with the detailed rows behind the table, per day

Use Export to Excel when you want the summary. Use Source data (CSV) when you want to build your own analysis.

Every file starts with these two columns:

  • Date — the day the row is about.
  • Granularity — Day for a single day. For a very long period (more than about 18 months), the full months in between come back as one row per month, dated the 1st, marked Month. Totals are the same either way.

The other columns depend on the page:

PageColumns
ToursTour, Device, Language, Tours
LanguagesLanguage, Device, Tour, Tours
StopsTour, Stop, Device, Language, Listens
ClipsTour, Stop, Clip, Device, Language, PlaybackPercentRange, ListenDepth, Plays
AlarmsTour, Device, Language, Alarms

Device is the device type, for example Podcatcher Pro, PWA (mobile website) or App.

The file is comma-separated and UTF-8 encoded, so names with accents open correctly in Excel.

The older Analytics view of the Platform has an Export tab that downloads one file with play counts per stop, per day.

  1. Open Analytics and click the Export tab.
  2. Set From date and To date in the filter panel on the right. The Example data table shows what the columns look like.
  3. Click Export. When the file is ready, it downloads automatically.

The file is named after your site and the period, for example SiteName-Analytics-20260101-20260131.csv. Very large exports (more than 500,000 rows) arrive as a .zip file with the CSV inside.

ColumnContents
TourNameThe name of the tour
DateThe day of the tour start (YYYY-MM-DD)
StopNameThe name of the stop
LanguageThe language code, for example nl-NL or en-EN
DeviceThe type of device, for example Podcatcher or PWA
NumberOfTimesListenedHow often the stop was played that day, including repeat plays

This file uses a semicolon (;) as separator. If all data ends up in one column, import the file in your spreadsheet program and choose the semicolon as delimiter, rather than opening it in a text editor.

ProblemSolution
All data appears in one columnImport the CSV and set the delimiter: comma for Insights files, semicolon for the older tour data export.
A tour is missingCheck that the tour was used in the period you selected, and that no tour, language or device filter excludes it.
Was this article helpful?