The most recent content from our members.
Hi There, We just set up Amplitude for our product. I want to analyze the number of unique users come into our product per month. I use the event, Session Started, and the UNIQUE (A) formula šš». But the sum of the monthly unique users who triggered this event is greater than the total number of accounts in our database,ā¦
Hello ! I would likeĀ to measure MAU/DAU withĀ S3 Exported data format. Define MAU such that MAU(/DAU) : Monthly(/Daily) Unique Active Event WHERE user_id != None AndĀ here is the exported data JSON object schema: { "server_received_time": UTC ISO-8601 timestamp, "app": int, "device_carrier": string, "$schema":int, "city":ā¦
Hi, I want to analyze how many songs have been played by (e.g.) length, but countĀ each song only once. So imagine 10 times a song has been played, I want to know that 3 of them were 5mins long, and 2 of them 6 min, but not count every unique song only once. (so 5 songs were counted already) So far I can only count uniqueā¦
Hello I know I can create a computation where I get users who performed action in the last N days and then filter the number of actions. However, I want to get the number of users who performed the action N times in the rolling N days. Is it possible to achieve? I attached the SQL that is achieving what I want to achieveā¦
Hi there, Setting up the chart for signup (so every user can just trigger event once). In cumulative view, thereās no signups on Jun 3. But I can see 5 unique signups on the unique view. Does anyone know why thereās a mismatch?
I am using a Funnel conversion chart to look at unique visitors over a 4 week time period and what the drop off is at each stage (marked by a different page view). However, I get two odd things happening: * When I download the data I can see it on a daily basis and aggregated up into a ātotalā row. Why does the ātotalā rowā¦
Hey, Iām trying to work out if I can understand how many times a single specific event has been fired per user, but only count it once per user based on a uniqueĀ property. We have a Course Completed event which has property of Course ID, which determines which course a user has completed. A user can complete a courseā¦
Iām counting uniques performing event Application Installed. In the data table, I see the sum of unique displayed in the first row does not match with the sum of its components. It is 122 # (55+46+14+8)=123. What are potential reasons behind? Any directions I should follow to explore the causes of this mismatch? Thanksā¦
Iām new to Amplitude and trying to understand how the system treats unique users overtime within a segment chart. For example, if I have an event Iām tracking where I look at unique users openedTool over the last six months, does a user that activates the event in month one also get counted in month two, three, etc? Or isā¦
Hi all, I have a chart that shows the rolling window of unique users in the last 30 days. If I then switch from the formula to the Uniques option in a bar chart the total number of unique visitors is suddenly 2 % higher than that of the rolling window of unique users in the last 30 days. Is there anybody that has seen thisā¦
It looks like you're new here. Sign in or register to get started.