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

Currently a CSV and a JSON file is delivered. We are in the process of phasing out the CSV file delivery. Starting September 1st 2020, a single JSON file will be delivered using the the JSON schema described below. Please see the schema section to identify the different headers between the CSV and JSON files.

it is important to read this article in it's entirety as it contains important information related to schema and queries. Click here for information about the impressions export service. 

Setup

Please reach out to our support team via Live Chat or by emailing support@megaphone.fm to setup this service (typically takes 1-2 weeks). Data will only be pushed from the date of setup forward and does not include backfill. We recommend setting this up prior to going live on Megaphone.

Note that the impressions export service is included with the metrics export setup. 

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

CSV 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

JSON schema is as follows:

created_at,ip,episode_id,normalized_user_agent,user_agent,country,region,city,source,bytes_sent,filesize,id,podcast_id,seconds_downloaded,blacklisted_ip,blacklisted_ua

Calculating Metrics

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 (seconds_downloaded>=60).

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?