Building and Sharing Your Analysis

Learn, ask questions, and help others build Amplitude charts and gain valuable insights!

  • 850 Topics
  • 2,264 Replies

850 Topics

M
Helpful Hero
Marta CataláHelpful Hero
asked in  Building and Sharing Your Analysis

Bug None Property Value

Hello everybody!We have identify we have a too low volume of users in a funnel dashboard that segment 2 audiences via the context page url property. Amplitude says we have 10 users in the variant B meanwhile Analytics says we have around 100 users. (Also, with no need of comparison, we know that the specific page is not receiving only 10 users with any event). ResearchWe have found that Ampltiude is registering around 90% of events such as page view or any events with the property context page url = none . So it has a big impact on our data. (I can share the dashboard with you if you need). Also we see that this event with properties none during this month. So this would underestimate the explanation that is on this amplitude article: https://help.amplitude.com/hc/en-us/articles/360016257391-FAQ-Why-is-this-user-counted-under-none-or-an-unexpected-value- First conclussionsOur conclusion is that these none results could be affecting the results on our dashboard. Also, we have a test wit

11
M
Helpful Hero
1 year ago
I
Conversationalist
Iain_MindseaConversationalist
asked in  Building and Sharing Your Analysis

Amplitude React-Native SDK Beta Unstable, please validate before releasing

I realize the new React-Native SDK is in beta, but could you please sanity-check it before releasing a new version?We have one app running on 0.2.3 that works fine. We tried adding it to another app and got 0.3.0 which doesn’t work at all, and then tried 0.3.1 which doesn’t work, either. Rolling back to 0.2.3 got us going again, but doesn’t leave us with a lot of faith in your beta process. You’ve got too many regression problems going on right now.

8
I
Conversationalist
1 year ago
Product Release Team
Team Member
Product Release TeamAmplitude
posted in  Building and Sharing Your Analysis

What's your strategy for 2023?

We’ve been working hard to develop a winning strategy.With everything going on, how are you thinking about product strategy as we head towards 2023? Let us know in the comments below.  John Cutler—Product Evangelist at Amplitude—will be interviewing our VP of Product Management at this upcoming webinar focused on strategic priorities and planning for next year.He’s also compiled North Star Framework tools/ frameworks/ content in a single Miro board and recorded short Loom videos for each template. Get started here!The resource is getting a lot of love, and we’ve found it super helpful too!

0
Product Release Team
Team Member
1 year ago
M
Helpful Hero
Marta CataláHelpful Hero
posted in  Building and Sharing Your Analysis

Incorrect url.context.page

We are seeing now is that when I do any event in the spefic page, the event is triggered in user look ap but the context.url.page is not erudit.ai/variant but erudit/. The specific page is this one. https://www.erudit.ai/variantDo you know if this none bug could see the reason why we are not getting all the data. Thanks in advance, Denis!

2
M
Helpful Hero
1 year ago
M
Helpful Hero
Marta CataláHelpful Hero
posted in  Building and Sharing Your Analysis

Bug with event property page.url

Hello everybody!We've a problem with the event page view property url context or page context as we are not tracking all the users that are making page view in that specific page. We are comparing this data with analytics data.We have checked with the user lookup, if I register the event properly and it seems ok with the event and also the property of the event. However, we register only 10 contacts meanwhile it need to be around 90 contacts.  Someone that could help on this issue? 

1
Yuanyuan Zhang
Team Member
1 year ago
K
Novice
konradmNovice
asked in  Building and Sharing Your Analysis

User Retention on day 1 only

I’m trying to create a chart that lets me analyse how many users return on the first day after their first use. Ideally I could see the change of that one number over time.Essentially that would be like the second column of a retention chart. Whatever I try I don’t get the same result though. What would be the best way to achieve this?

4
belinda.chiu
Team Member
1 year ago
K
Novice
konradmNovice
asked in  Building and Sharing Your Analysis

Get number of users who have performed an event on any 5 different days during the last 14 days

Hi, new user to Amplitude and love it already. I’m trying to evaluate a KPI we’ve defined:“How many users have opened the app on at least 5 different days during the last 14 days.”I’ve tried this and that:A cohort with amount of app openings during the last 14 days This doesn’t show me the number of days though, only the number of events (e.g. someone could open the app 5 times a day and not at all in the rest of the 14d) A stickyness chart This seems to show me however the amount of days per week, not in a specific time rangeAm I missing something? How would I achieve such a chart / cohort?

7
Yuanyuan Zhang
Team Member
1 year ago
F
Novice
frank.serafineNovice
asked in  Building and Sharing Your Analysis

How to interpret CSV-exported Time to Convert values over time?

When exporting Time to Convert data in a CSV from a Funnel analysis, ‘2m 54s’ exports to ‘175000’, which doesn’t make any mathematical sense to me. You have to divide that figure by 60,000 in order to give you an accurate minutes figure (2.91 minutes). How am I supposed to interpret the ‘175000’ figure? What is its time precision? Or is this a bug?

