Dashboard & Tools
Get help with charts, customer timelines, and anything related to the RevenueCat dashboard.
- 131 Posts
- 233 Replies
Is there a way to define a report (list) or a chart that shows the expected revenue in some time period?For example, I can get a report of all the current active customers with a positive auto renew intent, which are expected to renew next month. However I’d like to calculate also the expected revenue of those customers, based on the current status of auto-renew. Is that possible? Thanks
I’m trying to export transaction data on a per transaction basis, rather than per user. I’m using a Customer List to do this.For example, I’d like each row to be a transaction by date (user ID, purchase date, amount paid, product name, etc.), whereas the current export shows each row as a single customer.
We just created a Customer List Export. But after decompressing the file all time stamps and other numbers were converted into E+12 numbers. Unfortunately this help article (Viewing Customer Lists Exports | RevenueCat Community) does not help . It seems that the time stamps are already converted to E+12 before extracting the file.I am using Windows & Excel.How can this issue be solved?
Hello - I’m trying to track down an inconsistency and hopefully someone here can help. I’ve noticed in the past week that when I look at the Conversions data, it shows that all trial conversions are zero: there are trials started, but all are labeled as Pending, even though the trial period has ended. When I look at individual days and users, I can indeed see users that converted from trial to subscriptions, but the charts that are supposed to aggregate this data don’t seem to reflect the data that I see by looking at individual users. Any help is appreciated!
Hi Folks,I really want to love RevenueCat since it comes so highly recommended by so many people, but I'm having a few issues that are making that hard. The first is that the Customers List page (https://app.revenuecat.com/lists/) is very slow - a fresh load takes ~6 seconds before any information is shown. Looks like there are 2-3 requests that are queuing in the backend to me (me, subscriber_lists and manifest). These requests are taking nearly ~2s each.The `query` request can also be slow, around ~1s. Timing from Safari: And query:Note that I have less than 10 customers, I am a little worried about what might happen when I (hopefully) have hundreds.The second problem is that (unless I’m doing something wrong, which is very possible) even after I’ve waited for the list to load it doesn’t appear to accurately reflect the state of my subscribers. For instance, if I register a new customer via AnonymousID it doesn’t appear in any of the lists, I need to search specifically for that ID
Hi there, is there a way to create a filtered customer list based on custom Attributes? We would want to use this in order to create a Customer List filtered through a list of “blacklisted” internal accounts we do not want to count towards our sales and user statistics. If there is another way to make this happen, I would love love to hear some tips and best practices.
We’re getting a sudden influx of cancellation webhook calls after we introduce a new pricing model.It has 7-days free trial period and then monthly subscription.What events should be triggered given this user story:User starts a free trial Free trial ends after a week User chooses not to go on with the planI think events trigger like the following: `INITIAL_PURCHASE` → `CANCELLATION`. Is it correct? If FTE does not trigger `CANCELLATION` event, we can’t explain cancellation increase. Additional Question:Also in revenue cat charts, do active subscription contains trial users? Or active subscription chart and active trial chart are not related to each other?
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.
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:
I would like to propose that the is_trial_conversion field be added to all webhook calls. From what I see this is the only field that does not appear in every call. Having well known fields across all event types would save on server side logic to handle missing fields. While I understand that it may seem irrelevant to have this data in a Cancellation for example, the same can be said about takehome_percentage, is_family_share, and several other fields - yet those do appear.
Hi,I’m noticing a difference in the trial started numbers between the Trial Conversion page and the Active Trials Movement page but not sure why it’s happening. This is happening on the new Chart version and here’s the steps we did to reproduce it:Go to the Trial Conversion page Set the Date Range to last 90 days and Show to ‘Days’ Note down the number from the Trials column for a specific day Go to the Active Trials Movement page Set the Date Range to last 90 days and Show to ‘Days’ The ‘New Trials’ number doesn’t seem to match the number of trials from step 3 for that specific day
Hi,Is there a way to see a sum up of the purchase history of a customer? Like how many renewal until now, when was the initial purchase, and details like that?I know there’s a list of the history, but then it’s hard to tell how many renewal until now, and when was the initial purchase that generated all those renewals and revenue, and so on. Thanks
Hi,I don't quite understand how to read the data in the new chart Subscription Retention. I can’t even compare Subscription Retention with Auto Renew Status (original charts) since the new chart comes with a ‘Product duration’ filter that can’t be removed. I tried several combinations of filters but the results I got were totally different from the old chart. Why can’t I use the new chart without that filter? Also what should I pick for a product that is a yearly subscription and has an introductory price for 6 months? I tried both filters for the Product duration and both results are different from the Auto Renew Status with a simple filter by the product. Thanks.
Hello,we are just integrated revenue in our staging environment to test with sandbox users (iOS) and we are experiencing some delay in the dashboard. It takes several hours til our users are visible in the customers list of the dashboard. Is this normal? Does it have something to do with the missing forwarding of the apple push notification as described here? We were actually going to do this at a later step, but if it means the data arrives faster..Best regards,Patrick W.
I really like this chart!In particular, as someone with a very new app, I’m enjoying breaking it down by daily cohort, and looking at my conversion rates with a 15-day delay to the current day, to see how each successive cohort did as 14 day trials expire.I had a quick question, how does the pending column work? I noticed that many users will remain in pending past the length of the trial, is this related to my billing grace period, or maybe something to do with payment processing delays? Or are their other factors at play? Just curious, :)
Hey all! I’m researching different ways to do our next feature and I have some doubts about if RevenueCat can handle the following use case: We want to build a cashback feature with certain rules based on the app usage of the user in a given period of time. To be able to do that we need to know all the payments received in a given period of time to be able to calculate the amount of money to cashback and to whom.Is there a way to easily do that with RevenueCat? An example flow that might be enough: Every first of the month, we can download a .csv file with a list of events occurred in a given period (past month) including: userId - amount ($) - event (renewal/initial_purchase) - timestamp - duration (monthly, annual) - productId
Hello, We are experiencing delays on Dashboard data that we have not been having before. For example the “installs”-metric has been quite reqctive to small changes and seems quite real time. Now however it changes on steps of 10 installs and only like once in an hour. We see from other analytics-solutions that there is constantly installs. Maybe the yesterdays Major outtake is still effecting the reporting?
Hello,We noticed that one of our players was supposed to covert from a trial to a paid monthly subscription, but it shows that a billing error was encountered, so the subscription was cancelled. However, RevCat still shows that the player was given another full month and that it will renew again next month. We were expecting the subscription date to be rolled back, since there was a billing error. And we’ve also not allowed any grace periods through the Google/Apple dashboards.Is there a way to confirm a billing error was in fact encountered? It looks like their total spent at the top says $10, which would include the failed conversion from a trial, so I’m not sure if their purchase did actually go through, but then a different error happened afterwards? If the charge didn’t actually go through, is there a way we can roll back the subscription date for this particular player? And moving forward, is there a way to prevent this from happening to other players in the future?
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.