Building and Sharing Your Analysis

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

  • 764 Topics
  • 2,065 Replies

764 Topics

D
dpommoNew Member
asked in  Building and Sharing Your Analysis

Measuring month on month retention

Hi,I’m trying to analyse month on month retention for different users groups (those who were existing users in the previous month and those who were new users in the previous month) but I can’t seem to create a chart which gives me this analysis and also can’t find anything in Amplitude documentation which supports this.Has anyone had any success in performing this kind of analysis with Amplitude charts? I thought I had found a way to do it by creating two user segments in a Segmentation chart, one segment is users who had performed the active event in each month and the second segment is users who had performed the event in the current month, offset by one month. Sadly this doesn’t give me the right numbers.Many thanks!

2
belinda.chiu
Community Manager
1 year ago
D
Novice
dadasaheb.patilNovice
asked in  Building and Sharing Your Analysis

How to get full chart result without pruning in REST API?

How to get full chart result without pruning in REST API?Currently I am using REST API like -curl -u API_Key:Secret_Key 'https://amplitude.com/api/3/chart/CHART_ID/query'by passing CHART_ID.When I am looking at chart table data it is showing full data and even when I am exporting csv data it is returning file with full data. But when I am doing same thing with REST API, it is pruning data and not returning full data.Can you please help me to get full data without pruning using REST API?

8
Denis Holmes
Team Member
1 year ago
W
wubekNew Member
asked in  Building and Sharing Your Analysis

URL grouping

Hello, i have a question about charts. I have data with search criteria, for example:type=home room_number=3 type=officeroom_number=2And i want to group this to count how many rows is with specific dimension, in this example type will be 2.

1
SheenaGreen
Super Helper
1 year ago
J
jsonNew Member
asked in  Building and Sharing Your Analysis

[Dashboard API] Is there a possibility of data being pruned when using Results from an Existing Chart

Hi there,I’m curious if there is a chance of data being pruned or failing to response due to massive chart data when using Dashboard API’s Results from an Existing Chart endpoint.I’m implementing a feature something similar to:a feature where users can view their profile’s page view counts. users can view who viewed their profile within the last few days, etc.So the chart I’ve created is basically page view events grouped by profile ID which will scale as more profile (users) are created.Thanks,

3
belinda.chiu
Community Manager
1 year ago
M
MohamedNew Member
asked in  Building and Sharing Your Analysis

make an automation when user don't connect after 3 days

Hi, i'm New and i figure out how to Send an email To user when he doesn't connect After a 3 days.Thanks 

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

What is the best alternative for measuring bouncerate on Amplitude?

Hey everybody im new here!I use Amplitude to measure how my A/B-test experiments are doing and one of the goals that I have for one of these A/B-tests is decreasing the bouncerate. I use now any active event as goal, but I’m not 100% sure if this is the right event to use. Since i’m not sure if an exit is also considered as an (active?) event. Anybody can help me with this?

2
A
1 year ago
E
EduardNew Member
asked in  Building and Sharing Your Analysis

Retention report - number of users on the graph and in the view menu do not match

Hi!While analyzing the retention report, I came across different data in the same report:1. Retention report says that there are 1,58% of users who came back on 26 day.The numbers of users at cohort is 1005, so there should be 1005*1,58%=16 users who returned at day 262. If i click at “view users” at day 26, i can see that there is only 3 users which is not the same as 16 at the previous bulletIf i download a CSV of that users and calculate retention, the number of returned users at d26 is 4 which is 0,32% from number of users at cohort (1232). Also number of users at cohort is different from the number on chart (1005 and 1232) Which data is correct? If I’m analyzing that report in incorrect way, tell me which one is correct. Thank you!

1
Yuanyuan Zhang
Team Member
1 year ago
C
chuckNew Member
asked in  Building and Sharing Your Analysis

Full list of country anywhere?

Hi, I have a rather simple question.Is there a full list of country names used on Amplitude somewhere?I want to map country names to ISO3166 country codes but some country names on Amplitude are different to the ones in ISO-3166. For instance, ‘Myanmar’ is the name in ISO-3166, but Amplitude uses ‘Myanmar (Burma)’. So it would be really helpful if there’s a full list of Amplitude specific country names. Do we have such?

