Skip to main content

Building and Sharing Your Analysis

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

  • 933 Topics
  • 2,402 Replies
933 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

2950
Amplitude Admin
Community Manager
1 year 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 

2160
Amplitude Admin
Community Manager
1 year 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

16381
P
2 years ago
D
Dagim TesfayeNew Member
asked in  Building and Sharing Your Analysis
Issue with Screen Replay in Android Application

I am currently integrating Screen Replay into my organization's new Android application and have encountered an issue. While the screen replays appear in the list, the videos themselves only display a loading component along with the touch interactions made by the user. Unfortunately, the actual UI elements are not visible in the video.To provide more clarity, I have attached a video demonstrating the issue.Could you kindly assist me in resolving this issue? Please let me know if you need any additional information or logs to help investigate further.  

80
D
13 days ago
M
Melanie BorinsteinNew Member
asked in  Building and Sharing Your Analysis
Best chart to use to determine if a feature has activated previously dormant users

Does anyone have advice on how best to see if a new feature has caused previously inactive or low activity users to become more active in your platform? The lifecycle chart doesn’t quite do this as there isn’t a single point in time I’m looking at as someone could perform this event at any given time since release. I’ve only been able to successfully do this by looking at each individual user stream and getting a general sense of their activity but as this feature gains more adoption, I won’t be able to keep up with the scale. 

211
Jacenda Davis
Team Member
16 days ago
Q
Quentin CNew Member
asked in  Building and Sharing Your Analysis
Exclude specific events by property not working - Warehouse-native

Hi,We're trying out the Warehouse-native solution to see if it's a reasonable option for our company.While creating Journey charts, we would like to use the "Exclude specific events by property" filter option but this doesn't seem to be working.Could be that we are missing something in the setup but whatever filter we are adding here isn't appearing in the SQL query.Any help would be appreciated!

100
Q
23 days ago
S
Sal BNew Member
asked in  Building and Sharing Your Analysis
Why is my public dashboard giving 500 errors when accessing anonymously?

Hi,I have the following dashboard public link but the charts don’t load with a 500 error if I’m not logged in: https://app.amplitude.com/analytics/share/7207c0b64c154e979afd7082980d6dd6When logged in, I can view the dashboard just fine. Is there some reason the link isn’t working anonymously for me?

80
S
24 days ago
V
Veronica MachicaoNew Member
asked in  Building and Sharing Your Analysis
Page engagement rate metric

Hey, anyone knows how to calculate page level metrics (keeping constant Page URL dimension).What I need to to build a table with:Page URL > Page viewed event > Engaged event > Page engagement rateThe page engagement rate is calculated as follows: (number of engaged events / number of page viewed events) * 100. However, I'm unsure how to calculate this in Amplitude. I’ve attempted various methods to implement this formula, but for some reason, the results don't align with the engaged/page viewed values when I use the calculator.Again the metric must be page level, not session or user level.Many thanks to anyone that can help

382
Jacenda Davis
Team Member
24 days ago
M
Megha NanjundaiahNew Member
asked in  Building and Sharing Your Analysis
Error: Failed to save chart.

Hi team. I have been trying to create event analytics and unable to copy/save the dashboard as I get the error failed to save chart. Could someone look into it provide an update on how to fix this issue? It has been happening for the last 24 hours.

100
M
1 month ago
L
Lucas MurataNew Member
asked in  Building and Sharing Your Analysis
Funnel chart: users not necessarily triggering first event

Hello Amplitude communityI would like to ask if there’s a way to achieve the following:Funnel analysis with 10+ events In this funnel, users may have different events in the funnel triggered as their first step (not necessarily the first event of the funnel, which I understand it usually needs to be triggered for an user to be considered part of the funnel) The analysis is under “in any order” The specific use case is for a funnel that can start with users loading the Home Page (first event) but they might also be redirected from an external website directly to events 2, 3 or 4 of the funnel, and I still would like to consider them as part of the funnel. In this case, it would be possible that there are more users triggering event 2, 3 or 4 than event 1.Not sure if this is something feasible. Segmentation analysis would work for my case as a way to not have the events 2, 3, 4 depending on 1, but this type of analysis only allows up to 10 events.Any thoughts on how I can do it?Thank you

173
jarren.patao
Community Manager
1 month ago
L
Lucas MurataNew Member
asked in  Building and Sharing Your Analysis
Create user segment that updates all project charts

