Dashboard & Tools

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. 

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.

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 su

How do I filter the customers so that I can see which trials are expiring the soonest and which ones are expiring last. Right now all the dates are out of order

We are using stripe and by mistake we have restore a purchase from a use to an incorrect user. So that users now are alias.Can we revert the change?Should we remove both users and create them again?

The Graphs report no revenue and no new trials since more than 24 hrs.We do have both though.System status shows everything green which it obviously isn’t  CheersKarl

I’m confused about what the “New Customers” metric means? Does that mean how many people have subscribed or how many people have viewed the paywall screen? 

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

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 

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

In the overview panel I see a number of customer ( 398) that does not correspond to the one reported in panel customers (9) . Why there is such a difference? Thanks in advance to anyone that could provide support 

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?

Hello,I would like to know how many in-app purchases have occurred on each Android and iOS markets.Is there a way in RevenueCat?

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!

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?

Hi,Is there a way to change the Overview to be more informative? I would prefer this one: instead of: 

Hey guys,I’ve been loving the LTV charts but one thing is unclear:If a customer reactivates, does their LTV calculation start from scratch?

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.

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?

Why might I be seeing churn greater than 100% when I look at annual churn?

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

Hi,  When filtering in the customer view, can we please add a filter for price in purchased currency. We’re trying to identify customers who have redeemed a promotional offer, and are currently using a range on total spent. This leads to lots of false positives in our reporting.  Additionally if this field could also be sent as part of the Amplitude integration that would be super helpful for our reporting.  Thanks 

These questions are about how churned MRR is calculated in the MRR Movement charts.  QUESTION 1 - Billing Retry and Grace PeriodsHow are users who go into billing retry/grace periods categorized during the billing retry and grace periods? Are they placed into the churned MRR bucket, and then back into new MRR when and if their subscription is recovered?Or are they only placed into the churned MRR bucket when the subscription actually cancelled?QUESTION 2 - Reactivation after expirationIf a user’s subscription expires and they then joins again later, is this this considered New MRR?   

If running an experiment between two offerings – each containing a subscription product and a lifetime subscription product – do the results of the experiment consider the value of the lifetime product in the calculation of LTV?I see no mention of lifetime product metrics in the table of data and so it’s unclear to me if Lifetime products are factored in to the LTV equation. Therefore, it’s difficult to know if the results of the experiment consider any uptake in sales of a Lifetime product.

Hi i am looking for some help with a few questions. The first is that we will be using offerings to manage discount codes across iOS and Android and then tracking the use of those codes throughout the user lifecycle. I have two main questionsAre we able to export the data broken down by offering (I have had a look at the reports and can see that I can segment by offering but as we don’t have any data in there yet i cant see if that data would then be segmented when exported to CSV??  What happens if I remove an offering? I would like to be able to remove an offering so that it doesn’t get returned in the future to the app (and therefore isn’t a valid code) but then also still be able to report on users that are a part of that offering? is this possible? Regards Jon