4
Denis Holmes
Team Member
1 year ago
P
Well-Versed
pawanWell-Versed
asked in  Building and Sharing Your Analysis

amplitude is not working when adblocker is enabled

i am getting this error in console ..GET https://cdn.amplitude.com/libs/amplitude-8.17.0-min.gz.js net::ERR_BLOCKED_BY_CLIENT also i am able to send events to dashboard since the. ad-blocker extension is enabled, how do i make amplitude work when ad-blocker is enabled ? 

4
Jeremie Gluckman
Team Member
1 year ago
A
arainey1New Member
posted in  Building and Sharing Your Analysis

Figuring out your Aha! moment - how do you best do this?

Hi all,Really interested to know how important the concept of an Aha! moment is for companies using Amplitude? And also, how have you gone about figuring it out?Thanks!

1
Jeremie Gluckman
Team Member
1 year ago
L
Helpful Hero
liukaichiHelpful Hero
asked in  Building and Sharing Your Analysis

Querying OS Version

I would like to separate my users Android 5 and lower vs Android 6 and higher. Is there an easy way to do this in Amplitude?I tried to put “OS < Android 6” but when I broke it down in my User Composition it came up with all sorts of OS’s, including Android 10 and 11, so I know that doesn’t work. Is there something similar to Session Start where you can do a < or > comparison? 

1
Saish Redkar
Expert
1 year ago
MichaelK
Novice
MichaelKNovice
asked in  Building and Sharing Your Analysis

Question on "This order - any order" in the funnel analysis

Hey everyone, I’d appreciate your help! Trying to wrap my head around the difference between any order and this order in the funnel analysis in case of just two events.Based on the definition I expect the CR to be the same for the one-step funnel as there are no combinations other than Event A → Event B, but the result is different 

3
Thao Nguyen
Team Member
1 year ago
X
Well-Versed
xiaomeng.zhangWell-Versed
asked in  Building and Sharing Your Analysis

Get the specific value of all attributes of an event

Hi, Guys. We have a event. Get the specific value of all attributes of an event. This event has many properties including search term, color, model, etc.I want to know the specific value of each attribute under this event for each user. For example, 99% of users have a black color and a brandId of 1 

1
Denis Holmes
Team Member
1 year ago
H
hmbaaNew Member
posted in  Building and Sharing Your Analysis

amplitude applicationWillTerminate not working

Hello, I want to receive an event when the user forcefully shuts down the app. But, The code I wrote doesn't work.Isn't there a good way? code :     func applicationWillTerminate(_ application: UIApplication) {        print("applicationWillTerminate")        AmplitudeHelper.shared.sendEvent(eventString: "app_exit")}

2
Jeremie Gluckman
Team Member
1 year ago
V
vegardpeNew Member
posted in  Building and Sharing Your Analysis

How do I interpret the results from "any order" in a funnel analysis? Seems to be an issue with the count of the first event.

Problem descriptionI have a funnel consisting of three events, A,B and C. Consider the case where we have 100k events of A in a period of time. The funnel with “this order” specified will look something like this:Step                |          A              |               B                    |                CNum events.   |   100 000          | 90 000 (90% of prev)   | 72 000 (80% of prev, 72% of initial)Now, when I change the order to “any event”, I get something like this:Step                |          A              |               B                    |                CNum events.   |   150 000          | 142 500 (95% of prev) | 128 250 (90% of prev, 86% of initial)My first question is how the num events for A in the last funnel can be higher than 100k, when we only have 100k events for A in the first place?My second question is how to read the numbers on event B and C in the last funnel. Is it correct to assume:- 142 500 times, event A and B was in sequence, either A first or

2
Jeremie Gluckman
Team Member
1 year ago
L
Helpful Hero
luigi7upHelpful Hero
asked in  Building and Sharing Your Analysis

Account level analysis