1
Denis Holmes
Team Member
1 year ago
T
tncbbthositgNew Member
asked in  Building and Sharing Your Analysis

Second Y-Axis on Line Chart

I’d like to have metrics with different scales on the same chart.  For example, I’d like to see the raw counts for subscriptions and also a conversion rate. I can do that with formulas just fine, but it’d be helpful if the percentage scale could be on the right while the raw counts were on the left. Is there a way to do this?  If not, how would one request a feature like this?

2
Jeremie Gluckman
Team Member
1 year ago
D
dalvarezNew Member
asked in  Building and Sharing Your Analysis

Can I create a relationship table, of id to title

hey all,I’m not sure if its possible, but i’d like to setup a an “associative” or “relationship” table where, given an id (number or string) it can return a title (string) for labeling in charts.ie.I have a chart where an event property i’m grouping by is an id, but I would like to label each of the lines or bars with the associated title for that id. Is this possible - in either the Analytics section or the Amplitude Data section? Or is the solution to just pass the title as an extra event property in my logging?Thanks 

2
D
1 year ago
O
Helpful Hero
OmrikoHelpful Hero
asked in  Building and Sharing Your Analysis

Normalized time zone

Hi, So, we have customers from all over and I wanted to know if it is possible to normalize hours of day?Meaning, I’d like to see the user time zone rather than the account time zone so that users from Germany 4PM would join users from USA 4PM.Regards and thanks!

2
O
Helpful Hero
1 year ago
sydney.koh
Team Member
sydney.kohAmplitude Support
posted in  Building and Sharing Your Analysis

[Retention] Why are the percentages in the Retention chart low in comparison to the percentages seen in the breakdown chart?

This is a common question we get in our support tickets! Allow me to explain. When looking at the Retention chart values versus the breakdown chart values it is important to note two things: The chart values will be a deduplicated number of users from the breakdown table  Incomplete data points are not included in the chart values I will elaborate on both points below!  Retention chart values are deduplicated breakdown chart usersThe chart values on a Retention Analysis chart will be the top row of percentages in the breakdown table which is highlighted in the picture below. These values are the number of unique users who have performed the return event at day X out of the total number of unique users who have completed day X. In other words this row is a weighted average percentage of the below row values.  This weighted average top row will deduplicate the users in the rows below. If there was a user who performed the first event and return event multiple times in the time frame th

3
A
1 year ago
S
Helpful Hero
sergiiHelpful Hero
asked in  Building and Sharing Your Analysis

Custom formula CUMSUM(PROPSUM, A, 7)/CUMSUM(UNIQUES, B)

Greetings,The ticket is related to the previous ticket: link, which you marked as SOLVED without responding there. Though I never mentioned the issue is resolved, please kindly help me further:Let me describe the issue again:In genera,l I have two events:- event A- event B1) Event A has the "spend" property, I will have to use this property value in the formula.2) In Event B I would need to use the number of unique UNIQUES(B) calls - this is clear.I need to have a sum of values of event A for the last 7 days within 180 days. I found the CUMSUM() formula which does almost everything I need, but I cannot set up a number of days for which I want to get a sum of values. Logically, the formula should look like this:CUMSUM(PROPSUM, A, 7)/CUMSUM(UNIQUES, B)I need to select 180 days on the chart: https://prnt.sc/oKAwqbOI5rmI.But I am getting 400 error: status code. I understand that the CUMSUM() formula does not support the third parameter (7 days). But maybe there's another way to achieve the

2
S
Helpful Hero
1 year ago
D
Conversationalist
Dmpm12
asked in  Building and Sharing Your Analysis

Breaking down a retention event

I have a North Star metric and I want to understand how many times a user performs this event and create a breakdown of the number of times until they retain or become sticky. For example: creating a noteNo of times.   Retention1 time 3% 2 times 5% 3 times 10% 4 times 20% 5 times 30%

4
Yuanyuan Zhang
Team Member
1 year ago
M
mhgaberNew Member
asked in  Building and Sharing Your Analysis

Funnel mis-representation of the KPIs

I am trying to build a funnel of my main KPIs to show the conversion rate of the customers. The customer journey starts with viewing the page then performing some events until event 1 then some other events to event 2.. etc. My problem is the funnel doesn’t reflect the actual events done by the users and when I change the order it reflects the actual number of the users who performed the final event, what should I do to reflect the right numbers of customers who perform each single event ?  

5
Z
Team Member
1 year ago
timothy-permutable
Super Helper
timothy-permutableSuper Helper
posted in  Building and Sharing Your Analysis

Calculating Word of Mouth Coefficient in Amplitude

