Skip to main content

Exporting Analytics Data

Required add-on: Analytics Dashboard

Analytics Dashboard data can leave the screen three ways: a CSV of one panel, a PDF of the whole screen, or a sheet in your Your Data spreadsheet.


CSV of One Panel

Export CSV sits beside the title of every Analytics Dashboard panel: Subscriber growth by tier (plus Export donations CSV when donations show), Tier breakdown, Revenue by tier, Tier movement, Feed engagement by tier, Downloads by tier, Feed health, Email engagement, Cohort retention, Migration funnel, and both boxes on the win-back page. A panel another add-on registers has no button.

The file holds what the panel shows: the same dates, the same Shows choice, and the same Tier where the panel applies it (growth, revenue, feed engagement and win-back).

  • Filename: {show}-{panel}-{from}-to-{to}.csv, with all-my-shows in place of the show under All my shows. Panels that show today’s state use today’s date instead of a range, and the win-back list is last-{n}-days-{today}.
  • Format: UTF-8 with a byte-order mark, so spreadsheets read accents correctly. Days are UTC and tiers are named.
  • Money is in each currency’s own decimals, beside its code, and is never added across currencies.
  • Text that starts with =, +, - or @ is escaped, so a spreadsheet won’t run it as a formula.

If Analytics Dashboard is off for the show, the button says Analytics Dashboard is not switched on for this show.

Feed health CSV

One row per show and UTC day of your dates, with the columns Show, Day, Feed (Valid, Invalid or Not checked), First problem, Problem code, Problems found, Episodes in the feed, Feed size (bytes), Sync runs, Failed sync runs and Checked at (UTC). A Not checked day has every figure empty, because there was no check to report. The two sync columns are empty for a show that doesn’t sync from an external feed.

Email engagement CSV

One row per email sent in your dates, episode notifications first, then broadcasts, with the columns Show, Kind of email (Episode notification or Broadcast), Email (the episode’s title or the broadcast’s subject), Sent at (UTC), Recipients, Opened, Opens, Open rate (%), Clicked, Clicks and Click-through rate (%). Opened and Clicked count recipients; Opens and Clicks count every open and click. A rate is empty for a send with no recipients. The file holds counts only and names no recipient. The button appears only where the box shows figures, not on the placeholder that stands in for it without the Email Editor.

The win-back list names people. Its file holds each listed person’s WordPress name and email. Keep it on your own machine, and treat it as personal data.

PDF of the Whole Screen

Export PDF, in the bar under the Analytics heading, downloads {show}-analytics-{from}-to-{to}.pdf: A4 pages under the same dates, Shows and Tier as the screen.

  • Header: the show’s name and artwork (for one show, and only when the artwork is an image in your media library), the dates as UTC days, and the tier when you chose one.
  • Body: each panel the screen shows, with its chart drawn: growth lines, tier breakdown with the Donations card, revenue (built-in membership only), tier movement, feed engagement bars, downloads with apps and the top 5 episodes, feed health, email engagement, cohort retention, and the migration funnel when there is one. Money is in each currency’s own decimals.
  • Feed health comes after downloads, as a table: per show, Days checked, Valid, Invalid and Not checked, plus Sync runs and Failed sync runs when any show in the report syncs from an external feed. Under it, each problem with its number of days and the last of them, and a note that Not checked is not a healthy day.
  • Email engagement comes after feed health, only where the Email Editor is on for a show in the report: one row per kind of email, with Sends, Recipients, Open rate, Open rate, previous period and Click-through rate, and the notes on Apple Mail’s inflated open rates and on time the Email Editor was switched off or its license had lapsed.
  • Footer: Powered by Benecaster · Made {UTC time} and Page n of m.

The charts are drawn on your server from the same data, so they are close equivalents rather than pictures of your screen. Making a PDF never fetches anything from the internet.

It needs the PHP extensions dom and mbstring. Without them the button says This server cannot make PDF files … Ask your host to turn them on.

Sheets in Your Data

Settings → Your Data gains five sheets, with the badge analytics-dashboard. See Exporting Your Data.

Sheet Holds Offered
Subscriber Growth Per day and tier Always
Tier Movement Counts per pair of tiers Always
Episode Downloads Top 100 episodes per day Only when a show tracks downloads
Feed Engagement As of today; the date range doesn’t apply Always
Cohort Retention The retention table, laid flat Only with 60 days of history

Every row starts with its show. Only shows where Analytics Dashboard is on are included, and archived shows are left out. All time starts at the show’s first recorded day. These sheets carry no subscriber identifiers, only counts. To see each individual tier change, use Benecaster’s own Subscription Events sheet.

For Developers

See Download an Analytics Dashboard panel as CSV or the screen as PDF.

See Also

Need this built rather than just documented? See our services →

Last updated