Reporting

Bango creates daily, weekly, and monthly reports and stores them in your own dedicated Amazon S3 bucket. You can use these reports for reconciliation purposes.

For resellers, reports are grouped by merchant. For merchants, reports are grouped by reseller.

Reports are published within 24 hours of the end of the reporting period.

Access control

When you sign up to use the Bango Subscriptions API, Bango Support will supply you with:

• Amazon S3 endpoint: all your reports will be stored here
• Access key: your unique username for accessing the S3 endpoint
• Secret key: your unique password for accessing the S3 endpoint

Report types

All reports use UTC timestamps. Weeks start on Monday.

The "Canceled subscriptions" report contains cancellations that have taken effect, not scheduled future cancellations.

Locations

The reports are stored at:

s3://{customer}/SubscriptionReports/{accountKey}/{frequency}/{yyyy}/{mm}/{dd}

Where:

• customer is your unique Amazon S3 bucket
• accountKey: for resellers, this is a merchant account key, as used when creating a subscription. For merchants, this is a partner account key
• frequency is either Daily, Weekly, or Monthly
• yyyy is the four-digit year of the start of the reporting period
• mm is the two-digit month (1-based) of the start of the reporting period
• dd is the two-digit day (1-based) of the start of the reporting period

Filenames

Filenames have the format:

{type}_V1_{frequency}_{date}.csv

Where:

• type is one of:
• ASfor active subscriptions
• NSfor new subscriptions
• CSfor canceled subscriptions
• RSfor renewed subscriptions
• frequency is one of:
• M for monthly
• W for weekly
• D for daily
• date is one of:
• For monthly reports: the reporting period expressed asYYYYMM, for example 202008 for August 2020
• For weekly or daily reports: the start of the reporting period expressed as YYYYMMDD, for example 20200817 for August 17, 2020

For example:

• The filename NS_V1_W_20200810.csv is the "new subscriptions" report for the week commencing August 10, 2020
• The filename AS_V1_M_202009.csv is the "active subscriptions" report for September 2020

File format

All report files are Windows-1252 encoded and contain RFC 4180-compliant comma-separated values (CSV).