Receiving regular Bango Subscriptions API reports
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.
When you sign up to use the Bango Subscriptions API, Bango Support will supply you with:
|Active subscriptions||Daily, weekly, monthly||All active subscriptions at reporting time|
|New subscriptions||Daily, weekly, monthly||Subscriptions created during the reporting period|
|Canceled subscriptions||Daily, weekly, monthly||Subscriptions canceled during the reporting period|
|Renewed subscriptions||Daily, weekly, monthly||Subscriptions renewed during the reporting period|
All reports use UTC timestamps. Weeks start on Monday.
The "Canceled subscriptions" report contains cancellations that have taken effect, not scheduled future cancellations.
The reports are stored at:
Filenames have the format:
ASfor active subscriptions
NSfor new subscriptions
CSfor canceled subscriptions
RSfor renewed subscriptions
YYYYMM, for example
202008for August 2020
YYYYMMDD, for example
20200817for August 17, 2020
NS_V1_W_20200810.csvis the "new subscriptions" report for the week commencing August 10, 2020
AS_V1_M_202009.csvis the "active subscriptions" report for September 2020
All report files are Windows-1252 encoded and contain RFC 4180-compliant comma-separated values (CSV).
|String||The globally unique subscription ID|
|String||Any customer-specific subscription id supplied|
|Long/String||The unique Bango ID for the user|
|String||The merchant's unique identifier in the Bango Platform|
|String||The product associated with the subscription|
|String||The plan associated with the subscription|
|The current phase type of the subscription|
|The current billing period of the subscription|
|The current state of the subscription|
|YYYY-MM-DD string||UTC date on which the subscription starts or started|
|YYYY-MM-DD string or empty||UTC date on which the subscription was or will be canceled|
|YYYY-MM-DD string||UTC date up to which the subscription has been invoiced|
|YYYY-MM-DD string||UTC date on which billing starts or started|
|YYYY-MM-DD string||UTC date on which billing ends or ended|
|Integer||The default day of the month on which to bill users, for subscriptions where the a billing period is a multiple of one month|
|Float||The amount of the most recent successful payment|
|ISO 4217 three-letter currency code||The currency of the most recent successful payment|
|YYYY-MM-DD string||UTC date of the most recent successful payment|
|Float||The amount of the next payment|
|ISO 4217 three-letter currency code||The currency of the next payment|
|YYYY-MM-DD string||UTC date of the next payment|
|String||Format of the ExtensionData column|
|XML serialised to string||Any custom data associated with the subscription|