I’ve written this on calculating Word of Mouth Coefficient in Amplitude. Hopefully this might be useful!https://timothydaniell.medium.com/how-to-calculate-the-word-of-mouth-coefficient-in-amplitude-b266acff8f40 Original article on the topic is on the reforge blog here:https://www.reforge.com/blog/word-of-mouth-coefficient

0
timothy-permutable
Super Helper
1 year ago
E
elena_grantNew Member
asked in  Building and Sharing Your Analysis

Space in front of text in the rows and columns headings when export to csv from chart

I always have huge spaces (tab?) in front of a text in every cell of heading when export data to csv. The only way how I can remove all these extra spaces fast enough is to create an extra column or row with a formula ‘=clean()’Could anyone advise, please, what setting on my computer I need to change to fix this?  

4
Thao Nguyen
Team Member
1 year ago
D
danahNew Member
asked in  Building and Sharing Your Analysis

Visualizing weekly cohort retention chart in a dashboard

Hi there,  I have a retention chart created with n-day retention and weekly windows. I’m interested in the weekly cohort breakdown chart that shows for each week how many users onboarded and what percent returned for n-weeks after. When I save this analysis to a dashboard and switch the view from chart to table, it only shows the total view of all users vs. the breakdown of each weekly cohort. How can I save the breakdown view with weekly cohorts to the dashboard? Thanks!

2
belinda.chiu
Team Member
1 year ago
S
Helpful Hero
sergiiHelpful Hero
asked in  Building and Sharing Your Analysis

Custom formula (Sum of event A properties "spend" for the last 7 days)/(Sum of events B for last 7 days)

Greetings,I faced an issue with rendering a chart using your custom formulas.In general I have two events:- event A- event B1) Event A has the "spend" property, I will have to use this property value in the formula.2) In Event B I would need to use the number of unique UNIQUES(B) calls - this is clear.I need to perform the following calculations:1) Take the "spend" property value (can be any number) and sum them up over the last 7 days.2) Divide the result by the sum of Event B calls over the last 7 days.If I try to imagine the formula logically, in a simple way, then it should be something like:(Sum of event A properties "spend" for the last 7 days)/(Sum of events B for last 7 days)I checked your documentation together with tech support topics, but I couldn't find the way to create such a formula.Please let me know if anything's unclear. I hope you can help me with achieving it.

5
Saish Redkar
Expert
1 year ago
D
danahNew Member
asked in  Building and Sharing Your Analysis

Measuring NET DAU, WAU, MAU - e.g. WAU - Users who joined in L7 days

Hi, I have a chart where I’ve plotted DAU, WAU, and MAU using the formula bar. For each metric, I want to remove users who onboarded in that timeframe (fired the onboard event), as it inflates the numbers. For example:Net DAU = distinct users who visited in the last day - users who onboarded in the last day Net WAU = distinct users who visited in L7 days - users who onboarded in L7 days Net MAU = distinct users who visited in L30 days - users who onboarded in L30 daysHow can I do this? Thanks!

2
belinda.chiu
Team Member
1 year ago
A
abbys234New Member
asked in  Building and Sharing Your Analysis

Can the same "device" (computer for example) generate two different device IDs? Similarly, can a user whose entire session occurs on one device generate events with different device IDs?

Can the same "device" (computer for example) generate two different device IDs? Similarly, can a user whose entire session occurs on one device generate events with different device IDs?

1
Z
Team Member
1 year ago
O
Helpful Hero
OmrikoHelpful Hero
asked in  Building and Sharing Your Analysis

Daily active users

Hi,A noob question but, how would I see the absolute number of unique daily user (not events),Do i need to group by user ID? Thanks!

2
O
Helpful Hero
1 year ago
A
abbys234New Member
asked in  Building and Sharing Your Analysis

Is it possible for two different users to have the same device ID? I understand it's possible if they use the same computer/ device to log in, but what if they don't? Is Device ID completely reliable in terms of being unique for every device?

Device ID as Unique Identifier 

1
Z
Team Member
1 year ago
C
Chidada
asked in  Building and Sharing Your Analysis

How to adjust more than 2 retention events?

Hi, is there any way to add more than 2 return events to be shown in the retention?Or any other recommended chart, in this case, I have 10 types of products separated by event properties and I want to see each retention rate.Thanks

1
Saish Redkar
Expert
1 year ago
M
manoj kumarNew Member
asked in  Building and Sharing Your Analysis

Active users data get changed on DoD basis

Hi Folks,Im manoj kumar, beginner at amplitude. I have one concer. I have design a visuals where i can see daily active users on day to day basis. but data get change when I compare active users on day to day basis. For example, I checked the active users data on 15th June, 2022 and 20th Aug, 2022 respective. Data for both time period are different. Attached screen shot for reference.Left side data was downloaded on 15th July, 2022 and right side data was downloaded on 20th Aug, 2022. why there are difference in numbers.Pls resolve my concern. Thanks in Advance.--Manoj Kumar   

2
M
1 year ago

Terms & ConditionsCookie settings