Skip to main content

Building and Sharing Your Analysis

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

  • 902 Topics
  • 2,356 Replies
902 Topics
J
Jack GindiNew Member
asked in  Building and Sharing Your Analysis
How does Amplitude Count New Revenue

Hey there, so we are in the process of conducting our LTV analysis and noticed that Amplitude is consistently claiming new customer cohorts  are bringing in ~30% more revenue than what we see on Shopify. We’re not sure why this is happening. Our hunch is that it’s tagging returning revenue as new. It’s either doing this because there’s a bug or maybe Amplitude considers someone new after a certain period of time. So if they purchased over a a year or something ago and then purchased again they’ll consider that person new. Anyone else seeing something like this? Any insight helps! Thanks. 

0
J
1 month ago
L
LouisrbrtNew Member
asked in  Building and Sharing Your Analysis
User segment from CSV

Hi there, I would like to create and save a user segment but it is composed of 670 different users (ie. distinct user_id).Should I enter each of the 670 user_id manually in the interface or is there is a way to do a “bulk import” or create this segment automatically (eg CSV upload) ?  Thanks !

2
Daniel Foster
1 month ago
A
Anita TNew Member
asked in  Building and Sharing Your Analysis
Using data tables to calculate email clickthrough rate

Hi, using Data Tables for the first time and would love to get some extra pairs of eyes on my work.Use case:Every time we send an email, we fire an event called notifications:send with event properties of notificationId and notificationType When a user clicks an email, we fire an event called notifications:clicked with event properties of notificationId and notificationTypeI am trying to get email clickthrough rate, defined as “for each email that is sent, is it clicked within 7 days”?I set up a conversion metric to calculate this.Does it look like I’ve set this up correctly?

2
Manabu Takeya
Team Member
1 month ago
N
nikatsapienNew Member
asked in  Building and Sharing Your Analysis
Total event count throughout time

Hi team!I’d like to get something that seems fairly simple, but I’m unable to figure out. How can I get the total count of the occurrence of a certain event type across a time period (ideally since we first started using Amplitude)? I can only find a chart that has per-day breakdowns, but I would like just an aggregate. Thanks for any help!Nik 

1
Saish Redkar
Expert
1 month ago
tracy.guo
Team Member
tracy.guoAmplitude Support
posted in  Building and Sharing Your Analysis
[Funnel Analysis] Conversion vs Conversion Over Time

The Funnel Analysis chart is a powerful and popular chart in Amplitude. There are many different features in the Funnel Analysis chart and today I want to talk about a common question that we get about the differences between the Conversion funnel chart and the Conversion Over Time funnel chart: Why is the conversion rate in my Conversion chart higher than the conversion rates in my Conversion Over Time Chart? The Conversion funnel chart (bar chart) performs a different analysis from the Conversion Over Time chart (line chart). Let’s look at this 2 Step funnel as an example:This Conversion funnel chart shows us how many unique users performed Step 1 (Favorite Song or Video) in the last 30 days, and of those users, how many of them converted at Step 2 (performed Purchase Song or Video) within 1 day of performing Step 1 and how many of them dropped off at Step 2. Note that the Conversion chart counts unique users. This means that if a user converts multiple times within the last 30 days,

4
C
1 month ago
G
godsenalNew Member
asked in  Building and Sharing Your Analysis
How to Calculate Average Events per Post per User in Amplitude?

I’m trying to calculate the average number of times a specific event (let’s call it Event A) occurs per post for each user in Amplitude. Each occurrence of Event A has an associated article_id property that identifies the post. When I use Event Segmentation and group by article_id for Event A, I can see the average number of Event A per post, but not the average across all posts for each user. Any detailed steps or guidance on how to achieve this would be greatly appreciated!  

0
L
1 month ago
M
Conversationalist
Mauricio.CastroConversationalist
asked in  Building and Sharing Your Analysis
Calculating on Data Table

Hi! I use formulas on graphs and they work like a charm! Now I want to calculate the following on the table element: You can see that my Store #1 is selling cars in different values. I want to sum all of the profit from Store #1 so I can group by different stores and see the profit per store. How'd I do it? 

1
Jacenda Davis
Team Member
1 month ago
M
Conversationalist
Mauricio.CastroConversationalist
asked in  Building and Sharing Your Analysis
Using Formula On Data Table

Hi! I use formulas on graphs and they work like a charm! Now I want to calculate the following on the table element: You can see that my Store #1 is selling cars in different values. I want to sum all of the profit from Store #1 so I can group by different stores and see the profit per store. How'd I do it? 

