Building and Sharing Your Analysis

Learn, ask questions, or help others on the features that help build analyses in Amplitude!

  • 361 Topics
  • 1,024 Replies

361 Topics

S
Novice
sahanlakNovice
asked in  Building and Sharing Your Analysis

Retention based on hour of the day

Hello, I am trying to understand if a specific event’s engagement can have an impact based on hour of the day or a specific day (Mon - Sun). Is it possible to visualize this in retention chart?

4
S
Novice
11 months ago
J
jillCaseyNew Member
asked in  Building and Sharing Your Analysis

Reporting users meeting cohort definition for the first time within a day/week/month

I have a working definition of Activated users and have several charts showing our DAU/WAU/MAU or the CUMSUM of this cohort of users. I’d like to build a chart that specifically shows new activated users. I can do this manually by clicking on the cumsum(activated_users) for week A and create a cohort of weekA_ActivateUsers, then repeat for Week B, then create a new chart with a segment where the users are in A but not in B.But that is tedious and we want to set up a sync of only newly activated users to send an email out to. A sync won’t be reliable if I have to do this manually. Does anyone have an automated way to solve this? 

5
J
11 months ago
F
Novice
FouadNovice
asked in  Building and Sharing Your Analysis

Edit Dashboards and Charts owned by another User

Is it possible to edit existing Dashboard or Chart owned by another user? What are the limitation and possibilities. As an Admin, i need to edit existing charts and save them to the same dashboard.

2
F
Novice
11 months ago
patrick.conneely
patrick.conneelyNew Member
asked in  Building and Sharing Your Analysis

Grouping funnel by event properties

I have funnel that is based on users starting a piece of content (Event A) and users finishing a piece of content (Event B).I’d like to breakdown the funnel by an event property (content topic) so that I can compare the conversion rate of users when they engage with Topic Y vs. Topic Z but it doesn’t seem like I’m able to do this?

3
patrick.conneely
11 months ago
W
Wei JieNew Member
asked in  Building and Sharing Your Analysis

How are usage times calculated

How are usage times calculated? We saw a case where the usage time is 1 hr 30 min, but the user’s sign up time was 30 minutes ago. Also, the event stream duration is only 19 minutes. Could it be possible that the user was opening multiple tabs or windows?Just to clarify, the usage time is taken from user lookup → user profile. It is also consistent with the usage_time value from the dashboard api.

1
Saish Redkar
Expert
11 months ago
D
Novice
DanielNovice
asked in  Building and Sharing Your Analysis

Querying an array

Hi!Is it possible to check the first, last or any other position in an array in user properties during segmentation?For example: I can check if an array contains an element that is X. But how do I check if *the last element* in the array is X?  

2
D
Novice
11 months ago
N
nadjareNew Member
posted in  Building and Sharing Your Analysis

Amplitude Startup Roundtable

Hey everyone!My name is Nadja and I work at https://luminovo.ai/. We are a B2B SaaS Startup in the electronics industry.For our product analytics we are currently switching to Amplitude and building our best practices.I would love to share my experiences in building a great product and user experience with people who are also using Amplitude as a tool. Do any of you work in a startup (does not have to be SaaS or B2B) and would be interested in an exchange and maybe even forming a round table?Let me know! I am exciting to get to know you. All the bestNadja

0
N
11 months ago
M
Novice
matthiasrNovice
asked in  Building and Sharing Your Analysis

Event property sum by user

Hello, I’m trying to answer the following question : How much a user spends on average per week.It would be something like Total revenue / Users who did a purchase. I don’t find a way to do that in the Event Segmentation, what is the best way to achieve that. Thanks, Matthias

8
belinda.chiu
Team Member
11 months ago
ynadeem
ynadeemNew Member
asked in  Building and Sharing Your Analysis

Glob match an empty list []

I need a way to be able to tell the difference in Amplitude between when an event property’s value is an empty array/list “[]” vs. when the event did not receive a value for that event property at all. Doing the usual = (none) or set is (none) doesn’t work at telling them apart. I think I can use the glob match function but I’m struggling to figure out what the correct syntax would be since the square brackets are used as part of the glob match language. How do I escape them and write a glob match string that resolves to []? Basically, can I create a chart that can capture the difference between the events in the 2 screenshots below (specifically for the user property called “updates.EOC”)? Event where the property’s value is an empty array Event without the property at all Thanks in advance!

3
Saish Redkar
Expert
11 months ago
D
Novice
DanielNovice
asked in  Building and Sharing Your Analysis

