Hourly exports of your data is available as new-line delimited JSON files uploaded directly to your specified Amazon S3 bucket. There are three files exported to your bucket: in_app_purchases.jsonl, google_play_in_app_purchase_facts.jsonl and itunes_connect_in_app_purchase_facts.jsonl. Each file is gzipped.

Files will be stored in [Bucket] / [Optional Prefix] / [App Family ID] / [YYYY-MM-DDTH] / [File Name].

You can use this bucket to ingest the data with your ETL.

in_app_purchases.jsonl example

The in_app_purchases.jsonl export file contains the Mbaasy In App Purchase resource.

{"id":"4348f36e-1f05-4e87-a2df-9c1e857e1832","created_at":1517346062265,"updated_at":1517346062265,"marketplace":"google_play","app_family_id":"d9bd2455-e42e-4b1d-9418-3ad9b29d07c5","fact_id":"e5ba9a1e-1139-422b-8d52-99115b993ee4","product_id":"v6.1yr.30dtrial","quantity":1,"type":"subscription","environment":"production","purchased_at":1514754061523,"country_code":"US","currency_code":"USD","metadata":null,"user_identifier":"b91fe83a-254f-48ab-89ee-9af0bf7ab001","is_auto_renewing":true,"in_trial_period":false,"in_grace_period":false,"current_period_start_at":1514754061523,"current_period_end_at":1548889256239,"unique_identifier":"hbcigoedkilhdnjidaokbbld.AO-T_BMOZDi2ZzOp9RF75b2gwnULOUrInDRR_DDnJOdHryr8geKfXchAthzhqsd0MQI7kY39ssKhdFJgkBWmke_raGzRjRxOBDTwwVfMvub15Y_j3uiZ-6nCweZkp0excG4_53CWJPWWHVJhpOK8w","app_identifier":"com.mbaasy.demo"}{"id":"213ee5a9-2868-45d6-8dfc-aa1937967dc7","created_at":1517346085331,"updated_at":1517346085331,"marketplace":"google_play","app_family_id":"d9bd2455-e42e-4b1d-9418-3ad9b29d07c5","fact_id":"b8836021-22e8-4cb5-9c18-425e1b908262","product_id":"v6.1yr.30dtrial","quantity":1,"type":"subscription","environment":"production","purchased_at":1514837675588,"country_code":"US","currency_code":"USD","metadata":null,"user_identifier":"72115c8a-5fad-402a-b7a7-280d2041dc9e","is_auto_renewing":false,"in_trial_period":true,"in_grace_period":false,"current_period_start_at":1514837675588,"current_period_end_at":1517429662572,"unique_identifier":"anjodhlibbkdclekdbhgiiod.AO-Dz_RDPHGJBWnXdH4tu2aGnDhm_ngzDU_1hOCykwOpgcecpfsAuWKkCDZkK9wh7sR_O5OJWvILhjRZ8O-VTZgj0T8iFZ5pr3YezVwrxMfwBMKWR6sbdI3hr9MQrkebi_enU3Jx25RY7qd0BJwFO","app_identifier":"com.mbaasy.demo"}{"id":"5ab2992c-55fc-4a14-9a77-28e4c84fbffc","created_at":1517346123153,"updated_at":1517346123153,"marketplace":"google_play","app_family_id":"d9bd2455-e42e-4b1d-9418-3ad9b29d07c5","fact_id":"fbeb3237-b904-4d2e-bc05-bd4dde2b9f01","product_id":"v6.1yr.30dtrial","quantity":1,"type":"subscription","environment":"production","purchased_at":1514754143447,"country_code":"AR","currency_code":"USD","metadata":null,"user_identifier":"a6871c72-2159-4db3-b8bc-2b23a7699b65","is_auto_renewing":true,"in_trial_period":false,"in_grace_period":true,"current_period_start_at":1514754143447,"current_period_end_at":1517432522489,"unique_identifier":"bidillkoegjdhihodbbandck.AO-ph9nOQU3rhhK650isOz2wMCgIpM7maDd4xO3OqdsfMyuhDzgJT_x2rBWvOJi7eZkWRHLdwPFT_1_wFpfz_gD-9Z_K8kHbsGRnkGJ58RwkAeYIrBeeb3uVYJcCj5DOwcDZtBnKVURZn0rjXhWWR","app_identifier":"com.mbaasy.demo"}

google_play_in_app_purchase_facts.jsonl example

The google_play_in_app_purchase_facts.jsonl export file contains the raw purchase data retrieved from the Google Play API.

