Dashboard & Tools
Get help with charts, customer timelines, and anything related to the RevenueCat dashboard.
- 184 Posts
- 360 Replies
Why is the app_user_id column blank for the majority of users in my exported customer list?
I am trying to export a list of all customers with an promotional purchase however most (over half) of the users that are export do not have the app_user_id column set.I know for a fact that all these users have an app_user_id as this is used to grant their promotions. It also looks fine for the sample of most recently active users that display in the customer list on the website as they all display their app_user_id under the customers column.I have compared the list of most recently active from the website to what was exported and there are ids on the website that don’t appear in the export.Can anyone provide insight into why this columnmight not be populated for majority of my users on the customer list export? Any help is very much appreciated.
The number of active subscribers that Revenuecat gave us does not match the table we created
Hello,We want to create our own dashboards from the raw data that we received from Revenucat. We transfer the data to BigQuery about 1 day behind. When we group monthly active subscribers by month, we cannot match them with the data in the table that revenuecat provides us. Meanwhile, we find minor differences acceptable. Unfortunately the difference is too much.For example, while the number of active users in May is 1419 in our code, it is 1893 in the active subscriber chart of Revenucat. I am sharing the SQL code I wrote. The logic we have established here, in short, is this. We got price_in_usd > 0 to eliminate trial users so that data is not duplicated. We also set the sandbox area to false to avoid getting sandbox data. We thought that the original_store_transaction_id refreshes itself when creating the store transaction id with every purchase. That's why we thought that when we group and count the original_store_transaction_id by months, we can reach active subscribers. So wha
Stripe subscribers not showing in Active customers list
We have just imported about 5000 Stripe receipts. We can look up individual customers by their user id, but none of them show up in the Active customer list. Our import was very straightforward. We just imported the user id and the fetch_token (stripe receipt). Everything looks correct for each customer in terms of their subscription dates and spend, but they don’t appear to be recognized as active
Dasboard Recent Transactions shows the number of transactions more than it should be
Hi!, sometimes when I create a new sandbox account and make a purchase, the dashboard shows the number of transactions more than once. My appstore settings seem to be okey. Even though I purchased it once, the package seems to be renewed by itself. I only have this problem in apple, there is no such problem in android
An entitlement provided by subscription purchase doesn't override RC promotional entitlement
In our application we have a logic of a 3 days free use period, that we provide to the user by granting them Promotional Entitlements through RevenueCat API. During that period user can manually click the upgrade button to start a play store/app store subscription. We would expect that once the store subscription is purchased, promotional entitlements would be replaced with the ones from subscription. However this doesn’t happen, which causes some problems. For example, we can’t tell if user is currently using play store/app store 7 days subscription-trial (available once, after which they got billed automatically), because `entitlement.storeType` is always equal to `promotional` and `entitlement.periodType` is always equal to `normal`. Also all the entitlements have product indentifiers starting with `rc_promo`. Only after the promotional entitlement is expired, they get replaced with correct data from app store/play store. Currently as a workaround we manually revoke promotional ent
setAttributes don't show in Sandbox Dashboard, even after actions taken
I am successfully setting the user’s attributes in my RN app with setAttributes, however, they do not show in the dashboard. I’ve waited over 3+ hours at this point. I’ve put the app in the background, and quit/re-started, but they still do not show in the dashboard. I also invalidatePurchaserInfoCache in our dev environment. What is needed to get this to work?
Same app used for different users
Steps:User A logged in with App User Id A. User A make purchase and a transaction created against user Id A on revenue cat. User A logged out from the app. User B logged in to the same app with the User Id B. User B make purchase and a transaction created against user Id B, But User A’s transaction app user Id updated to B.My issue is I want both the transactions with separate App User Id and to updated with latest one.Where and What I am missing here? Is there any configuration I need to do?
RENEWAL webhooks sent every 5 minutes and automatically cancel
Hello and thanks for providing any insight. I am trying to setup a webhooks to my AWS dynamodb to store all events so I can keep them as a backup. I noticed that after resubscribing, multiple of the same webhook is being sent. The only thing that changes is the transaction_id. So in this case, I keep getting the same type “RENEWAL” webhooks every 5 or so minutes. Most recently I counted 7 webhooks including the last one which was type “CANCELLATION” before they stopped. Is there anything I missed? Is it because it is in a Sandbox environment that I get multiple renewal actions from Apple? All webhooks are getting the correct response code 200 and there is a green check mark next to them.
Number of renewals for Yearly plan happening each month
Hello, I’m trying to see the number of renewals for our Yearly plan happening each month but can't find this in the Charts section. When I look at our Yearly renewal revenue in a given month and divide it by the Yearly renewals in that month from the Subscription Retention chart, I see a subscription price that is much higher what it should be. This suggests that there are Yearly renewals happening each month that are not contained within the Subscription Retention chart. My guess is these are upgrades from our monthly plan or other non-standard renewals? Is it possible to see the all Yearly renewals happening each month in RevenueCat? Thanks!
How can I use filters for users with offer codes used in the In-App Purchases?
Hello Revenue-Cat Community, I’m looking to solve the following challenge:We created several different Offer-Codes for our In-App Purchases, which are used for different Sales Chanels, for ex. Influencers or Websites, etc. That is working great.How can I filter my Charts in Revenue Cat to see which OfferCode is used?I’m seeing the OfferCode used for the sale when tapping on the Transaction, but I can't find a way to filter for specific offer codes. Do you have any suggestion for that challenge?
Experiment with Free Trial shows no data
Hi, I have an experiment running with a product that uses a 7-day free trial that shows no data after running for 8-days. I had assumed the data would appear once trials begun converting. This doesn’t appear to be the case. Both products are being purchased and Trial Converted events are now being sent to my CDP and appearing in the RevenueCat ‘trial conversions’ graph.
Facebook - Revenucat Integration. Not seeing Purchase event
Hi, connected RevenueCat directly with Facebook SDK (previously used Appsflyer), to cut down project’s expenses. After relaunching my campaigns purchase event doesn’t show up in main dashboard. Purchase in my case if Trial Start. Went through the integration part a few times, everything seems to be ok. What am I missing? Where I should look at first?
MRR calculation with promotional offer
Hi, I’m wondering how my app's MRR is affected by purchases made using an iOS promotional offer.I have a subscription that I sell discounted for $17, which after one year renews into a $35 subscription.During the first year of the subscription - is my MRR increased with the subscription's full price ($35/12), or by the discounted amount ($17/12)?Is there any view where I can visualize (prove) how the MRR is increased from a purchase?
View revenue forecast based on active trials?
Hi thereI can see charts for our Active Trials and would like to see a future projected revenue forecast based on when those trials are due to convert.Even better if it accounts for our trial conversion rate based on product, but no problem if I need to guesstimate that myself.How might I do this?Tobin
How to report on crossgrading?
Hello,How can I report on % of users crossgrading?For context we have a product that has a monthly, quarterly and an annual subscription. I can report on monthly churn, but what I am not sure about is how to calculate how many of those monthly users have not really churned but moved to a a quarterly or annual subscription. Thank you!!!
Already have an account? Login
Log in to the Community
Authenticate with RevenueCat
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.