Skip to main content

Building and Sharing Your Analysis

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

  • 992 Topics
  • 2,450 Replies
991 Topics
Y
yaqiNew Member
asked in  Building and Sharing Your Analysis
[Funnel Analysis] How to create break down the funnel by price bucket?

We have a product purchasing funnel of `product page viewed` → `product added to cart` → `Revenue` with `price` (e.g. $12.99, $23.99,$50.99) as the event property in each event.I am interested in the conversion break-down of different price buckets. E.g. products price between $0-20, $30-50, $50-100, >$100. How could I do this through breakdown by property and hold … constant? Do I have to change the tracking code to append the price bracket event property to every event? 

4101
Saish Redkar
Expert
M
Mano LeeNew Member
asked in  Building and Sharing Your Analysis
User ID, Amplitude ID {where: ≠ is not} filter does not work

Hello I want to see the chart excluding the colleagues' User ID.  When I set my User ID to 'is' for the test, the unique value worked well with 1. I can see I entered my User ID accurately. However, even if I set it as 'is not', my User Id is reflected when I did 'view users'.* It also didn’t work with Amplitude IDIt would be greatful if anyone can help me Thank you!

8235
N
J
jdamattaNew Member
asked in  Building and Sharing Your Analysis
Why week 0 is not 100% for "new users" event?

Hi there! I am a little confused with the retention chart and some of the numbers in it. I've created a simple retention chart with start event being "New User" and return event event being "Any Active Event". So far so good. The first thing I notice that seems odd is that the week 0 of the line chart is not 100%. Furthermore, when I look at the breakdown table, the most recent cohorts have a set number of total users but the week 0 percentage is not 100%. I am mostly confused because I thought week 0 would just account for the start event ("New User") and always be 100%. I was able to replicate it in the demo env: https://analytics.amplitude.com/demo/chart/2o42l6f/edit/5ipz5liMaybe I am a bit confused with the New User event and not using it properly. I appreciate the help! Best, João da Matta  

9554
Z
Team Member
U
user73New Member
asked in  Building and Sharing Your Analysis
Link Client/Server events into a single Session

We have a web application and we are trying to link both client/server side events into sessions.At the same time, we are using Segment as a data source for the Amplitude.What we are trying to achieve is a similar to the default behavior: link all events happened within less than 30 minutes delay.For this purpose, it is necessary to generate the session Id on the server, and pass it to the client for the further usage. And to track the last event time for the 30 minutes tracking.One of solutions is to use cookies with the expiration time and track it both on server and client side. is there is a more straightforward solution for this quite standard procedure? are there best practices to synchronize events order on client/server side?

4371
Yuanyuan Zhang
Team Member
L
LevkovichNew Member
posted in  Building and Sharing Your Analysis
What the hell is going on?

Hello community. I hope you can help me.I have created a company account. But it took some time before I decided to actually look into it.. Now I'm trying to log in, but they ask me the url of the organization. I went through all the options I could write. The answer is that no such company has been found. At the same time, an attempt to enter the Demo mode is answered - by such an account  already registered. Password recovery allows you to change the password to a new one. But I can't log in without the URL of the organization!There is no restoration of this url!I go to Support. But I am being asked to register again. But safari now blocks cookies. It does not allow you to register without them. I'm going to the Chrome. I'm registering. But it is impossible to ask a question. They say go to the Community. I'm going to the Community. I'm registering. Seriously? The third time? I register and write you a question. What the hell is going on?!Is it possible to restore the URL? How do I l

3221
sydney.koh
Team Member
L
Helpful Hero
leothexxxHelpful Hero
asked in  Building and Sharing Your Analysis
Missing average value for event property

Summary:‘first_search_time’ tracks the duration between when the user sign-ups and makes their first search. I can see that in uniques (first screenshot), but I’m unable to get an average of them across all users (second screenshot).  What am I doing wrong?  uniquesmissing average 

5415
L
Helpful Hero
K
KellerNew Member
asked in  Building and Sharing Your Analysis
Clarification about Unique in the segmentation chart?

Hey there,I am new in Amplitude and unique events in segmentation are not 100% clear for me. Scenario:Let’s say I have 4 articles with 4 different titles (A, B, C, D) and I want to count, how many unique people read a specific article a day. (How often an article is read a day in total, that would be total events.) I am tracking reading with an event, when the user is opening the article. Let’s say, it calls article_open.So for my understanding: With the function Unique as soon as the event article_open is performed this day an user is not counted again this day. So if user X reading the article A and later the article B (on the same day). Is user X only counted for article A (since he performed the event already and can’t be counted once more) or is he also counted as a reader of article B this day, too (since user X didn’t perform “article_open” B?)Thanks in advance. :)

4422
K
L
luigi.radicatiNew Member
asked in  Building and Sharing Your Analysis
Cards clicked more than 10 times a day

Hi community, this is my first question here.I have a page with a list of cards. Each card fires an event “card clicked” with a property “name”. I would like to graph the percentage of cards that receive more than 10 clicks a day every day, grouped by “name”.

