Building and Sharing Your Analysis

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

  • 849 Topics
  • 2,263 Replies

849 Topics

Amplitude Admin
Community Manager
Amplitude AdminCommunity Manager
posted in  Building and Sharing Your Analysis

CSV Export Contains Quotation Marks or Leading Spaces - WHY?

Hi Amplitude Community!We would like to provide context about the quotation marks or leading space in CSV exports. Our engineering team modified exported CSVs to include additional quotation and tab characters in front of all values as a preventative measure for a security risk known with CSV downloads (details here). Attackers can potentially use a formula to inject false data or leak data. And in order to prevent formula triggering cells from running, our engineering team revamped our CSV exports by prefixing quotation and tab characters in front of all values.With that being said, while that security issue remains, we received feedback from customers who said that they were willing to take that risk. Therefore, we implemented a way to export CSVs from Amplitude without any characters in front for those users. If you are willing to take that risk as well, you can enable the feature to remove the spaces in your CSV in your Org Settings section on the Profile page. You can scroll down

0
Amplitude Admin
Community Manager
9 months ago
Amplitude Admin
Community Manager
Amplitude AdminCommunity Manager
posted in  Building and Sharing Your Analysis

Currency Conversion at Amplitude

Hi Amplitude Community, Amplitude currently does not support currency conversion. If you receive revenue in different currencies, then we recommend normalizing to a single currency before you send us revenue data. Amplitude logs the exact revenue value sent to us and treats it as a numerical value (not a currency value). By default, the currency sign we display in the dashboard is the dollar sign, "$".You can change this display under Organizational settings > Projects > Currency Display. Please check this doc for more information: https://help.amplitude.com/hc/en-us/articles/15581410157339. NOTE: Changing the currency display does not modify nor convert the underlying data. ----- please give this post a thumb-up if you find it helpful! This will help us know what content we should publish in the future :) -----Amplitude Team 

0
Amplitude Admin
Community Manager
9 months ago
Amplitude Admin
Community Manager
Amplitude AdminCommunity Manager
published in  Building and Sharing Your Analysis

Welcome to the building and sharing your analysis forum!

Learn, ask questions, and help others use and build Amplitude charts to gain valuable insights! This is where you can ask and get feedback on questions such as: ✅ How can I calculate DAU/WAU?✅ How can I see the distinct count of devices for users?✅ Why is the conversion rate in my Conversion chart higher than the conversion rates in my Conversion Over Time Chart?✅ How do I calculate the bounce rate?✅ How do I look for users who did not perform an event? Helpful resources: ❓Working with charts: getting started with our charts, advanced topics and semantics of our charts, FAQs on specific charts❓Organizing and sharing your charts: collaboration within your team, and sharing analyses outside your organization❓Advanced analysis tools: cohorts, account-level reporting, cart analysis, sampling, and more❓Amplitude Academy course: Getting Started with Analytics❓Amplitude Academy course: Increase Data Use across your Organization with Amplitude's Collaboration FeaturesStill have questions? Post

14260
Amplitude Admin
Community Manager
1 year ago
D
Dave RuziusNew Member
asked in  Building and Sharing Your Analysis

User activation - Executing 3 of a set of 10 possible events

Hi,we have a definition of an Activated User being that this user has executed ANY 3 of a set of 10 defined event within lets say within a week. The timing is not to important here.I have tried custom events, cohorts and segmentation but I don’t seem to be able to define the execution of 3 events of a defined set of events.Ideally I would build this as a cohort because we have an additional definition of an engaded user and that will be a percentage Activated users that execute a particular event more than x times.My current struggle is with the definition of an Activated user.Help?Thx so much!SalsitaDave Ruzius   

3
Saish Redkar
Expert
8 hours ago
K
Kristine GloriaNew Member
asked in  Building and Sharing Your Analysis

Unable to access previous projects

Hello,I just logged into Amplitude to find my entire dashboard/workspace completely wiped out. I no longer have access to any of my previous projects or spaces. In addition, all of the team members from my organization are no longer listed under “organization settings.” Was there a product change to the free version that would have caused this? Thank you,Kristine

3
Esther Trapadoux
Community Manager
22 hours ago
T
TetianaNew Member
asked in  Building and Sharing Your Analysis

Our software product on customers' own domains

Hi. Our product is set up in a way that after the initial onboarding on our domain, the customer sets it up on their own domain as a subdomain. For example the customer xyz sets up our product as e.g., product.xyz.com.Is it possible to configure Amplitude to gather data from numerous subdomains, each representing a different customer, and then present the combined analytics on a single dashboard?I would be grateful for your help.

2
T
1 day ago
E
EvgeniyaNew Member
asked in  Building and Sharing Your Analysis

Reverse "Save onto charts"