0
M
Conversationalist
1 month ago
Anthony
Peer Moderator
AnthonyPeer Moderator
asked in  Building and Sharing Your Analysis
Ranges for PROPSUM values

RANGES for Frequency The Ranges feature works great. ⭐️ Here’s an example. Segmentation: Song Plays measured as Frequency with custom bucket size of 5.  PROPSUM The Propsum feature also works great! ⭐️ Here’s an example. Segmentation: PROPSUM of points by user   PROPSUM Ranges Is there a way to count my users by the sum of their points in ranges ❓Example: Sum of Points - Point Range measured as Frequency with custom bucket size of 10,000 pts0-10,000 pts:            12,000 users  10,001-20,000 pts:   20,000 users  20,001-30,000 pts:   15,000 users   Thanks,  Anthony

4
B
Community Manager
1 month ago
S
SanginNew Member
asked in  Building and Sharing Your Analysis
Segmentation chart : I would like to know the conditions for New, Resurrected, and Dormant in the lifecycle chart.

Hello everyone!  I am trying to use the Segmentation chart to view the metrics we use internally as a time series. For this, I need the data for New, Resurrected, and Dormant users from the lifecycle chart. Could you please assist me with how to define the conditions for these three types of users in the Segmentation chart? Thank you!

1
Yuanyuan Zhang
Team Member
1 month ago
D
Dominique Burgunder-JohnsonNew Member
asked in  Building and Sharing Your Analysis
Can I collapse all of the rows in the table of a segmentation chart?

I am viewing a table in a Retention Analysis chart that has hundreds of rows, including “child” rows nestled below “parent” rows. Is there a way that I can collapse all of the “child” rows that are nestled below each “parent” row at once? Right now I seem to only be able to collapse them by clicking the down arrow to the left of each parent row, but doing that one by one is tedious and taking a lot of time for a table with hundreds of rows.

2
L
2 months ago
Phoenix
PhoenixNew Member
asked in  Building and Sharing Your Analysis
How do I add default event properties to a custom event?

Hello, everyone.I’m start to study Amplitude for the integration with my project.I have trying to add default event properties such as PageDomain, PageTitle, PagePath, etc. to my custom event.I have using default events such as PageViewed, Start Session, etc. in my project, but from my requirements I need to define custom event.I’d like to use default properties such as PageDomain, PageTitle, PagePath, etc. in my custom event.What’s suggestion to add these properties to my custom event ?I hope to anyone help me for this.Thank you.

3
J
2 months ago
M
Maciej ZiolkowskiNew Member
asked in  Building and Sharing Your Analysis
Looking for resources on web analytics best practices

Hi all,would anyone be so kind to point me to free resources (e-books, articles, video tutorials) on web analytics best practices?I’ve already found some related topics in this forum and got to know about playbooks and guides released by Amplitude. But I am also interested in any documents that other web companies have released. I’d be very grateful for useful links 🙂.Cheers,Maciej

1
L
2 months ago
A
Adolfo RBINew Member
asked in  Building and Sharing Your Analysis
[DASHBOARD API] Funnel analysis - weekly results

how can I get consolidated results by week or month instead of overtime by day?Im using dashboard apis to create a funnel analysis

4
liuaud
Well-Versed
2 months ago
Oliver
OliverNew Member
asked in  Building and Sharing Your Analysis
Is there a way to filter properties by character length?

I have an event that collects freeform string inputs from users. A lot of users will input really short responses (eg. less than 3 characters). I want to exclude all of those short length results in my group by analysis. Is there any way to to do this?

1
Y
Team Member
2 months ago
I
India Partner NetworkNew Member
asked in  Building and Sharing Your Analysis
Tracking entry points from multiple resources

We have a page that lists resources and one can come to the page through multiple entry points which are:Through an email notification Any other page on the platform From their Home page: Dashboard that they see when they login Search Results Page: Once they perform the search and any matching resource is listed, they can click on the resource and asked to login, if they are not. Once they perform the search and any matching resource is listed, they can click on the resource and directly view the resource. From social mediaHow do I then track the multiple entry points and understand how did the user reach the resource page to understand the user behaviour? Can I track it using UTM for social media and referrer for some other page on the platform, however this will not help me filter the page viewed event successfully. Please advise. 

2
I
2 months ago
I
India Partner NetworkNew Member
asked in  Building and Sharing Your Analysis
Tracking entry points

