Skip to main content

Building and Sharing Your Analysis

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

  • 927 Topics
  • 2,396 Replies
927 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

2840
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 

1900
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

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

316
lars
Conversationalist
1 day 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

22
L
3 days 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

20
L
3 days 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? 

51
Jacenda Davis
Team Member
3 days 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. 

110
L
3 days 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?  

60
J
6 days 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?

30
K
6 days 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

131
B
Conversationalist
10 days 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

3276
nloutre
10 days 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

226
eddie.gaona
Team Member
13 days 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 …  

295
T
Team Member
14 days 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 

70
E
Novice
14 days 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?  

111
Yuanyuan Zhang
Team Member
20 days 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?

140
M
20 days 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 . 

260
P
25 days 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

271
Jacenda Davis
Team Member
26 days ago
M
Madison HornerNew Member
asked in  Building and Sharing Your Analysis
View avg # times a user has performed an event each month

Hi, I’m trying to view the average # of times a user has performed an event each month since they joined the platform. It would be great to see this for multiple events each month. Allowing me to select the events I’m interested in seeing would be great.  

241
sydney.koh
Team Member
26 days ago
S
Snigdha MishraNew Member
asked in  Building and Sharing Your Analysis
Correctly filtering custom events

I have created custom events, but when I try and filter live sessions by those custom events, I don’t see them - it’s blank.How do I ensure I see custom events filtered out correctly? 

180
S
26 days ago
john.cutler
Team Member
john.cutlerTeam Member
posted in  Building and Sharing Your Analysis
Event-Based Analytics (Video and short knowledge checks)

I’d love your feedback on this 12 minute introduction to event-based analytics! Can we do better to make the concepts stick? What worked? What didn’t?Making the transition to event-based analytics can require a shift in thinking -- especially if you are used to working with entity-based data. To get the most of out Amplitude, it is important to understand the interplay of events, event properties, users, and user properties.In this video you will learn how to:Use different colored stickies to understand how Amplitude works Differentiate between events, event properties, and user properties Determine when a user property update will be query-able Read Amplitude queries like sentences See a user’s event stream using User Lookup Describe the difference between entity-based and event-based analyticsPlease feel free to pass along your feedback.  

25716
K
1 month ago
U
Uri RonenNew Member
asked in  Building and Sharing Your Analysis
User Profile Api EU Residency endpoint

Hi there! I’m trying to access the User Profile API but with no success.According to the documentation there is a single endpoint to the standard serverhttps://profile-api.amplitude.com/v1/userprofileHowever, I need to access the EU residency server but cannot find the endpoint to do so.I’m able to successfully access the User Privacy API EU Residency endpoint with no issues.How can I use the User Profile API using an EU endpoint?Thanks in advance :)

2623
Rune Andersen
Well-Versed
1 month ago
S
Scott.leeNew Member
asked in  Building and Sharing Your Analysis
server side rate limit question

Hello, I’m Scott.I’m sending events to Amplitude from a Spring server.The library I’m using is implementation("com.amplitude:java-sdk:1.12.3").I’d like to know the rate limit.😊

161
J
Experienced
1 month ago
Svitlana
Novice
SvitlanaNovice
asked in  Building and Sharing Your Analysis
EU Amplitude integrations

Hello! Is there a place where I can see EU Amplitude integrations? I’m especially interested in the integration with Mailchimp and Databricks. I found this documentation link but I suspect not everything is relevant for EU version. Thank you!

292
Svitlana
Novice
1 month ago

Recent Tips & Tricks

Terms & ConditionsCookie settings