ETL Exports
Note
ETL Exports are available on "Expert" and "Enterprise" plans.
Export transaction data on 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 current 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.) |
Let me know if any further refinements are needed!
Available Cloud Storage Providers
Updated 14 days ago