We have a page that lists resources and one can come to the page through multiple entry points which are:Through an email notification Any other page on the platform From their Home page: Dashboard that they see when they login Search Results Page: Once they perform the search and any matching resource is listed, they can click on the resource and asked to login, if they are not. Once they perform the search and any matching resource is listed, they can click on the resource and directly view the resource. From social mediaHow do I then track the multiple entry points and understand how did the user reach the resource page to understand the user behaviour? Can I track it using UTM for social media and referrer for some other page on the platform, however this will not help me filter the page viewed event successfully. Please advise. 

1
Saish Redkar
Expert
2 months ago
J
joel.spiroNew Member
asked in  Building and Sharing Your Analysis
How can you show Average daily values of a chart in a dashboard?

​Lets say I have 3 segments showing the uniques of a given event, and I want to show on a dashboard the daily average uniques of each segment during the given time period (in this case 30d).In the line chart I can chose Average Values to get those metrics:However if I show this chart in the dashboard I can not get the average metrics.In the KPI options its not available:IF I change to the table view I can get the current day, and the previous day but not the Average.I could try change the chart to a Bar chart in order to force only have one value for the period, BUT that would no longer be the average during the period but rather the deduped uniques during the total period. I can not think of a formulario or rolling avg o window to get Daily average uniques for the given time period as a single metric to then show on a dashboard.For now the option is to have the Average value as the metric on the Line Chart, have the line chart on the dashboard, and the user then needs to enter into th

3
U
2 months ago
Oliver
OliverNew Member
asked in  Building and Sharing Your Analysis
How do I format metrics to be whole numbers (remove decimals/round up)?

I have a metric that has decimals and want to round it to a whole number. Couldn’t find any formula or setting to do so. Any tips would be appreciated

1
eddie.gaona
Team Member
2 months ago
Maria Soboleva
Maria SobolevaNew Member
asked in  Building and Sharing Your Analysis
Old User Property is pulled to our projects with Ampli Wrapper

Hello,I am experiencing an issue with the Ampli Wrapper in our Swift and Kotlin projects. We set up Amplitude Data and installed the Ampli Wrapper successfully.We had to rename one of the User Properties from createdAt to created_at to avoid a conflict with our projects’ properties. However, when we pull the updated data on the client sides, the property still appears as createdAt despite being correctly named in the Amplitude workspace.Screenshots are attached for reference. Could you please assist us in resolving this issue?Thank you!

1
eddie.gaona
Team Member
2 months ago
D
Digital WorkplaceNew Member
asked in  Building and Sharing Your Analysis
Can I exclude weekends from my charts? Any updates

Are there any recent updates () - will a function or other method be implemented to exclude weekends directly from the charts? It would be incorrect to exclude weekends using a filter applied to events, as values for that day on the chart are simply zeroed out, further lowering the average indicator.Therefore, excluding the necessary days directly from the chart would be the optimal solution.

1
Saish Redkar
Expert
2 months ago
M
Maciej ZiolkowskiNew Member
asked in  Building and Sharing Your Analysis
Share resources - analytics best practices

Hi all,would anyone be so kind to point me to free resources (e-books, articles, video tutorials) on web analytics best practices?I’ve already found some related topics in this forum and got to know about playbooks and guides released by Amplitude. But I am also interested in any documents that other web companies have released. I’d be very grateful for useful links 🙂.Cheers,Maciej

1
B
Community Manager
2 months ago
P
Conversationalist
peckerbidsConversationalist
asked in  Building and Sharing Your Analysis
Make a funnel showing percentage of users who convert within and beyond 30 days

I currently want to make a funnel chart between event A and event B. I want to see the percentage of users who complete the funnel within 30 days of performing event A, as well as percentage of users who complete the funnel, but beyond 30 days of performing event A. Is this something possible to do? Thank you!

3
liuaud
Well-Versed
2 months ago
N
nadjareNew Member
asked in  Building and Sharing Your Analysis
Can I exclude weekends from my charts?

Hello everyone, I work for a B2B company and we want to track the monthly development of events by using timelines (see screenshot). Is it possible to exclude the weekends?Thanks for you help. 

13
D
2 months ago
P
Paul KimNew Member
asked in  Building and Sharing Your Analysis
about retention chart

  I do not understand the sentence "Dividing 55,752 by 137,586 gives us a Day 3 retention of 63.8%," presented as the formula for overall retention in the document <How the Retention Analysis chart calculates retention> provided by Amplitude. Dividing 55,752 by 137,586 results in 40.5%, but it is stated as 63.8%. It seems that the denominator for the retention calculation varies for each day. If so, what is the reason for the varying denominator values in the overall retention for N-day retention?

0
P
3 months ago

Recent Tips & Tricks

Terms & ConditionsCookie settings