Skip to main content

Hello, 

We export RevenueCat data to Metabase via a Webhook. We'd like to reproduce the main tables we have on RevenueCat to cross-reference them with our other collected user data, but we can't find the same data between our Metabase and RevenueCat tables. We've tried to follow the instructions on this article, but the names of the columns we have are different from those indicated on this article. Do you have more precise documentation that would enable us to reproduce your tables using the three tables provided below this email? 

Maybe it would be easier to do a visio to see it together?

Thanks a lot for your help,

Louis
 

 

Table 1 : RevenueCat Subscription Event : 
- ID
- Event ID
- Type
- App User ID
- Original App User ID
- Date 
- Store 
- Cancel Reason
- Expiration Reason
- Usd Price 
- Eur Price
- Price
- Currency
- Tax Percentage
- Comission Percentage
- Transaction ID
- Original Transaction ID
- Country Code
- Offer Code
- Device ID Attr
- Product ID


Table 2 : Revenuecat Subscription
- ID
- Subscriber ID
- Product ID
- Expires Date
- Purchase Date
- Original Purchase Date
- Ownership Type
- Period Type
- Store
- Is Sandbox
- Unsubscribe Detected At
- Bulling Issues Detected At
- Grace Period Expires Date
- Refunded At
- Auto Resume Date


Table 3 : Revenuecat Subscriber
- Entitlements → Premium Access → Expires Date    
- Entitlements → Premium Access → Grace Period Expires Date    
- Entitlements → Premium Access → Product Identifier    
- Entitlements → Premium Access → Product Plan Identifier    
- Entitlements → Premium Access → Purchase Date    
- Original App User ID    
- Device ID    
- App User ID    
- Device ID Attr    
- Email    
- Adjust ID    
- Original Application Version    
- Original Purchase Date    
- First Seen    
- Last Seen    
- Purchase Date    
- Expires Date


 

Hi @Louis,

I’ll have a look between our columns and the article and see if we can update it to the current state.

Thanks for letting us know!


Thanks for sharing this information!