I´ve applied the filter to the dashboard I own and then proceeded with “Save onto charts” - hence the filter was applied to all my existing charts.How do I remove this filter that is now applied to all the charts on my dashboard?

1
Thao Nguyen
Team Member
3 days ago
A
Annabel StanleyNew Member
asked in  Building and Sharing Your Analysis

Optional funnel steps not adding up

I’ve created a funnel with an optional step, however the number of users who are in the funnel after the optional step is higher than the number of users at the start of the funnel. It seems to be counting some users going down both routes. Can someone explain what is happening here? Screen shot below:  

1
Y
Team Member
6 days ago
G
Grégoire RoquetteNew Member
asked in  Building and Sharing Your Analysis

Evolution of a 5 day Revenue LTV over time

Hey guys,  I’m trying to create a chart to visualise the evolution of the 5 day LTV generated by clients over time. I have created a cohort for customers who subscribed the same week. I would like to plot the 5 day LTV of the cohort week 1, then the 5 day LTV of the cohort week 2… On the x-axis would be the cohorts (from week 1 of subscription until week n), and on the y-axis their 5 day LTV.  Any ideas how I could do this ?  Thanks !  Greg

6
Anthony
Peer Moderator
9 days ago
S
Conversationalist
sanchitConversationalist
asked in  Building and Sharing Your Analysis

How is session length calculated ?

We have just implemented 5 tracker, but still app has lot of features where trackers are not implemented.Does the session length and hence average session length per user, take the time into consideration of a scenario when user is still using the feature( using the app) on which trackers are not yet implemented?

1
Saish Redkar
Expert
10 days ago
A
Alex EspinosaNew Member
asked in  Building and Sharing Your Analysis

How can i look up for churn users who did not use the app for XX number of days?

I want to run analysis on my churned users.I’m trying to create a segment/audience for users who did not use my app for 14 days or more since the launch of the app.What would be the best approach for this?

3
Saish Redkar
Expert
10 days ago
M
Matthew SiaNew Member
asked in  Building and Sharing Your Analysis

What is the best way to create a segment/cohort that tracks accounts with more than 1 unique user?

For example, I want to review all the accounts that have more than 1 active user. We have account_id and user_id properties on the events, but how do I filter out accounts that only have 1 active user_id.

3
eddie.gaona
Team Member
10 days ago
A
Andrew LeeNew Member
asked in  Building and Sharing Your Analysis

How does "completed within" and “earliest longest” work for funnels

I am confused around the logic around "completed within" and “earliest longest” for funnelsLet’s assume a funnel with the following criteria: A → B → C, and I set a conversion window of one houruser does A at 1pm A again at 1:30pm B at 1:45pm C at 2:15pmAnd I'm doing funnel analysis counting unique users. How would Amplitude analyze this funnel?Did they complete within 1 hour? I've tried reading the docs and am still very confused.Thanks!

1
dangrainger
Super Helper
10 days ago
R
Helpful Hero
roginatorHelpful Hero
asked in  Building and Sharing Your Analysis

How can you sum up group property values?

We’re a SaaS company and we have a Group Property (Account) for number of todos added by all the users within the Group (Account), eg:Account A Todos: 100 Account B Todos: 120 Account C Todos: 90How can I create a chart displaying the total number of todos for all accounts, eg 210? IE a sum of the values.Cheers, Andrew

6
Anthony
Peer Moderator
12 days ago
P
Philip TsienNew Member
asked in  Building and Sharing Your Analysis

Interpreting a Retention Chart Correctly

Hi all,Wanted to get confirmation that I’m interpreting this retention chart correctly. The way I’m reading this, the chart is telling me that:Over the past 4 weeks (time frame selected in the top right)… 5.22% of “New Users” (selected in “Starting event”) have completed “Any Active Event” (selected in “Then the return event”) in at least 3 out of 4 weeks (chart itself)One clarifying question: is this 5.22% the group of users that have completed any active event within any of the 3 out of the past 4 weeks (e.g. weeks 1, 2, and 4) or is it the group of users that have completed any active event in 3 consecutive weeks (e.g. weeks 1, 2, and 3)?Thank you for your help.

0
P
14 days ago
S
SusieCNew Member
asked in  Building and Sharing Your Analysis

Discrepancy between figures in a retention analysis and funnel analysis

I’m trying to find out what % of users who perform one action then complete a second action in the next 24 hours. I’ve tried to look at this in two ways: First is through a funnel analysis where the conversion window is 1 day, counting by unique users, which gives me 66%. Second is through a retention analysis measured as “return on (custom)” calculated by 24 hour windows, looking at day 0 retention. This gives me 80%. Both are looking at the same time period, with the same segment and the same events. Is anyone able to shed light here? Thanks!

1
eddie.gaona
Team Member
14 days ago
R
rich20509New Member
asked in  Building and Sharing Your Analysis

