This article covers some frequently asked questions about the Event Segmentation chart.
FAQs
- How do I analyze event and user properties and not just events?
- How do I look at data prior to the last 30 days?
- Why don’t my line chart data points add up to my bar chart total?
- What does New User mean?
- What is the definition of Active %?
- How do I find the average of this property?
- How do I calculate this ratio/percentile?
- How do I segment by user’s past performance?
- How do I download a list of users?
- How do I create a DAU/MAU chart?
- Why don't I see a specific value that I know has been ingested into Amplitude?
- Why am I getting an "Incomplete Data" error?
- Can I see the total number of sessions during a specific time frame?
- Why isn't my chart displaying all possible values for this event/user property?
- Why isn't my glob match filter returning and results?
- How do I filter by accounts instead of users?
Answers
How do I analyze event and user properties and not just events?
After selecting an event to analyze in a chart, you can use “group by” and "where" clauses to query event and user properties further. “Where” will filter your results for specific property values. "Group by" will group your results by your selected property.
How do I look at data prior to the last 30 days?
To see data beyond the last 30 days, use the date picker and date interval options to select different date ranges of data.
For example, if you’d like to see data for the last 90 days, use the datepicker to select Last 90 days instead of Last 30 days. If you’d like to see data for a specific date range in the past, click the Between tab in the datepicker and select your custom dates. If you’d like to see data per month rather than per day, you can select a monthly date interval instead of daily.
Why don’t my line chart data points add up to my bar chart total?
Line charts return values per date interval (eg. per day, per week, per month) while bar charts return values for the entire date range. The date interval selected will not matter when using a bar chart. If a user fires an event on multiple days, the line chart counts a user for each day they fired the event, while the bar chart will only count the user once. In other words, the bar chart will deduplicate the counts.
For example, if a user fired event A on November 2nd and November 6th, and you have a chart that counts uniques daily between November 1st and November 30th, this user will be counted twice in the line chart but only once in the bar chart. Thus the bar chart will return a count smaller than the sum of each daily data point.
What does New User mean?
A new user is a user who has logged an event to Amplitude for the first time (this includes inactive events). The time of when the user is new is the time of when they logged their earliest event.
In an Event Segmentation chart, when choosing New Users, Amplitude will look for the events fired by new users within each day/week/month (whichever interval was chosen) that the user was new. For example, if the interval is set to daily and a user was new on July 17, only the events that happened on July 17 will appear on the chart, regardless if the user also fired events the next day, on July 18.
More helpful definitions of user properties can be found here.
What is the definition of Active %?
Active % graphs the percentage of users who fired a specific event, compared to the total number of active users (users who have fired any active event) at each data point.
For more information on how each metric is defined, please see this article.
How do I find the average of this property?
In the Properties tab of the Event Segmentation chart, select Average of Property Value from the drop-down shown below to calculate the average value:
For more information on how each metric is defined, please see this article.
How do I calculate this ratio/percentage?
Use the Formula tab to calculate custom ratios.
- Example: I'd like to see how many users purchased a song or video compared to all the users who played a song or video each day. I can use the custom formula UNIQUES(A)/UNIQUES(B) to calculate this ratio/percentage. (Tip: add '%:' to the front of your formula to display results as percentages)
How do I segment by user’s past performance?
Customers on a Scholarship, Growth, or Enterprise plan have the option to add a where clause to the and who performed segment definition. This is called an in-line cohort.
You can also define and create a cohort and include this in the segmentation instead. This is helpful if you need to reuse the definition in other charts.
How do I download a list of users?
- Microscope: In a chart, click on a data point you're interested in. A popup will appear; click Download users.
- Cohort: Create a cohort definition and click Export CSV.
- Create a chart: Use Any Active Event, grouped by Amplitude or user ID. Then click Export CSV in the breakdown table below the chart.
How do I create a DAU/MAU chart?
This analysis can be done using custom formulas in the Event Segmentation chart. Rolling windows will help you find the sum of unique users from the last 30 days.
(%:Uniques(A) / ROLLWIN(Uniques, A, 30))
Why don't I see a specific value that I know has been ingested into Amplitude?
Sometimes users instrument event and user properties that have the same naming convention. When choosing the property make sure you are selecting the correct type of property. For example, 'url' could be used as a name for both an event property and user property. If you're filtering or grouping by the 'url' user property instead of the 'url' event property, you may see different results returned in the chart than expected.
Why am I getting an "Incomplete Data" error?
Amplitude servers ingest high volumes of data, and there is the potential for some data processing delays. Rest assured that no data is lost. Incomplete data means only that data has been received by Amplitude, but the servers are taking longer to ingest and process the data for you to query.
To stay up to date, please refer to the Amplitude status page: https://status.amplitude.com/
Can I see the total number of sessions during a specific time frame?
If you are tracking session IDs, you can use the 'PROPCOUNT' formula in a custom formula chart to count unique session ID values. Note that session ID represents the number of milliseconds since epoch (UTC) when the first event of the session occurs. It is possible that two users share the same session ID if they fired the first event in a session at the exact same millisecond; thus, PROPCOUNT cannot provide the absolute count of sessions, but it will be fairly accurate.
Alternatively, with mobile SDKs (iOS, Android), you have the option to track Amplitude's 'Start Session' and 'End Session' events. You can count the number of 'Start Session' events in a chart to see the number of sessions in a given time frame. If you do not want to track 'Start Session' and 'End Session', the best alternative would be the method described in the JavaScript SDK section above.
Why isn't my chart displaying all possible values for this event/user property?
Amplitude will only display the top 100 property values in the breakdown table. If you export the breakdown table to CSV, the file will max out at the first 10,000 values.
For more information on limits, please see here.
Why isn't my glob match filter returning and results?
An important note regarding the glob match feature is that the asterisk only matches non-"/" characters. To search for strings that contain "/", you will have to use two asterisks, because "**" can match anything. In this case, since the referrer property contains URLs, there are going to be lots of "/" characters.
For more information on glob matching, please see here.
How do I filter by accounts instead of users?
In the Segmentation Module, there is an option “..performed by [Any][Users]” where you can select accounts instead of users.