Data Export Version 4
Scheduled data exports are available to all users signed up after September '23, the legacy Grow and Pro plans, and Enterprise plans. If you're on a legacy Free or Starter plan and want to access this integration, migrate to our new pricing via your billing settings.
Version 4 Change Log
Data format improvements
Please ensure that your data ingestion pipeline is setup to handle these format changes before updating to Version 4.
- Boolean fields such as
is_trial_conversionhave previously been provided with the stringstandfto represent true and false, but they will now be delivered as true boolean fields withtrueorfalseas the set values. - Fields containing arrays or JSON objects (
reserved_subscriber_attributes,custom_subscriber_attributes, andentitlement_identifiers) will have the values within each key/value pair enclosed in quotes to prevent issues when ingesting the data. - Last, for standardization, fields containing arrays (only
entitlement_identifiers) have also been updated to contain the array within square brackets ([and]) instead of curly brackets ({and}). Fields containing JSON objects (reserved_subscriber_attributesandcustom_subscriber_attributes) will continue to use curly brackets
The data table below contains sample values for each field to help ensure your pipeline is setup correctly.
Newly added fields
Measuring gross revenue
When a transaction is refunded, the current price_in_usd and price_in_purchased_currency fields will be set to 0 while refunded_at is set to mark the time of the refund.
To instead equip you to measure gross revenue before refunds, we've introduced new purchase_price_in_usd and purchase_price_in_purchased_currency fields which will remain set at the original purchase price even after a refund.
By sourcing your analysis' with these fields, you'll be able to measure gross revenue before refunds.
Country fields
country has been updated to equal the store country of a given transaction when it is known, and to fall back to an IP-based estimated country when it is not known.
- The store country of a transaction is the most accurate way to group a subscription by country because it dictates the price of the subscription, the available offers, how price changes will be handled, etc.
- Update to iOS SDK version 3.14 and up to ensure store country can be captured by RevenueCat.
country_source has been added to distinguish between country values that represent the store country of a transaction (from_sdk), and those that have been set through an IP-based estimate (estimated).
Product dimensions
product_duration represents the standard duration of a subscription product, set using ISO 8601 values (e.g. P1M for a 1 month subscription, P1Y for a 1 year subscription, etc).
- Trial period or introductory period lengths are not reported through this field. Therefore, when either
is_trial_periodoris_in_intro_offer_periodaretrue, theproduct_durationdoes not represent the duration of that specific transaction. It represents the standard duration of the underlying product that has been subscribed to. - There may be products where RevenueCat does not authoritatively know the standard duration, such as Stripe products which may have multiple prices (and therefore durations) associated with them. In these cases,
product_durationwill be null.- In our data features, we handle these cases by estimating product duration.
product_display_name represents the display name that may be set for a product in the RevenueCat Dashboard.
- Setting a display name may be especially useful for products on stores like Stripe where the
product_identifieris not easily interpretable.
Experiment fields
experiment_id represents the UUID of a RevenueCat Experiment that the associated App User ID was enrolled in.
experiment_variant represents the variant of the experiment that the associated App User ID was assigned to.
Change tracking
updated_at represents the last time an attribute of the transaction was modified (e.g. after a subscriber disables their auto-renewal and a cancellation_date is set). This can be used to more easily capture changes to individual transactions between exports.
Full export format
All dates and times are provided in UTC.
| Header | Description | Type | Example Value | Can be Null |
|---|---|---|---|---|
rc_original_app_user_id | Can be used as a unique user identifier to find all of a user's transactions. | string | $RCAnonymousID:87c6049c58069238dce29853916d624c | |
rc_last_seen_app_user_id_alias | Can be used together with rc_original_app_user_id to match transactions with user identifiers in your systems. | string | $RCAnonymousID:87c6049c58069238dce29853916d624c | |
country | Store country of a transaction when known, or an IP-based estimate of a subscriber's country when not known. | string | GB | ✅ |
country_source* | from_sdk when the store country of a transaction is known, or estimated when country is sourced from an IP-based estimate. | string | from_sdk | ✅ |
product_identifier | The product identifier that was purchased. | string | rc_subscription_monthly | |
product_display_name* | The display name of the product identifier if one has been set. | string | Monthly $9.99 | ✅ |
product_duration* | The standard duration of the product if one is known by RevenueCat. May be null if RevenueCat does not know the authoritative duration. | string | P1M | ✅ |
start_time | Purchase time of transaction. | datetime | 2023-01-01 08:27:06 | |
end_time | Expected expiration time of subscription. Null when is_auto_renewable = false. For Google Play, end_time can be before start_time to indicate an invalid transaction (e.g. billing issue). | datetime | 2023-02-01 08:27:06 | ✅ |
grace_period_end_time | Expiration time of a grace period (if applicable) for a subscription. Will remain set while a subscription is in its grace period, or if it exited its grace period without renewing. Null when a subscription is not in a grace period or expiration was not due to a grace period. | datetime | 2023-02-17 08:27:06 | ✅ |
effective_end_time | Single reference point of a subscriber’s expiration and entitlement revocation; inclusive of each store’s logic for refunds, grace periods, etc. | datetime | 2023-02-17 08:27:06 | ✅ |
store | The source of the transaction. Can be app_store, play_store, stripe, or promotional. | string | play_store | |
is_auto_renewable | true for auto-renewable subscriptions, false otherwise. | boolean | true | |
is_trial_period | true if the transaction was a trial. | boolean | false | |
is_in_intro_offer_period | true if the transaction is in an introductory offer period. | boolean | false | |
is_sandbox | true for transactions made in a sandbox environment. | boolean | false | |
price_in_usd | The revenue (converted to USD) generated from the transaction after accounting for full and partial refunds. Can be null if product prices haven't been collected from the user's device. | float | 0 | ✅ |
purchase_price_in_usd* | The gross revenue (converted to USD) generated from the transaction. Remains set for refunded transactions. Can be null if product prices haven't been collected from the user's device. | float | 9.99 | ✅ |
takehome_percentage | [DEPRECATED] The estimated percentage of the transaction price that will be paid out to developers after commissions, but before VAT and DST taxes are taken into account. (will be either 0.7 or 0.85). We recommend using tax_percentage and commission_percentage to calculate proceeds instead. Learn more here. | float | 0.7 | |
tax_percentage | The portion of a transaction’s price that will be deducted by the store for taxes. VAT & Digital Services Taxes may be withheld by stores depending on the store and country. To learn more about how RevenueCat estimates taxes, click here. | float | 0.1442 | |
commission_percentage | The portion of a transaction’s price that will be detected by the store for commission. In stores where taxes are deducted before commission, this value will not equal the published commission from a store, because that commission is calculated on the post-tax revenue. | float | 0.15 | |
store_transaction_id | orderId or transaction_identifier. | string | 123456789012345 | |
original_store_transaction_id | orderId of first purchase or original_transaction_id. Can be used to find all related transactions for a single subscription. | string | 011223344556677 | |
refunded_at | When a refund was detected, null if none was detected. Is not set in the case of upgraded transactions for which the App Store issues a partial refund. | datetime | 2023-02-20 05:47:55 | ✅ |
unsubscribe_detected_at | When we detected an unsubscribe (opt-out of auto renew). | datetime | 2023-02-16 14:17:10 | ✅ |
billing_issues_detected_at | When we detected billing issues, null if none was detected. | datetime | 2023-02-01 08:27:15 | ✅ |
purchased_currency | The currency that was used for the transaction. | string | GBP | ✅ |
price_in_purchased_currency | The revenue (in the purchased currency) generated from the transaction after accounting for full and partial refunds. Can be null if product prices haven't been collected from the user's device. | float | 0 | ✅ |
purchase_price_in_purchased_currency* | The gross revenue (in the purchased currency) generated from the transaction. Remains set for refunded transactions. Can be null if product prices haven't been collected from the user's device. | float | 3.99 | ✅ |
entitlement_identifiers | An array of entitlements that the transaction unlocked or null if it didn't unlock any entitlements. | string array | ["membership", "full_access"] | ✅ |
renewal_number | Always starts at 1. Trial conversions are counted as renewals. is_trial_conversion is used to signify whether a transaction was a trial conversion. | integer | 2 | |
is_trial_conversion | If true, this transaction is a trial conversion. | boolean | true | |
presented_offering | The offering presented to users. | string | Default Offering | ✅ |
ownership_type | Will be PURCHASED when a recorded transaction results from the subscriber’s direct purchase of it, or FAMILY_SHARED when a recorded transaction results from the subscriber having received it through Family Sharing. NOTE: The FAMILY_SHARED designation is only supported on App Store transactions. | string | PURCHASED | ✅ |
reserved_subscriber_attributes | The reserved attributes set for the Customer (subscriber). Keys begin with $. | string JSON | "{\"$ip\": {"value": \"203.78.120.117\", \"updated_at_ms\": 1672549200}, \"$gpsAdId\": {\"value\": \"80480bdc-06e0-11ee-be56-0242ac120002\", \"updated_at_ms\": 1672549200}, \"$androidId\": {\"value\": \"12345a9876b4c123\", \"updated_at_ms\": 1673097132390}}" | ✅ |
custom_subscriber_attributes | The custom attributes set for the Customer (subscriber). | string JSON | "{\"feature_setting\": {"value": \"1\", \"updated_at_ms\": 1672549200}, \"survey_response\": {"value": \"2\", \"updated_at_ms\": 1599112814785}}" | ✅ |
platform | Last seen platform of the subscriber. | string | android | ✅ |
experiment_id* | The unique ID of the Experiment that the subscriber is or was enrolled in. Will be null if the subscriber has not been enrolled in an experiment. Learn more about Experiments here. | string | prexp3a8a234abc | ✅ |
experiment_variant* | The value of the Experiment variant that the subscriber is or was enrolled in. a represents the Control, and b represents the Treatment. Will be null if the subscriber has not been enrolled in an experiment. Learn more about Experiments here. | string | a | ✅ |
updated_at* | The last time an attribute of the transaction was modified. | datetime | 2023-02-20 05:47:55 |
*Newly added fields for Version 4
To learn more about how to use our transaction data, or get started with sample queries, click here.