Dashboard & Tools

Hey, We are a UK based business, with 90% of our subscriptions coming in as GBP. It would be great if your graphs and etl jobs could be set to convert to the currency of your choice rather than USD. The issue I have is due to currency rate changes if we compare year on year revenue numbers, it’s hard to do that if the currency rates have changed significantly in the same period. Right now the USD to GBP rate has changed about 10-15% year on year, hence this being a bit of an issue for us.ThanksJohn

As can be seen in the screenshot attached, some of the “trial start”s are listed as “unknown” in the country breakdown. We didn’t have that issue before, suddenly it started on March 3rd. We didn’t had a new release or a change in the IAPs etc. The thing is, when a trial is converted to a subscription the country data is available again in the “Active Subscription” charts. How can I fix that?I appreciate any help,Thanks in advance 

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

Not Able to find Slack Integration section 

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.

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,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 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?

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?

i cannot find the place in revenucat to see how many sales are on android and how many sales are in IOS. 

We exported all our customer data from the revenue cat customer tab. However under the sections first_seen_at, first_purchase, trial_start_at, etc it lists 13 digit numbers such as 1638562638000. How would we go about converting these timestamps into the date of the day?

Hey guys, In the main screen I see the revenue for the last 28 days. If a user make a refund will this money automatically excluded from the total revenue? 

I have a customer who signed up for a 7 day trial  on 12/20/2021. This is listed correctly in the Customer History in the Customer report. In the same customer report it shows “Trial converts on 2021-12-29”. Why would a 7 day trial go 9 days? In the customer history there is no activity other then :First seen using the app (also on 12/20/2021) Started a trial (12/20/2021) Last opened the app (in last day)Looking at the event data for the Started a trial event the expiration (which should be the conversion) is listed correctly as 1640639521296 which is 12/27/21 - 7 days after trial started.

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?

“Active Subscribers” and “Total Revenue” on the Customers pagedo not match “Active Subscriptions” and “Revenue” on the Overview page, which are higher here.(App Store only.   New app.)Why?

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

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? 

Hello everyone, I am having some troubles concerning RevenueCat.First one is the list of customers which do not appear many users that is already created in RC and we can access by id. (Even filtering directly by an email that exists)Second problem regards to importing old android receipts to RC. It worked with most of cases IOS and android, however, I do not know why, there is two users that have subscriptions and RC do not track it. They have a valid receipt and subscription. When migrating them, RC always responds with status 200. Thanks in advance for your help.

I added a collaborator (a team member) and he added a bunch of new apps that we would like to use.Unfortunately the newly added apps do not show up on our main admin account. Any way to have those apps show up on my main admin account?  What we tried: Tried to add collaborators from the other apps and it asked the collaborator to upgradeAny suggestions welcome!

 The Trial Conversion chart is comprised of these statuses. Is there known logic to replicate these buckets with the data from the /subscribers/ endpoint? I’d like to be able to replicate these states at the database level for internal reporting.

The list of promo durations in the rest API is slightly different from the website UI - but I think these should match!  I attached two screenshots to show the difference. 

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 

Hi,I recently ran an experiment to test a 3-day vs. a 7-day trial. I would like to see some numbers that are currently missing from the report (like trial conversion rate), so I’m wondering if there is any way to export the data from an experiment?Thanks in advance!

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, 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.