Dashboard & Tools

Get help with charts, customer timelines, and anything related to the RevenueCat dashboard.

  • 156 Posts
  • 282 Replies

156 Posts

S
Stephen kowalskiNew Member
asked in Dashboard & Tools

Cannt read dates from customer list .CSV export

I am unable to view dates when exporting the .CSV from customer lists. 1) .gz is a silly file type to use for compression 2)I have followed the directions in this for PC.  I have tried the Excel import wizard. It works but dates are illegible. I have tried pasting from a text editor into both GooglSheets and Excel with the same issue. I am not an Excel nor Google sheets rookie by any means but this issue has stumped me. Extremely frustrated. .csv is an extremely simple format to use and export. 

0
S
4 days ago
J
John WardsNew Member
posted in Dashboard & Tools

Feature request: Set project currency

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

0
J
4 days ago
A
amsdamsgramMember
asked in Dashboard & Tools

New retention chart with user maturity

Hi, I just came across this article talking about the new segmentation support for the retention charts and also the consideration of user maturity now.I’m a little bit confused about the last point.From my understanding, it means that in the retention chart you don’t consider anymore that a user will renew until it has actually renewed, am I correct? When I look at a retention chart without any segment, it seems like you’re still considering that a user will renew unless it cancels its subscription:Retention chart for the last 90 days​​​​​​On the other hand, when I add a segment like country still for the last 90 days, I do only see the retention of the past 2 months, and no projection for the current month.Retention chart with a segment For me, the data dilemma you’re talking about in your article is occurring no matter if we add a segment or not. Would you have an explanation about these two different behaviors? Thank you,

4
A
5 days ago
B
BrentNew Member
asked in Dashboard & Tools

Can you change the currency shown in the revenuecat dashboards from USD?

I understand that the currency of the product is handled by the app store, but when viewing the revenuecat dashboards, the prices are always converted to USD currently.Is there a way to set the currency displayed in revenuecat? Thanks,Brent

3
B
6 days ago
E
Erdem SenolNew Member
asked in Dashboard & Tools

Charts dashboard rest API endpoints foe developers

You currently do not have analytics endpoints for developers. Do you have plans to add some endpoints for analytics data similar to your Chats dashboard in the future?

4
Dan Pannasch
RevenueCat Staff
7 days ago
U
UlyssesAlvesDedicated Member
posted in Dashboard & Tools

RevenueCat Dashboard not showing user attributes.

I would like to report a possible bug found on RevenueCat dashboard, like I wrote recently on another thread which is marked as resolved, even though the bug still persists:I am using this code to update user name and email, but the changes don’t show up on Customer Profile page for this user on RevenueCat dashboard.Purchases.setDisplayName(“John Doe”);Purchases.setEmail(“john@doe.com”); @goleary confirmed the bug also occurs in his project, and gave more information:Same here, I’m setting attributes via the REST API, and they show up when I hit the subscriber status endpoint, but they do not show up in the RevenueCat dashboard. Here’s a link to the other, related discussion:  

4
U
9 days ago
A
Adam CooperNew Member
asked in Dashboard & Tools

How do I make a revenue export useful?

I’m exporting data to try and measure revenue performance of ASA campaigns to work out overall ROAS but the revenue export is unusable and just shows my ad groups as 357 columns. These can’t be added to a pivot table and can’t be aggregated without manually going through and manipulating the data.Is there a way to export only totals, or export it in a usable format, or does anyone have a ‘fix’ to allow the data to be used in Excel please?Ideally we’d have campaign/ad group name as column A, revenue total(s) as column B/C/D. This would allow us to easily aggregate the data, instead of having separate revenue columns for every single ad group or campaign.Thanks in advance!

1
Roberto Ansuini
RevenueCat Staff
10 days ago
I
ICaughtUNew Member
asked in Dashboard & Tools

Webhook problem

Hi everyone,I create a Webhook URL but when I try to receive real events but I don't see them in the “Webhook Events” list - is empty and also in my web hook server I didn't receive anything, but in “Recent Transactions” I see it why? “Refresh” - don't do anything.   

0
I
10 days ago
M
mr.johnNew Member
asked in Dashboard & Tools

How to add 2 annual products to Annual package in an offering?

Maybe I didn’t fully understand the purpose of packages in offerings. I would like to have one offering, with 1 package, which contains 2 different products. Both should have annual renewal, but are linked to different entitlements, since one gives full access, and one only reduced (read-only). How to do this? When I try to add a second product, the first one is replaced.Do I have to create 2 offerings? I cannot have another package with “Annual” identifier...

2
M
17 days ago
G
GazpNew Member
asked in Dashboard & Tools

Create a `staging` project for staging versions of our apps and test subscriptions, offerings etc