Funnel Analysis discrepancy

Hi!I am struggling to understand why the Funnel Analysis is showing different numbers in the chart or if you look at the ‘show user paths’ in the same chart. I’ve attached two screenshots highlighting the different numbers. I don’t understand how ‘Any active Event’ → ‘view front page’ can show 37 290 (12.1%) in the chart, while ‘Start Session’ (a part of ‘Any Active Event’) → ‘view front page’ show 124 744 (40%)?Best regards,Daniel

5
Denis Holmes
Team Member
1 year ago
A
Novice
AsjaNovice
asked in  Building and Sharing Your Analysis

Weekly cohorts / unbounded retention: why o they get worse over time?

Hi everyone! I performed a weekly retention analysis (unbounded retention) based on Starting Event: Account Verified (user is assigned a known User ID) Return Event: Any Event  Now what I see is that older cohorts (we only launched the app on May 27th) show much better W1, W2, W3 etc. retention rates than the younger ones (especially with the cohort at the end of July there’s a big drop). What could be the reason? Is ‘any event’ a good return event at all, as it also includes end_session ?    Unbounded weekly retention by cohorts  Thanks in advance! Asja  

4
A
Novice
1 year ago
M
matthew.saxbyNew Member
asked in  Building and Sharing Your Analysis

Edit values displayed in chart hover over

Hi, I was wondering if its possible to edit the values displayed in the hover over in charts? Looking at the screenshot below it is defaulting to show a list of versions. Can I change this to display custom values here? 

1
MikkoKarvonen
Peer Moderator
1 year ago
S
stgo.larrainNew Member
posted in  Building and Sharing Your Analysis

Within Cohort and Retention

Hello, I’m struggling with a retention chart over a cohort that uses “any time within x days” filter. I’m trying to understand how frequent a user should perform a specific action (AddToWishList) in order to be retain as a user on the platform. So I built a cohort to capture all users that perform the metric on a weekly basis for the first month of usage. The above cohort is built according to the following filters (all with “And also” clause):users performed “AddToWishList” with count ≥ 1 time any time within 7 days of first use users performed “AddToWishList” with count ≥ 2 time any time within 14 days of first use users performed “AddToWishList” with count ≥ 3 time any time within 21 days of first use users performed “AddToWishList” with count ≥ 4 time any time within 28 days of first useThe above definition can be found at the following link: https://analytics.amplitude.com/vestua/cohort/pd31xt5 Then I built a retention analysis using the above cohort. I would expect to have a high

1
belinda.chiu
Team Member
1 year ago
M
Novice
matthiasrNovice
asked in  Building and Sharing Your Analysis

Event Segmentation - Group by (Group numerical values)

Hello, I’m trying to do an analysis on one event. For example, Add Item to Card and Group By ‘Age’.The issue I’m having is that I have a lot of Age values from 18 to 60 so something around 42 unique values. Which makes the analysis very hard.Is there a way to group the values by buckets for example 18-25 25-35 35-45 … ? So the analysis would be easier ?   Thanks a lot, Matthias

3
MikkoKarvonen
Peer Moderator
1 year ago
E
Novice
enwanneNovice
asked in  Building and Sharing Your Analysis

Has anyone found a good way to measure top active users?

Basically, I am trying to keep track of the top active users in my product. I want to know the top 5% of active users in any given week and I haven’t figured out a good way to do this in Amplitude. Anybody have ideas/tips to point me in the right direction?

3
Saish Redkar
Expert
1 year ago
T
tomashNew Member
asked in  Building and Sharing Your Analysis

Max between 2 numbers (FORMULA)

I’m wondering if there’s a way of achieving this : I have an event with a property that I need to SUM. I can do that with PROPSUM(A) without problem. The thing is that I need to add a cap to that SUM (maximum amount).I would need something like MAX(PROPSUM(A),cap), where I could get : The value of PROPSUM(A) if PROPSUM(A) < cap The value of cap if PROPSUM(A) > capI have tried to achieve this in many ways but I can’t find a proper way to do it. Thanks a lot for the help !

1
Saish Redkar
Expert
1 year ago
A
apo1397New Member
asked in  Building and Sharing Your Analysis

Average Time Between Sessions