Hi everyone, our customers represent companies with N users that in Amplitude we can see in the Accounts plugin. Every company we have appears with Group Name and Group Id.We want to do some simple analysis on account level where in each analysis we’d treat a company (group) as an individual user where if one user within the company does something we consider it. Here are some examplesNew Accounts signups on weekly bases Percentage of accounts who did an action X (where at least one user in the account did an action) Funnel conversion rates on account level (where at least 1 user in the account did the steps of the funnel) Segmentation of accounts by number of users registered, by our custom account propertiesI am not sure how to do those things in the Segmentation, Funnel or Retention modules ? Is any of the points possible in Amplitude at the moment or the analysis is limited to individual users within each account separately? Best regardsLuka

2
L
Helpful Hero
1 year ago
Jeremie Gluckman
Team Member
Jeremie GluckmanTeam Member
posted in  Building and Sharing Your Analysis

Correlation vs. Causation: Why Experiments Are the Next Big Thing for Data-Driven Leaders

Join us for this month's Coffee Chat, featuring Amplitude's very own Head of Product for Experiment, Wil Pong. Enjoy a coffee on us while chatting about product experiments.Share your questions and Wil will be posting answers here after the event! Here are a few to get us started: How would you leverage your data to run your experiments?  Where are you at with your experimentation journey? Have you just started or have you done this before?Note that to see the latest posts you need to refresh this page. We can’t wait to hear from you! 

9
Jeremie Gluckman
Team Member
1 year ago
Z
ZeinaNew Member
asked in  Building and Sharing Your Analysis

typeform and Airtable as data sources

Can I add my Typeform analytics to amplitude ? and can i track Airtable form submissions as a source to my analytics? 

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

Calculate Growth Rate in Amplitude

I had this case with a client, so wanted to share my formula for calculating growth rate in Amplitude:https://timothydaniell.medium.com/how-to-calculate-growth-rate-in-amplitude-analytics-a5cd8025145b

0
timothy-permutable
Super Helper
1 year ago
timothy-permutable
Super Helper
timothy-permutableSuper Helper
posted in  Building and Sharing Your Analysis

Day of the Week Analysis

I’m was excited to see Amplitude has implemented the ability to group events by Day of the Week, so I wrote a blog post about it!https://timothydaniell.medium.com/how-to-group-analyse-by-day-of-the-week-in-amplitude-e2b1913c7e1b

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

How to group events by day of week?

I want to show the average or unique value of an event in the last 90 days, but grouped by day of the week. So I can see which days have more-less activity on that specific event.Is this possible?

4
timothy-permutable
Super Helper
1 year ago
Andrew B
Andrew BNew Member
asked in  Building and Sharing Your Analysis

Can I only include events done within a repeated time frame?

I am wanting to look at events done within certain time windows every week. (We’re a church and I’m looking for events done within a certain time frame every week.) Is it possible to look for event that only happen on Sundays from 10-11 and 11:30-12:30?

1
Saish Redkar
Expert
1 year ago
R
rroestorfNew Member
asked in  Building and Sharing Your Analysis

PROPMAX

I’m looking for a formula that I would think would be called PROPMAX. Where PROPSUM gives you the sum of that property across all users and PROPAVG gives you the average value of the property per event, I want the maximum value of the property recorded on the event.There must surely be a simple way to do this…?

5
belinda.chiu
Community Manager
1 year ago
S
seunglee_bomappNew Member
asked in  Building and Sharing Your Analysis

[Dashboard API] Refresh the results from an existing chart

Hello.I use dashboard api to get the data in a chart in my amplitude workplace. One chart displays weekly active users, but when I access the chart using dashboard rest api, it did not refresh the data. Mostly, it sends the same set of data for more than two hours.Is there any way to refresh the data set when I call the api? Always thanks for you help.

2
Denis Holmes
Team Member
1 year ago
M
min.zhouNew Member
asked in  Building and Sharing Your Analysis

I set a property "timeUsed" to track user's duration on a specific page. Does Amplitude support to accumulate the duration for a unique user?

Hi team,I need to know a unique user’s duration on a specific page. I have an event track a unique user opening the page and used the property “timeUsed” to track the duration. There is a case that one unique user may open, close, open, close the same page multiple times, and I’d like to know the accumulated time of this unique user spent on this page. Just curious if Amplitude support this use case? 

2
M
1 year ago

Terms & ConditionsCookie settings