Skip to main content
Question

Integrating RevenueCat Data into Internal Analytics Tool

  • October 20, 2025
  • 1 reply
  • 47 views
G
Forum|alt.badge.img

Hi RevenueCat team,

We’re currently using the RevenueCat scheduled data export and receiving the daily transactions table to our BigQuery project.
Our goal is to reproduce the Trial Conversion report (with additional refund metrics) in our internal BI tool, so that we can visualize cohort-based trial → conversion performance over time.

I’d like to confirm a few points and get your guidance on the best approach:

  1. How should we correctly identify Trial Started, Converted, Pending, Abandoned, refunds or cancellations so they align with the dashboard metrics in the RevenueCat UI?

  2. Are there any recommended SQL examples for reproducing the Trial Conversion chart logic using only the transactions export (without the customers export)?

Our goal is to use RevenueCat data within our internal analytics tool. We want to integrate the data we receive (such as the transactions export) into our existing reporting environment and monitor it from there.

Could you please guide us on the best way to do this?

Thank you for your help!
Best regards,

This post has been closed for comments

1 reply

jeffrey_bunn
RevenueCat Staff
Forum|alt.badge.img+6
  • jeffrey_bunn
  • RevenueCat Staff
  • October 23, 2025

Hi ​@gozde-keskin! For reference, information on the Trial Conversion chart can be found here. Importantly, this chart is cohorted by the earliest the customer was "first seen" (first opened your app), or made their first purchase.

In our calculations, if any customers identified in the cohorted period start a free trial, they contribute to the Trials column. Immediately after a trial is started, it is considered Pending as it has yet to convert but is set to. If the customer disables auto-renew, the trial is no longer Pending and is now considered Abandoned. If a user re-enables auto-renew, they will return to the Pending column. Once a trial has expired, it will be permanently counted in the Converted or Abandoned column depending on whether it converted to a paid subscription. 

This isn’t what you’re looking for, but we have a sample Trial Conversion Rate by Trial End Date query that might be somewhat helpful.

Lastly, it won’t be possible to exactly replicate this chart without joining the transaction data with customer data, as the Trial Conversion chart is fundamentally based on customers.

I hope this helps!
 

Terms & ConditionsCookie settingsAccessibility statement