Hi everyone !We’re trying to find the average time between sessions ie After how long does a user come back to the platform.I know this sounds just like retention but we don’t want that because from what I understood , and correct me if I’m wrong, the retention analysis tells that for all users who did event A on Day 0 , how many did event B on Day N .We’re just looking for time difference from when people log out (end session) and then log in (start session) and if possible per day.Would you recommend any of the following options : 1. Seeing the Time to Convert in a Funnel with first event as End Session & second event as Start Session2. N-Bound Retention analysis with the same event orderHope to hear back from the community !

4
jmagg
Team Member
1 year ago
A
ahoangNew Member
asked in  Building and Sharing Your Analysis

Filter event property (date) by relative date.

Hello,I’m trying to create user Cohorts for user’s who are Subscribers, Churned Subscribers, in a Free Trial, churched Free Trial users, ect.Due to constraints from Apple’s subscription service, this can only be accomplished by analyzing the `expiration_at` property of these events. These events are sent from Apple to our subscription management platform (RevenueCat) via web hook. RevenueCat then sends these events to Amplitude via web hook. For example, A Free Trial user would have to be inferred by the trial_started event whose expiration_at date is in the future.  I can’t find a way to filter an event by a relative date, i.e. “trial_started where expiration_at in the next week). It looks like amplitude allows me to filer by expiration_at but only by the specified values. I’ve attached a screenshot of how it’s down in MixPanel  

3
Saish Redkar
Expert
1 year ago
S
sonya_agNew Member
asked in  Building and Sharing Your Analysis

How to uderstand what % of the users perform an action every week?

Hello everyone,I am new to to Amplitude and I am trying to find a way to find What % of users in a segment, perform the action “X” at least once per week in the last year.Any suggestions how to do it? Thanks in advance!

1
Saish Redkar
Expert
1 year ago
D
Novice
DanielNovice
asked in  Building and Sharing Your Analysis

How do I duplicate a chart?

How do I duplicate a chart?The copy icon mentioned here (https://help.amplitude.com/hc/en-us/articles/231999267-Create-Save-Charts#copy) is almost never available (see attached screenshot). Is this a bug? Do we have to pay extra to be able to duplicate charts? Best,Daniel

8
C
Novice
1 year ago
R
rishi_New Member
asked in  Building and Sharing Your Analysis

Use of `domain` option

what is the significance of domain option in Amplitude_optionsamplitude.getInstance().init(amplitudeKey, id, AMPLITUDE_OPTIONS)

2
Denis Holmes
Team Member
1 year ago
S
sebastian.nordeNew Member
asked in  Building and Sharing Your Analysis

Device Id + browser size?

Hello dear community, Is there a way for me to figure out what the user browser size or screen resolution is through Amplitute? I was thinking this would be a value under Device Id but i’m coming up short when looking for it.

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

How to get raw data using Dashboard Rest API

Hi I am trying to get the raw data for an event using the dashboard rest api that Amplitude offers. I am completely new to Amplitude and REST APIs. I have an event that want to group it by two properties and get the raw data for lets say 3 days. The expected output in a csv format should look like below:" keywords; [Amplitude] User ID"," 2021-06-09"," 2021-06-10"," 2021-06-11"," vaccine; AhL67nr8JDA","0","0","1"," important themes; C1VzZXJQcm9ma","0","1","0"," broadband; agxzfnViZX","1","0","0"," oklahoma; Y2VyGSC1VzZX","1","1","0",where keywords and User ID are the two properties that I group by the data on. I see such a data in the breakdown table in Amplitude UI but don’t know how I can extract this data using the REST API.Any help is appreciated. 

4
M
1 year ago
J
jtambuntNew Member
asked in  Building and Sharing Your Analysis

Connecting events with the same event property value

I’m trying to figure out how I can link two events that share the same event property value. An example would be, I want to get the average time between an event ‘POST_CREATE’ with property {id: ‘some-unique-id’} and ‘COMMENT_CREATE’ with property {post_id: ‘some-unique-id’}. There are some other funnel charts I want to make that would need to tie these events in a similar way. I can specify a particular id if I use ‘where’ like so: But that will only give me the time for a particular post, not all of them.

3
P
1 year ago
J
joao-blueshipNew Member
asked in  Building and Sharing Your Analysis

Syncing Segments

Hi there, I’ve created a segment called “Non-developers”, to filter out events from my own team, and attached to my dashboard charts.The issue is that whenever I change something on the original segment, it doesn’t reflect to all of the other dashboard charts that I have, so I’m having to edit them manually one by one.Is there a better way to do this?I’m certainly doing something wrong.Thanks

1
Saish Redkar
Expert
1 year ago

Badges

Show all badges
Terms & Conditions