Metrics export service

The metrics export service populates an organization's S3 bucket with their metrics from Megaphone.

File delivery

Once per hour, Megaphone will write a file using the following naming convention to the target S3 bucket, for the current day:

metrics-day-2019-01-22.csv.gz

The file will be overwritten throughout the day.

The file contains the metrics for the day (Zulu time zone) thus far.

From 0:00Z to 04:30Z, both the previous day's and current day's files will be written once per hour. By 04:30Z each day, the previous day's file is final and will not be overwritten again.

Data changes throughout the day

As the day proceeds and the metric file is overwritten:

- Metrics will not be removed
- Metrics will be added
- Fields within existing metrics may change, with their IDs remaining constant

Schema

Schema is as follows:

created_at,ip,referrer,episode_id,user_agent,full_user_agent,country,region,city,source,bytes_sent,filesize,metric_id,updated_at,geohash,via_episode_id,podcast_id,seconds_downloaded

seconds_downloaded was introduced to the schema in January 2019. For a metric to be reflected in Megaphone reporting, it must have seconds_downloaded >= 60. If you have dashboards that utilize exports and should match Megaphone reporting, you will need to add that constraint to your queries.

For any questions related to this service or to get your org setup, please reach out via Megaphone's Live Chat.

Did this answer your question?