{"id":"3a52e947-f619-435f-aaf7-39fb3ede2ae2","created_at":1517346060854,"updated_at":1517346062246,"app_family_id":"d9bd2455-e42e-4b1d-9418-3ad9b29d07c5","purchase_token":"hbcigoedkilhdnjidaokbbld.AO-T_BMOZDi2ZzOp9RF75b2gwnULOUrInDRR_DDnJOdHryr8geKfXchAthzhqsd0MQI7kY39ssKhdFJgkBWmke_raGzRjRxOBDTwwVfMvub15Y_j3uiZ-6nCweZkp0excG4_53CWJPWWHVJhpOK8w","package_name":"com.mbaasy.demo","product_id":"1yr.30dtrial","linked_purchase_token":null,"order_id":"GPA.3322-9191-3273-49537..0","developer_payload":"","is_auto_renewing":true,"type":"subscription","environment":"production","payment_state":"received","cancel_reason":null,"consumption_state":null,"purchase_state":null,"started_at":1514754061523,"expires_at":1548889256239,"purchased_at":null,"user_cancelled_at":null,"price_amount_micros":60000000,"country_code":"US","price_currency_code":"USD","last_synced_at":1517346062236}{"id":"342911e7-f2d7-44b1-ac5f-fb02c280c19e","created_at":1517346084662,"updated_at":1517346085313,"app_family_id":"d9bd2455-e42e-4b1d-9418-3ad9b29d07c5","purchase_token":"anjodhlibbkdclekdbhgiiod.AO-Dz_RDPHGJBWnXdH4tu2aGnDhm_ngzDU_1hOCykwOpgcecpfsAuWKkCDZkK9wh7sR_O5OJWvILhjRZ8O-VTZgj0T8iFZ5pr3YezVwrxMfwBMKWR6sbdI3hr9MQrkebi_enU3Jx25RY7qd0BJwFO","package_name":"com.mbaasy.demo","product_id":"1yr.30dtrial","linked_purchase_token":null,"order_id":"GPA.3391-2424-8426-94670","developer_payload":"","is_auto_renewing":false,"type":"subscription","environment":"production","payment_state":"trial","cancel_reason":"developer","consumption_state":null,"purchase_state":null,"started_at":1514837675588,"expires_at":1517429662572,"purchased_at":null,"user_cancelled_at":null,"price_amount_micros":60000000,"country_code":"US","price_currency_code":"USD","last_synced_at":1517346085303}{"id":"9a7c70ed-02d7-45f9-9bfe-a235e69d49f9","created_at":1517346122253,"updated_at":1517346123134,"app_family_id":"d9bd2455-e42e-4b1d-9418-3ad9b29d07c5","purchase_token":"bidillkoegjdhihodbbandck.AO-ph9nOQU3rhhK650isOz2wMCgIpM7maDd4xO3OqdsfMyuhDzgJT_x2rBWvOJi7eZkWRHLdwPFT_1_wFpfz_gD-9Z_K8kHbsGRnkGJ58RwkAeYIrBeeb3uVYJcCj5DOwcDZtBnKVURZn0rjXhWWR","package_name":"com.mbaasy.demo","product_id":"1yr.30dtrial","linked_purchase_token":null,"order_id":"GPA.3389-5965-4500-74343..0","developer_payload":"","is_auto_renewing":true,"type":"subscription","environment":"production","payment_state":"pending","cancel_reason":null,"consumption_state":null,"purchase_state":null,"started_at":1514754143447,"expires_at":1517432522489,"purchased_at":null,"user_cancelled_at":null,"price_amount_micros":60000000,"country_code":"AR","price_currency_code":"USD","last_synced_at":1517346123125}

itunes_connect_in_app_purchase_facts.jsonl example

The itunes_connect_in_app_purchase_facts.jsonl export file contains the raw purchase data retrieved from the iTunes Connect API.

{"id":"09346853-af5b-4982-a567-aaca487c5285","created_at":1517346139569,"updated_at":1517346139933,"app_family_id":"d9bd2455-e42e-4b1d-9418-3ad9b29d07c5","bundle_id":"com.mbaasy.demo","product_id":"1yr.14dtrial","auto_renew_product_id":null,"transaction_id":304078030854011,"original_transaction_id":304078030854011,"web_order_line_item_id":380000046266491,"quantity":1,"purchased_at":1517346134000,"originally_purchased_at":1517346134000,"expires_at":1518555734000,"canceled_at":null,"auto_renew_status":null,"cancellation_reason":null,"expiration_intent":null,"price_consent_status":null,"in_intro_offer_period":false,"in_trial_period":true,"in_billing_retry_period":null,"last_synced_at":1517346139922,"environment":"production","type":"subscription"}{"id":"02fd4359-cd0d-4169-a84e-65a5bd533d22","created_at":1517346179928,"updated_at":1517346180215,"app_family_id":"d9bd2455-e42e-4b1d-9418-3ad9b29d07c5","bundle_id":"com.mbaasy.demo","product_id":"1yr.14dtrial","auto_renew_product_id":null,"transaction_id":708870014034350,"original_transaction_id":708870014036543,"web_order_line_item_id":282000058045084,"quantity":1,"purchased_at":1517346169000,"originally_purchased_at":1515659770000,"expires_at":1548882169000,"canceled_at":null,"auto_renew_status":null,"cancellation_reason":null,"expiration_intent":null,"price_consent_status":null,"in_intro_offer_period":false,"in_trial_period":false,"in_billing_retry_period":null,"last_synced_at":1517346180203,"environment":"production","type":"subscription"}{"id":"c1bc2f0c-cf87-43db-9dcf-4efc9de75457","created_at":1517346189104,"updated_at":1517346189452,"app_family_id":"d9bd2455-e42e-4b1d-9418-3ad9b29d07c5","bundle_id":"com.mbaasy.demo","product_id":"1yr.14dtrial","auto_renew_product_id":null,"transaction_id":744308053800110,"original_transaction_id":744308053800110,"web_order_line_item_id":190000084915833,"quantity":1,"purchased_at":1517346185000,"originally_purchased_at":1517346186000,"expires_at":1518555785000,"canceled_at":null,"auto_renew_status":null,"cancellation_reason":null,"expiration_intent":null,"price_consent_status":null,"in_intro_offer_period":false,"in_trial_period":true,"in_billing_retry_period":null,"last_synced_at":1517346189440,"environment":"production","type":"subscription"}

Get started now

  • Yes No credit card required
  • Yes 2,500 free events / month

Frequently Asked Questions