3735
Saish Redkar
Expert
I
iislam2907New Member
asked in  Building and Sharing Your Analysis
How to create Amplitude behavior using datasource from Amplitude?

I have exported all data from Amplitude using Google Big Query. Now i have connected db to Tableau. The problem is replicate Amplitude behavior using raw data.Can you please help me to re-create Amplitude funnel logic?The main intent was to conduct analysis with costs, since such option is absent in Amplitude right now.

4313
Saish Redkar
Expert
Jeremie Gluckman
Team Member
Jeremie GluckmanTeam Member
posted in  Building and Sharing Your Analysis
Guiding Questions: Why is a central analytics team vital to a self-service data culture?

I’m beyond excited about the Coffee Chat series! This month, we’re chatting about why a central analytics team is vital to a self-service data culture.Here are some guiding questions: What are the different models that organizations use for digital analytics, and what are the pros and cons of each? Central Analytics teams have a lot to manage, what’s been your experience with ones that support self-service models? Where have you seen this fail?  The ideal goal of a central analytics team is to federate insights to the business, how do they get in the trap of “answering all the questions”? Let’s say the customer is just getting started with this idea… where should they start?Which Amplitude feature do you feel best supports the ideal data culture?Team Spaces Notebooks Data Governance (i.e. screenshots of events)Pick one, two, or six questions to answer and post your thoughts in the comments below. Let’s keep the conversation going! 

3100
Jeremie Gluckman
Team Member
G
GillesNNew Member
asked in  Building and Sharing Your Analysis
React native integration