Hello Amplitude teamUnderstand that we can create a default user segment that applies to all new charts created in a project. However, is it possible to create a segment that is applicable to all new charts and updates all existing charts inside a project to this new default user segment?In my case, I would like to create a segment based on an user property in which property values are often added and need to be filtered/updated. Hence, if it’s applicable only to new charts/analysis, it’s not practical since I would need to update the existing charts one by one.Thank you

111
E
Novice
1 month ago
lars
Conversationalist
larsConversationalist
asked in  Building and Sharing Your Analysis
How to use a propery of one event to filter users that did another event?

Hey, we're building an invoice approval solution. Users have multiple views like an inbox, an approval view, or an archive. Each view can contain multiple documents as todos: documents in your inbox, waiting for processing, open approvals, or all approved documents from the past in your archive.We believe that the number of documents a user has in each view is important context to understand behavior. For example, if you only have two approvals, then you probably don't search. But if you have 100+ documents in your inbox, then you probably search a lot.Our first idea was to attach these counts as properties to each page view event, but that would be too much load. So now we want to add a new event called dashboard_viewed that is being fired each time a user visits the dashboard, which also happens to be the first page visited after login.How can I combine the properties of the dashboard_viewed event with other event data, like page views?For example, I want to see how many searches (pa

986
lars
Conversationalist
1 month ago
A
Annabel StanleyNew Member
asked in  Building and Sharing Your Analysis
Rolling returning users cohort

I want to be able to create a cohort of returning users on a rolling basis. These would be users who do any event in the app, who had done the event ‘create an account’ on a previous day. I only seem to be able to create a cohort of users who had done the event before TODAY, not on a rolling basis so that I can see how many users on a given day were ones that had created an account on a previous day.Some example use cases of this:One of our partners sent out a marketing email last week, we want to see how effective this was at driving existing users back to the app. In our database we are able to see the number of users we had in a month, that had created their account in a previous month. We have seen a big increase in the number of returning users last month. We want to understand what brought them back to the app and what they did.Does anyone have any suggestions on how to do this? 

211
Jacenda Davis
Team Member
1 month ago
L
lslmNew Member
asked in  Building and Sharing Your Analysis
Data tables grouping broken

Hi,anyone else with broken Data tables? We have a report with multi level grouping. It works on the top level, but when we want to group a row by another property, it say only “No data”. It worked well until yesterday.Since then, we are not able see the data. It is not a problem with our ingestion, it doesn’t display anything from history and as I said, it worked well until yesterday.It seems like a bug. 

190
L
1 month ago
J
Jason JNew Member
asked in  Building and Sharing Your Analysis
Abnormal Traffic Causing Billing Issues from :"FacebookBot 1"

We've recently identified an urgent issue that requires immediate attention.Issue Description:We've observed substantial traffic from "FacebookBot 1" (over 95% of total traffic) . This traffic has shown abnormal growth recently, causing our usage to significantly exceed expectations My question is what is "FacebookBot 1" and how to disallow this bot’s scrawler behavior?  

180
J
1 month ago
K
kurtgnNew Member
asked in  Building and Sharing Your Analysis
Average count of events per user including users that never triggered the event?

In my app, I have an “ad_click” event. When I try to plot average events per user I see that I have 2 events/user on average:  But I know that only minority of users trigger this event, most users don’t click on ads. Here is percentage of active users that triggered it: So this means that, if we count in users that never triggered the event, the number of events per user will be much less than 2 and even less than 1, probably around 0.1-0.2.How do I make this chart?

110
K
1 month ago
V
Valentyn KryvoruchenkoNew Member
asked in  Building and Sharing Your Analysis
Issues with Amplite API

Hello! I’m new to working with such complex APIs in the marketing topic I am far from, but I’m trying to automate things for my company.What I need:I need to retrieve data of unique completed purchases by users in percentage (which is generally quantity of users that have successfully finished a purchase divided by quantity of unique users that have started the purchase). I know the period of time. I know the name of events. I understand which funnel I am working with. I have api key and secret key.What I do not understand and struggle with:What API should I use? AI Amplitude Assistant recommended me to use Dashboard REST API, especially Funnel analysis, but there are no details in documentation where to get funnel_id. And examples are not as complex as real-life ones (its a general issue for documentation as for me, because not all developers are of senior level). Also I tried to generate requests based only on specifying events and I get data that is very close to which I see on the

261
B
Conversationalist
1 month ago
N
Novita OliveraNew Member
asked in  Building and Sharing Your Analysis
Completely hiding historical data of specific user property in Amplitude

What is the process to fully conceal the past data of a particular user attribute in Amplitude, and could you provide an explanation of the problem related to this inquiry? But please underline that I don’t want the events that contain that user property to be deleted. I just want to hide the user property

3466
nloutre
1 month ago
J
Novice
Jasmine SmithNovice
asked in  Building and Sharing Your Analysis
Grouping step 2 in funnel but not step one

Hi all, I need a funnel chart where I need to group the second step in the funnel but not the first step.For example, imagine Event1 is a screen_view of a particular screen and Event2 is a button_tap. Imagine there are 3 different buttons a user can tap. I need to see the conversion of:screen_view (total) → button_tap (buttonA) 60% screen_view (total) → button_tap (buttonB) 10% screen_view (total) → button_tap (buttonC) 30%When I try to group by button name, I end up with all conversion rates being 100% because it is also splits the screen_view by button name. I have used a formula instead of a conversion as a work-around (%:UNIQUES(A)/UNIQUES(B)) but this loses the order of events and can change the resulting value.Is there a way to view this as a conversion? basically converting from one starting point to 3 possible end points? Thanks in advance!**edit, to be clear the button names are an event property, not a user property

1046
eddie.gaona
Team Member
1 month ago
A
Alex ChaniotisNew Member
asked in  Building and Sharing Your Analysis
BUG: Slack unfurling is broken again

Hello, I’ve seen this reported as “solved” on another topic, but it appears to be broken again …  

565
T
Team Member
1 month ago
E
Novice
Etai FiedelmanNovice
asked in  Building and Sharing Your Analysis
Deducting values from event properties

Hi everyone, I have an event which has a number of properties with different numbers (values).Is there a way to deduct the number within the property?For example an event called X with property Y equal to 10 and property Z equal to 5. Can I create a formula which does X property Y - X property Z, or essentially 10-5?Thanks,Etai 

360
E
Novice
1 month ago
S
Sofiia BrykNew Member
asked in  Building and Sharing Your Analysis
events are not displayed in the funnel analysis

HelloI have the following problem.I have added analytics for a new web funnel. The events remained with the same naming conventions. The only change is that I added funnel_id.When compiling funnel analytics, funnel_id=quiz-2 does not display any page except the very first screen. When switching to a specific user profile of a tester, these events are tracked and the user goes all the way through the funnel.What could be the problem?  

951
Yuanyuan Zhang
Team Member
1 month ago
M
MJ SteenbergNew Member
asked in  Building and Sharing Your Analysis
World Map / Geolocation visualisations for App Opens

Hi there,We’re on a scholarship plan.Is there functionality in Amplitude to create World Map / Geolocation visualisations, besides for the un-editable artifact on the realtime dashboard? I want to see where users are when they open the app for the first time, and a World Map view for App Open events with historical count=1 would be great. I can see these values in the realtime event stream for each user.Is it possible to export Long, Lat values from Amplitude?

350
M
1 month ago
P
Puneet SrivastavaNew Member
asked in  Building and Sharing Your Analysis
Setting up dashboard for google and facebook ads

i integrated facebook and google ads account into amplitude, but i need your help related to setting up dashboard , please help me to do this . 

460
P
1 month ago
B
beckybugNew Member
asked in  Building and Sharing Your Analysis
Funnel analysis - Calculate time to convert between first event and last event instance

I’m trying to do a “time to convert” funnel analysis which looks at the duration between the first instance of an event and the last instance of an event. This is kind of a proxy for session duration, or dwell time, but it’s more flexible for our use case because it can span multiple sessions (as they’re defined by Amplitude). When I try to do this as a funnel showing time to convert, it just gives me the time to convert between the First event and the next instance of that event. How can I calculate the time between the First and Last occurrence of that event, with an unknown number of other events (including that same event) happening between those two bookends?   More examples: First event occurrence found (none prior to this in the timeslice) Here, in between the first and last event, any number of events could happen, including more of the same, for an undetermined amount of time.  last event instance found (none after this in the timeslice)For this case, the correct answer to “ti

491
Jacenda Davis
Team Member
1 month ago

Recent Tips & Tricks

Terms & ConditionsCookie settings