The Activity table is a real-time activity feed of transactions being recorded for your apps. Each row represents a unique transaction. A transaction can be a trial start, trial conversion, renewal, or regular purchase.
For example, if user123 starts a trial then converts to a paid subscription they will have two rows in the Activity table.
|App User ID||The App User ID that recorded the transaction.|
|Product||The product identifier for the transaction.|
|Revenue||The estimated USD conversion of the transaction gross revenue.|
|Purchased||Fuzzy time when the transaction was recorded. It's possible for transactions to be recorded with a future timestamp since the stores may charge the user before a renewal date.|
|Expiration||Fuzzy time of the end of the transaction period. This does not mean the subscription is set to expire at the end of the period (it may still renew).|
|Renewal||Whether or not the transaction is an initial purchase or a renewal. This is not the auto-renew status of a transaction and doesn't indicate if it will renew or not at the end of the period.|
Finding Specific Transactions or Users
You can drill into a specific customer page by entering either a Store Transaction ID or App User ID into the search field. The search field only supports exact matches.
You can apply one or more filters to the Activity table to view a subset of transactions.
|App||Allows you to only show transactions from specific apps.|
|Is Renewal||Allows you to only show Renewal or Initial Purchase transactions.|
|Is Trial Period||Allows you to only show Free Trial or Paid Subscription transactions.|
|Product||Allows you to only show transactions for specific product identifier(s).|
|Store||Allows you to only show transactions for specific store(s). e.g.
Selecting Date Ranges
You can apply date restrictions to the Activity table to only show transactions that occurred within a certain date range. Note that it's possible for transactions to be recorded with a future timestamp since the stores may charge the user before a renewal date.
You can paginate through historical transactions by clicking the Older button. Clicking Most Recent button will reset the Activity table to the most recent transactions.
The sandbox data toggle will change the Activity table to show either sandbox or purchases. If you don't see any transaction data after making a test purchase, make sure you've enabled the 'View sandbox data' toggle.
Let us know how to improve!