Dashboard & Tools
Get help with charts, customer timelines, and anything related to the RevenueCat dashboard.
- 198 Posts
- 392 Replies
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
Why is the conversion to paying chart incorrect? Data lag/cohorts?
I’m testing my live purchases in the App Store before public announcement of the product. I’m probably misunderstanding but “Conversion to paying” chart shows zero conversion, even though I installed the app and paid for a real subscription myself yesterday. The subscription shows up correctly, but it shows zero conversions. Why?
Searching a user by email on the web console does not work
Hello,We are currently testing RevenueCat.On iOS, we are setting the user email with:Purchases.shared.setEmail(email)It works as intended:[Purchases] - DEBUG: 😻 Subscriber attributes synced successfully for App User ID: ZDOuNi1VLxWfXSJtdrO6eMbYe3H2On the customer profile we can see that the email attribute has been set correctly:https://app.revenuecat.com/customers/...But searching the user by email on the web console does not work (we checked several times for typos).Searching by user id works as intended.Thank you for your help.
"Trial Cancellation Date" in lists applies to cancelled subscriptions
It appears the "Trial cancellation date" filter also applies if a user has cancelled a subscription? For example we have the following filters to show users in the last X amount of days who have started and cancelled a trial. But going through the list there are 3 active subscribers and it looks like each of them... 1. Start a trial2. Let their trial convert into a subscription3. Cancel the subscription but it has not expired
Double "New Customers" since July 15
Hi, I released a new version of my apps on July 14. Since July 15, RC is reporting double the new users (500 - 600), but the play console and apple connect is showing the same average users I get this days (200 - 300), I don’t know from where is RC reporting double. I did not change anything in my app logic or upgraded the sdk.
Revenue Report in Android in Regards to User Taxes
The revenue amount reported by RevenueCat did not equal the amount I expect, so I want to update my mental model. What am I missing? I’ve set the price to 24.99 USD. The Mr. Google set the price across the globe accordingly. The list price in Germany is 28.99 EUR including 19% VAT. So the price shown to user is 28.99 EUR. The 5.51 is deducted as a VAT. Then there was a purchase. List Price: OK Tax: 4.63… Weird, that it’s not 5.51 as stated about, but… Okay. Estimated Revenue: OK. This is how what I expect to get after setting the price to 24.99 USD and deducting 15% Google’s share. It’s not exactly 85%, and I guess that’s because of conversions from USD to EUR. Bacause this is fine: What looks really, really out of scope is this: I’m seeing a List Price with the User’s country tax. And the revenue which is reported by Revenue Cat for this transaction is this: 24.714 USD.(I’ve double checked the receipt id, it is the proper transaction). The questionsIs that the List Price I’m seeing i
A/B Experiments - why are we seeing an uneven distribution?
We have enabled a/b experiments and are testing what experiment performs best. We also have analytics around what SKUs users are seeing. We’ve noticed that our default variant is seen 70% of the time and variant B 30%. It’s hard to tell if this is a RevenueCat issue or whether our users are that skewed in terms of who is looking at the paywall. Any ideas on why we would see such an uneven distribution?
How long does it take for chart data to populate after first launching?
Hello!We just launched an update of our app yesterday that uses RevenueCat to manage subscription IAPs. I can see some of the summary information at the top of the dashboard display how many active trials there currently are, along with a revenue summary, etc. But when I click through to view any of the charts, all the data is still empty. I understand that some charts are delayed by 7 days, like the trial start chart, but all the other charts are empty too. I’m also able to see the recent transactions coming in at the summary list at the bottom of the dashboard.Looking at the Charts guide (https://docs.revenuecat.com/docs/charts#monthly-recurring-revenue), it seems like most of the data should populate right away:“All charts are generated from the current snapshot of purchase receipts saved in RevenueCat and work independently from any in-app usage. This means that your charts are always up-to-date, without having to rely on any client-side event logging.”So just wanted to confirm if
Webhook/Segment Integration: Proceeds Calculation includes Tax
Hi,Is there any way to define how RevenueCat reports developer proceeds for the Webhook/Segement integration to account for local taxes?Currently you can choose the ‘report proceeds’ option within the Segment Integration settings, but the calculation doesn’t reflect ‘Developer Proceeds’ as defined by Apple. The calculation by Apple removes local taxes from the ‘customer price’ prior to applying the take home percentage. (GROSS_REVENUE - TAX) * TAKEHOME_PC.For the Segment integration, the calculation for revenue seems to apply the `takehome_percentage` property to the `price` property (which is only actually shown in the web hook output and not shown on the Segment event) – it doesn’t account for taxes at all. CUSTOMER_PRICE * TAKEHOME_PC.For the web hook, we’re only given the customer price converted to USD – no option for developer proceeds at all. I’m sure the local currency complicates it, but it would be good if we could get the price in local currency AFTER tax.Ideally we’d have:
How to calculate churn from the transaction data in S3?
The documentation includes sample queries for revenue, active trials, and active subscriptions but there are no sample query for churn. How to determine churn as shown in charts? And how to determine the active subscriptions per day that shows a deduction when a user unsubscribes?
Table of Revenue or Transactions per month per user
Hi There, We are just starting on our RevenueCat journey, so far I have integrated RC with our App and the revenue is starting to roll in, so far so good.Our Business Model demands that we split the Revenue between different Content Creators depending on the location of our Users, this is easy for other countries, but gets pretty fine grained in our own country since we are splitting according to states (cantons in Switzerland). So I have added an attribute to our Users defining the Region they live in.Since we have a monthly payroll for our content creators, I need a chart that tells me which user has spent how much in say the month of July and where they are situated.I can create a customer list putting the most recent purchase between 7.1 and 7.31 but i only see the total amount spent and have no way of knowing how much the User has spent within this time frame.Is there a way to get this data in one table? Is this perhaps something I should use a 3rd party integration for? Also on a
Experiment test group in Amplitude?
When running an experiment https://docs.revenuecat.com/docs/experiments I can go into a user page and under “Current offering” see in what test group this user is. Could this data be shared to amplitude as well? So that I in amplitude can know what test group a user is in?
Data for the experiment is not available for almost 3 weeks
Hi,I started my experiment on January 20. Both variants have successfully converted users from 3-day trials. However, after almost 3 weeks (on February 7), I didn’t see any results for the experiment. Instead of it, I see the message “Data for this experiment will be available in 24 hours”. Questions:How do I know if my experiment is running successfully and I’m not wasting my time by looking at placeholders for several weeks? Why does RevenueCat say that the data will be available in 24 hours if this is never true? I’m running my third experiment and data was available in 1-3 weeks. What are the minimum criteria for data to be available? E.g., at least three converted users / purchases? Are there any plans to show how the LTV is calculated for each variant? Any clarifications on my questions would be greatly appreciated.
AB experiment favoring variants with actual renewal data?
Hi there, we’ve been running an experiment with two different annual prices for over a month now:Variation A: $12/mth and $50/year Variation B: $12/mth and $60/yearWe noticed the following behavior:The test has always been close, but slightly favoring Variation B for the first 4 weeks Then after the first month was over and the first set of monthly subscriptions were renewing / churning the test completely shifted towards favoring Variation ASo now we are wondering what happened and whether we’d need to wait for 11 months more and once the annual subscriptions start to renew, the picture would look completely different again.How confident can we be that these results are reliable and we should get rid of Variant B now?Also is it possible to get some more insights into the breakdown of the collected data for the tests? Since those tests are very important and the prediction model is somewhat of a black box, it would be very nice to see how many monthly vs annual subscriptions were start
$displayName and $email attributes not showing up on Customer dashboard
Hi, I updated the $displayName and $email user attributes using the REST API for all my users. However when I go to the customer view on the dashboard those two fields are displaying empty text fields (screenshot below). I also used the REST API to GET the latest user info and the response says that the attributes have been set (snippet of response below). How do I get this data to show up on the Customer dashboard? This info is vital to our customer support team.
Best way to see new paying customers in a given time period?
I'd like to track the number of new paying customers we get each month (to calculate CAC). I’ve found two ways to do this, but am seeing large discrepancies between the two. Can someone help me understand the discrepancy, and recommend the best way to get this number?Here is what I’ve been looking at:Active Subscriptions Movement chart - # of “New Actives” for a given month. Customers list - filtered down (e.g. for May, first purchase date >= 2022-05-01, first purchase date < 2022-06-01, total spent > $0) I’m seeing a discrepancy of 13% for May, and 50% for June (numbers are in the low hundreds). My first guess is data lag. This comment suggests that the Customer list can take 2 hours to refresh, but that wouldn’t explain the magnitude of the difference.is there something I’m missing in terms of the definitions for “active subscriptions” and “first purchase date”?From the “Active Subscriptions” chart info on hover:Active Subscriptions shows the number of unexpired, paid subsc
Is it possible to differentiate macOS (catalyst) app from iOS device?
Hi,We Would like to see the differences on the graph (trials, revenue, churn, etc) for our App that’s on the AppStore for iOS/iPad and AppStore for macOS.The bundle id are the same and the in app purchases are also the same.Revenuecat already report Last Seen Platform Version but of course this is the last, it changes and is nor possible to make reports.How to know where the leads are being originated?
Webhooks integration and http
Hi,I am integrating webhooks in out AWS backend application. I am wondering if webhooks can use HTTP? Seems that webhooks seem to work only with SSL certificate.Is there a best practices section for webhook implementation? I haven't found it and it could be a great resource for us. Thanks for any help.
Question about webhook type
Hi, I’m confused about what should the webhook type be in the following 2 cases:I canceled my subscription or my subscription expired, then after several months I purchase it again in the app.I realized Gold subscription I previously purchased is not enough so I purchased Platinum subscription in the app while my Gold subscription is active.
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.