@ryan You mentioned in this thread : Some developers choose to create multiple RevenueCat apps for different environments of the same bundle ID as well.I just wanted to check - if we want to have a staging setup to go with our apps staging environment that means we can test new products/entitlements/ offerings etc without affecting our Production apps - given the above detail we could effectively just :- Create a new Project (and suffix it’s name with STAGING for example) - Define our apps again using the same bundleids/package names - Setup products/entitlements/ offerings etc and test them independently of our Prod apps because we would have a new unique API keyIs that a valid way to essentially duplicate what we have for a staging setup?Are there any settings we should not re-use from our Prod Project or can it essentially be duplicated?Hope that makes sense, if you need more detail please let me know

3
tina
RevenueCat Staff
17 days ago
M
MaruNew Member
asked in Dashboard & Tools

How to remove entitlement when lifetime purchase is refunded?

Your documentation has the following paragraph:If you wanted to add a 'Lifetime Unlock' purchase option to your app, it is recommended to create a new non-consumable IAP, add the product to your offering, and add the product to your entitlement. This works well in many contexts, such as alongside other subscription packages, or just as a standalone package in your offering. We noticed that this scenario breaks when a user requests a refund for this IAP, as RevenueCat treats the Entitlement as unlocked forever.It would be great when there was an option in the dashboard to at least manually remove an Entitlement (maybe I have missed it?)

6
A
19 days ago
A
Armando JimenezMember
asked in Dashboard & Tools

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. 

4
tina
RevenueCat Staff
24 days ago
M
Matthieu RouifNew Member
asked in Dashboard & Tools

Retention Charts

Hello,I am using “active subscriptions” segmented by the first purchase month to look at blended retention (all product duration). I find it very convenient. What I realized recently is that if you compare:yearly retention chart active subscription chart filtered yearly and segmented by first purchase monthYou get a different result. In particular, the yearly retention chart initial value for a cohort is around 10% higher than the active subscription chart initial value. I am trying to understand why.

1
Dan Pannasch
RevenueCat Staff
26 days ago
Timur
TimurNew Member
asked in Dashboard & Tools

Admin Panel doesn't show more than a 1000 products

When we open Products page app.revenuecat.com/projects/PROJECT_ID/products, it only reveals the first 1000 products.On this page this call to internal API happens api.revenuecat.com/internal/v1/developers/me/projects/PROJECT_ID/products. Seems like there is a limit (1000). In our case we have more than 1000 products across many of our apps (76) inside one project. Any suggestions on what we could do with this? Maybe there is a way to paginate the results of this API call?

5
Timur
1 month ago
renchap
renchapNew Member
asked in Dashboard & Tools

Is there an API to get dashboard statictics?

Hi, We have an internal statistics tools which collects various statistics each day, which are then used in various internal reports.I would like to add some data available in RC dashboard to those reports, for example the number of active subscription (ideally per app), and the MRR (ideally per app as well).Is it a way to easily get those informations from RevenueCat? I would probably use the API to get all subscriptions and compute those myself, but it would be much more efficient to use the data calculated by RC. Thanks,

1
Dan Pannasch
RevenueCat Staff
1 month ago
T
tokoNew Member
asked in Dashboard & Tools

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

2
T
1 month ago
W
Will NNew Member
asked in Dashboard & Tools

Why is the app_user_id column blank for the majority of users in my exported customer list?

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.

2
W
1 month ago
A
adnanNew Member
asked in Dashboard & Tools

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

1
ryan
RevenueCat Staff
1 month ago
J
Jordan PetersonMember
asked in Dashboard & Tools

How to filter customers in order purchased

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

3
Miguel Carranza
RevenueCat Staff
1 month ago
J
Juan ekiluNew Member
asked in Dashboard & Tools

Revert a purchase restore

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?

1
Miguel Carranza
RevenueCat Staff
1 month ago
K
Karl HeupelNew Member
asked in Dashboard & Tools

Problems iwrh dashboard graphs

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

4
Jens
RevenueCat Staff
1 month ago
J
Jordan PetersonMember
asked in Dashboard & Tools

What does "New Customers" mean?

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? 

0
J
2 months ago
V
V1 SportsNew Member
asked in Dashboard & Tools

Stripe subscribers not showing in Active customers list

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

0
V
2 months ago
B
bircoyNew Member
asked in Dashboard & Tools

Dasboard Recent Transactions shows the number of transactions more than it should be

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 

1
B
2 months ago
J
Jakub DanielczykNew Member
asked in Dashboard & Tools

An entitlement provided by subscription purchase doesn't override RC promotional entitlement

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 from app store/play store.  Currently as a workaround we manually revoke promotional ent

0
J
2 months ago

Badge winners

Show all badges
Terms & ConditionsCookie settings