I have used Amplitude integrated with react native and expo for a few months for my mobile application, everything was working fine.I was using the package “expo-analytics-amplitude”. Recently, I have developed a web version. The latest package does not work for web (cf https://docs.expo.dev/versions/latest/sdk/amplitude/). Apparently, there won’t be a web version and this package will be deprecated soon (cf https://github.com/expo/expo/issues/6886#issuecomment-1015957268) in favor of https://www.npmjs.com/package/@amplitude/react-native Trying to implement amplitude/react-native, I ran into the following issue:https://github.com/amplitude/Amplitude-ReactNative/issues/96for which there does not seem to be any fix nor workaround. Any solution except switching to mixpanel? Thanks 

13023
Denis Holmes
Team Member
T
Novice
tthiasNovice
asked in  Building and Sharing Your Analysis
Event Segmentation, group by user property vs event property

Hello, I'm trying to group by a event by the current value of a user property value.It feels like the event is only grouped by the value of this property for the event but not the user property value.I would like the breakdown available in User composition but in Event Segmentation.How can I achieve that ? Thanks, Matthias  

9014
Saish Redkar
Expert
T
ThrasherNew Member
asked in  Building and Sharing Your Analysis
Bar Chart Total Doesn't Match Stacked Bar Chart Total

I have a “Stacked Bar” Chart which has been filtered for a single merchant. I want to see a summary for the selected date range. The graph and breakdown table do not show a total. It only offers row average, row median, and row change. I can export the data and see a sum of 75, but this is a hassle. Instead, I have been changing the chart type to “Bar” because it supports totals. However, this changes the total to 48. How could the stacked bar have 75 and the bar chart has 48? HERE ARE THE SCREENSHOTS. Thank you

4603
ning.chang
Team Member
J
jdamattaNew Member
asked in  Building and Sharing Your Analysis
Is it possible to calculate CMGR in Amplitude?

Hello,So far I have only been able to calculate % growth from first date to last date [(V1 - V0)/V0]. Ideally, it would be more helpful to calculate the compound annual/monthly/weekly growth rate (GMGR) so that I can understand overtime growth in a more comprehensive way. Is it possible?Thanks in advance!

4592
Dr.Data
Helpful Hero
S
SonaNew Member
asked in  Building and Sharing Your Analysis
Get user base from amplitude

Hi,We are using amplitude to truck some events that users of our system take.Now we are introducing “user delete” event by setting a property on the user object. As this is a new property, we already have users in amplitude that are no longer exist in our Database, but the property is not set in amplitude.We need to set correct values for all users in amplitude, thus we need to compare users in our DB and in amplitude. Question: Is there a way to get the whole list of users from the amplitude? 

11224
Denis Holmes
Team Member
P
patrickNew Member
asked in  Building and Sharing Your Analysis
Limit of 30 items in a group by or Breakdown table?

Amplitude seems to be showing an incomplete data set on several of my charts. I discovered this seems to be because the Breakdown table below the chart was set to only show the top 12 items (the chart uses a group by expression). I attempted to select all items but it maxed out at “Breakdown showing top 30” (when there are actually 35 items). The UI doesn’t allow me to select or show the other 5.  Is this some kind of Amplitude limitation? I can’t find it documented anywhere. The docs say group by’s are limited to 100 for performance reasons: https://help.amplitude.com/hc/en-us/articles/360031259831But 30 is nowhere near 100. Maybe there’s a bug? Thanks for any help. 

9376
jmagg
Team Member
Mikhail Shcherbakov
Novice
Mikhail ShcherbakovNovice
asked in  Building and Sharing Your Analysis
Is there any amplitude-community Slack-Space ?

Hi guys, I was wondering if there is any Amplitude-professional users Slack workspace ? As, for example, some workspaces exist for marketers / data scientist etc. If not maybe we shal create one?  thanks 

8464
Jeremie Gluckman
Team Member
M
MikeLNew Member
asked in  Building and Sharing Your Analysis
How do dynamic cohorts work in historical graphs?

Hello,  I’ve created a dynamic cohort of users (“active users”) who performed a set of tracking events “set A” in the last 7 days. When I create a new chart to see “active users” who performed a different set of tracking events “set B” over the last 60 days, how does the dynamic cohort behave?Does the dynamic cohort retroactively adjust to determine the set of users 60 days ago that performed the initial “set A” 60 days ago? ...or does the dynamic cohort define the set of “active users” as of today, and just look at that set list of users 60 days ago? Example:Create dynamic cohort is users who performed tracking event A in last 7 days. As of today, I see 3 users with IDs: 345, 346, 347 I create a chart for tracking event B over the last 60-days I apply a filter on users of the dynamic cohort Will the chart only show me those 3 users? Let’s say users 345, 346, 347 only signed up two weeks ago. If I look at the chart, will I see 0 users of dynamic cohort with event b usage 60-days ago or

5612
M
N
ncoenNew Member
asked in  Building and Sharing Your Analysis
Aggregate event properties

Hi, I wanted to know if I can get the average or sum of an event property for some users.For example, if the event playSong has a property songDuration, i want to know the average song duration for a group of users.Thank you!

9662
Denis Holmes
Team Member
S
seunglee_bomappNew Member
asked in  Building and Sharing Your Analysis
how to I get user activity assessment from the specific hour of the day

Hello. I would like to find the unique users that do a specific event from 6PM in my time zone to 6PM in the next day.I would like to know the unique user count that apply for consultation in our business day which is from 6PM to 6PM.Thanks for your help in advance. 

7942
Saish Redkar
Expert
N
nadjareNew Member
asked in  Building and Sharing Your Analysis
Can I track user sessions without any events?

Hello everyone,I’ve defined the key events of my application as Amplitude events.Now, I want to know in which sessions, none of the created events have been triggered to inform customer success to look into these. The goal is to have 100% of user session include at least one key event. Is there a way I can display these sessions on Amplitude? 

4833
ning.chang
Team Member
A
arturodiazNew Member
asked in  Building and Sharing Your Analysis
Issue with Time Spent per User analysis

Hi all,I am having an issue during the last two weeks where I experienced that my Time Spent per User and User Sessions went down to zero while the DAU is still showing the users on the platform. Looking at the Session duration configuration I found that no limit (minutes) was set and no related to any starting/ending event.Does anybody know whether it might be related or a hint on what could be going on?Thank you in advance. EDIT: Doing a deeper research, I’ve found that the SessionID is -1 since that. Looks like the session ID is not being set by Amplitude, or does it related to the segment integration?

4093
A
D
donald dNew Member
asked in  Building and Sharing Your Analysis
[Dashboard REST API] How to select 'exact order' option on Funnel analysis?

Hi, I am trying to use Funnel Analysis(https://amplitude.com/api/2/funnels) on Dashboard REST API. According to the API document, it seems that I can set the ‘mode’ parameter where I could select either ‘ordered’ or ‘unordered,’ which seem equivalent to the options ‘this order’ and ‘any order.’ However, I could not find how to choose the ‘exact order’ option on API. Is there any way to implement ‘exact order’ via dashboard rest API? 

4393
D
N
Conversationalist
NilsConversationalist
asked in  Building and Sharing Your Analysis
Fraction of users that perform an event each day of the week

What’s best practice for finding the fraction of users (who perform event A) that perform an event A (at least) once every day of the week?I have tried a solution ​​​​​​to use a Segmentation chart with two segments:Users who performed event A >= 7 times any time in each week Users who performed event A >= 1 time any time in each weekOn the left hand side I chose Any Active Event,using this formula: %: UNIQUES(A1)/UNIQUES(A2),with frequency weekly.My understanding is that this will give me the fraction of event a users that performed event A >= 7 times of the users who have performed event A >= 1 time. However, the “in each” option will include user who performed event A at least X times during each chart interval, which does not met my intended wish to guarantee that each user in segment 1 have performed event A at least once each day, for example a user would also be included if they performed the event 5 times on Monday and 2 times on Saturday...In short, is there a way i

9574
belinda.chiu
Team Member
D
dmaltzanNew Member
asked in  Building and Sharing Your Analysis
Events by unique group

Each of my users has a property called orgKey which is just what organization they are part of. I want to make charts showing how many unique orgs triggered a certain event over time. Can somebody help me figure out how to do this? Thanks in advance

4312
D

Recent Tips & Tricks

Terms & ConditionsCookie settings