Could Someone Give Me Advice on How to Implement Amplitude for Mobile App Tracking?

Hello there,As I am working on implementing Amplitude for tracking analytics in our mobile application. I have gone through the documentation and set up the basic tracking, but I am looking for some advice and best practices from those who have more experience with Amplitude.Specifically, I would like to know aboutWhat are some recommended practices for tracking events in a mobile app? Are there any common pitfalls to avoid?How do you recommend identifying and tracking users across sessions and devices for a seamless user journey analysis?When is it appropriate to use custom properties, and how can they be effectively utilized for deeper analytics?Also, I found some help from this too: https://medium.com/takodigital/implement-amplitude-on-your-mobile-app-cbf7bf1a9610infoWhat are the best practices for managing data retention and ensuring user privacy compliance, especially with recent regulatory changes?Are there any tools or platforms that integrate particularly well with Amplitude fo

0
R
14 days ago
D
DannyNew Member
asked in  Building and Sharing Your Analysis

Chart API does not return series labels

I have integrated with the get chart API GET /api/3/chart/:chart_id/query however the response returns the series labels as 0,1,2,3 and not the labels that I see when viewing the chart. This means I don’t know what the data refers to when using the API. Is this the expected behaviour?Response:"seriesLabels": [0,1,2,3]Is there an alternative way to automate the retrieval of csv exports that are available when manually viewing a chart?

5
A
15 days ago
L
Helpful Hero
liukaichiHelpful Hero
asked in  Building and Sharing Your Analysis

Average Number of Unique Items in an Array

I have a parameter that is an array of ID’s. I would like to understand the average size of this array between my events.  I saw this Distinct Property Values Per User option in the Segmentation chart.  This seems promising but I just want to understand if I’m reading the results correctly. I could see it one of two interpretations:Each array SET is a “value”. Therefore if I fire this event 3 times with 3 different array contents, then that would be 3 different values Each value within the array is counted as a distinct value, and so if there are 6 items in the array, then a user would appear as “6” for that day. I would hope it is #2, as it would help me solve my questions. But a clarification of how this works would be great. 

1
Thao Nguyen
Team Member
16 days ago
D
dotsNew Member
asked in  Building and Sharing Your Analysis

Visualizing user composition by frequency of visits (DAU/WAU/MAU)

Hi Amplitude community, I’m fairly new to the world of Amplitude but have been really enjoying the tooling so far :)I’m wondering if there’s a good way to visualize user composition by frequency of usage--e.g. building a pie chart that will show a breakdown of number of users who are active on a daily vs. weekly vs. monthly basis.I’ve been looking at the User Composition chart but it seems to only allow composition by user properties. Any advice/pointers would be greatly appreciated. Thank you!

2
D
16 days ago
N
Nobu TakenakaNew Member
asked in  Building and Sharing Your Analysis

How can I save filter with email and re-use for other event tracking?

 Than you so much for the community for help.<What I am trying to do>On Segmentation time trend feature, I am trying to track # of use except for our customer success.  <Challenge>Though it is possible to filter by email (remove email based on our company domain), we need to update filter every time when when new customer success.><Potential solution>I thought it might be possible to create “custom filter A” that consist of set of emails, and once I update that “custom filter A”, that applies to all the output that uses the “custom filter A”.  However, more elegant solution is also appreciated.

2
N
25 days ago
Q
Helpful Hero
quintinparHelpful Hero
asked in  Building and Sharing Your Analysis

How do I clear up events to remove this message?

 

1
Saish Redkar
Expert
27 days ago
D
Daniel FosterNew Member
asked in  Building and Sharing Your Analysis

Template Gallery charts won't populate

Brand new Amplitude user here. The template gallery seems cool; I swear I saw the charts populate for me previously. Now I just get some tips telling me to do the very thing (I think) I have already done.  Can anyone point me in the right direction for a solve?

1
Saish Redkar
Expert
1 month ago
Q
Helpful Hero
quintinparHelpful Hero
asked in  Building and Sharing Your Analysis

Calculating new purchasers – Can you tell me what I am doing wrong here?

My numbers aren’t aligning when I do a manual auditHere’s what I want to do: As stated in the tin, I want a simple graph of new purchasers. Whenever someone purchases something, I have an event called “CompletedPurchase” Here’s how I tried to achieve thisAnd here’s the cohort for Paying Users. What am I doing wrong?

9
Q
Helpful Hero
1 month ago
Anthony
Peer Moderator
AnthonyPeer Moderator
asked in  Building and Sharing Your Analysis

LTV $Revenue Charts still using old UI with cohorts on top?

Is the old UI (with events and cohort on the top instead of on the left) for the LTV charts just me?    

1
Saish Redkar
Expert
1 month ago

Terms & ConditionsCookie settings