Dashboard & Tools

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?

Hi!In the last week or so, we've been unable to process refunds for recent Android subscription purchases.Example 1:—android user charged for yearly sub a few days ago, requesting refund.—when clicking into the charge line, there is no option to refund. i’ve never seen this with such a recent purchase.—shows user as ‘trial expired’ and is currently not subscribed… but was charged —when clicking on the purchase line, it shows a failure for webhooks… not sure if that has anything to do with not being able to see / process refund?Example 2:—yearly sub purchased 29 Nov 2021, but shows as 'Subscription expired on 2021-12-07'—seems timing logic for cancelling trials has overridden the yearly subscription logic If we refer users to Google Play help, they are referred back to us.Anyone have any thoughts or advice on this? Thanks!

Hi!The docs (https://docs.revenuecat.com/docs/apple-server-notifications) mention the step “Scroll to the App Store configuration section, and copy the entire URL provided under Apple Server Notification URL [in the RevenueCat dashboard]”. However, I don’t see that section at all. Is there anything I can do to make this section show up?

Why does the Active Subscriptions Chart reflect the total of actives, billing_issue, cancelled, cancelled_trial, free_trial and intro_period in the chart tooltip and summary table below? This overstates the active subscriptions count.The actual active subscriptions count can only be found by exporting customer lists and pivoting or filtering for ‘active’ status.Shouldn’t the tooltip and table filter for active status as well? So as not to overstate active subscriptions.

Is there a way to chart the avg number of days between an app install and trial start?

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!

Really exciting news about the new subscription sharing between apps feature.I had already set this up using RevenueCat and some custom server and client side code to enable users to access their subscriptions across multiple apps.Now that our apps have been auto migrated to projects, I’d like to have them all exist as one project with several apps. Is there a process to do this? In my specific case, I have 2x iOS and 1x macOS app, each with their own subscriptions at identical prices with my custom logic unlocking the entitlements across the apps when users sign in. It would be much easier to have RevenueCat handle this.Thanks in advance!

I am unable to replicate the Active Subscriptions number from the dashboard chart.From the transactions data obtained through the ETL exports, I have tried the SQL example found here, as well as variations of it, but the result always differs from what’s in the chart.What are the calculation details for Active Subscriptions?

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. 

Is there a way in revenue cat to see how long (days, weeks, months) an users are premium paid subscribers before they voluntarily churn? Ideally this would be a cohort chart. I see there is a cohort chart, but I am trying to see this in days. On average how many days before someone churns. Is there already a way to see that that I am missing?

We currently have an AB test running, but the results seem confusing. The tests shows the following numbers: Variant A has an annual price of $49.99 and Variant B $59.99. From this, it seems more intuitive to me that Variant A is outperforming because the price of B is only 20% higher than A’s, but there are more than double the amount of active subscriptions in Variant A. Yet, the results section suggests:“Based on our most recent run of the model, at 1 years, there is a 67% chance that Variant B has a higher LTV.”Can you explain to me where this result comes from? Maybe there’s just a lack of additional data in the dashboard that would show the real reason, but with the data available, it seems very off for us. Thanks

I want to calculate the trial conversion rate with data in the new UI. In the old UI, I took the ratio of total trial conversions to Eligible Trial conversion. I cannot seem to find their analogs. Where should I be looking?

Is there any chart that shows the number of renewed subscriptions per month? I know that I can see the renewal revenue and the total number of active subscriptions, but I am trying to find a way to also find out about the number of renewals.Thanks!

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 think it’d would be nice to have a chart about intro price period conversion to the full price subscription, just like free trial conversion to paid subscription. Is there a way to get this data from the platform? 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. 

Hello,I can see active users on the front dashboard  during my sandbox testing. I filled up all the details. We are testing using SWIFTUI and iOS 15.1 on a physical device. However, when I look into details I am not able to see the details. Please elaborate on this. 

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!

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