Daily Data Exports
Note
Daily Data Exports (aka ETL Exports) are available on "Expert" and "Enterprise" plans.
With Apphud you can export transaction data on a daily basis to your Cloud Storage Provider. Data is being uploaded as gzip compressed .csv file.
Data Format
| Column Name | Nullable? | Description |
|---|---|---|
id | No | Unique identifier for the event |
created_at | No | Date and time the event was created in Apphud |
updated_at | No | Date and time the event was last updated in Apphud |
event_name | No | Name of the event (e.g., trial_started) |
purchased_at | No | Date and time the purchase occurred |
expires_at | Yes | Expiration date for auto-renewable subscriptions |
cancelled_at | Yes | Date of refund |
original_transaction_id | No | Original Transaction ID (also known as the purchase token in the Play Store) |
transaction_id | No | Transaction ID (Order ID on Android) |
price_usd | No | Transaction price in USD |
price | No | Transaction price in the local currency |
proceeds_usd | No | Proceeds (revenue) amount in USD |
proceeds | No | Proceeds (revenue) amount in the local currency |
quantity | No | Quantity of items purchased (always 1) |
commission | No | Commission amount (0.30 or 0.15) |
product_id | No | Product identifier |
trial_period | No | Indicates whether the transaction is for a free trial |
intro_period | No | Indicates whether the transaction is within the introductory period |
is_upgraded | No | Indicates whether the subscription was upgraded (true/false) |
family_shared | No | Indicates if the transaction belongs to a family-shared subscription (is free) |
subscription_type | No | Type of subscription: auto-renewable or non-renewable |
environment | No | Environment of the transaction: production or sandbox |
user_id | No | Public user identifier |
internal_user_id | No | Internal user identifier |
currency | No | Currency code |
store_country | No | Purchase store country code (e.g., US) |
store | No | App store where the purchase was made (e.g., app_store or play_store) |
install_date | No | Latest app install date |
subscription_length | No | Length of the subscription period (e.g. 1W, 1M, 3M, etc.) |
trial_length | Yes | Length of the free trial period (e.g. 3D, 7D, 1W, etc.) |
Available Cloud Storage Providers
Updated 3 months ago