Solved

Continued increase in the number of uniques (over 3 weeks)

  • 20 July 2022
  • 4 replies
  • 48 views

Measuring the number of unique users who viewed an event on Amplitude

I know that there are cases where it usually increases even after 3-4 days.

However, even after 3 weeks, the number continues to increase, and I wonder what is the reason.

 

The left is data for July 6th. On the right is the data seen on July 11th.

The latest data I saw today (7/20) is still increasing

 

view-mainfeed (6/30) on 7/6 : 6203

view-mainfeed (6/30) on 7/11 : 7410

view-mainfeed (6/30) on 7/20 : 7890

 

 

https://community.amplitude.com/building-and-sharing-your-analysis-58/historical-total-number-of-unique-users-changing-over-time-especially-in-most-recent-week-1214

I know about these issues.

But can the value still increase after a long period of time?

icon

Best answer by Denis Holmes 21 July 2022, 11:32

View original

4 replies

Userlevel 6
Badge +8

Hi @Willy ,

 

Thanks for writing into Amplitude Support! Are you backfilling any events in? One thing I can think of is if any of the events are being backfilled at a later point and therefore, will increase if you are sending in past events later.

 

Another option might be that users have done events offline and then connected to the internet after some time and uploaded the events. 

Another option might be an implementation issue of some sort. Do you have a chart you can link to me here as in the screenshot? I can then take a look at the events for you and see if there is anything unusual. I would also recommend upgrading to the latest SDK, just to be sure. 

 

Kind Regards,
Denis

Hi @Denis Holmes 

Thanks to reply.

 

This is the link to our chart. I don't know if it can be accessed from outside. attach a screenshot

https://analytics.amplitude.com/newneek/chart/fim7emm/

 

# original chart

 

# other chart

 

Q1. The two charts above have the same value when unique, but different when Event Totals. What is the reason?

 

And to check this problem, we are extracting raw data

https://www.docs.developers.amplitude.com/analytics/apis/export-api/

I used the api to extract the data

https://amplitude.com/api/2/export?start=20220630T09&end=20220701T08

I have adjusted the time because I am looking at asia/seoul standards.

 

Q2. If we want to see the data between 6/30 ~ 7/1, are the params of the above url request correct?

- Is event_time the standard for start and end of export api?
- When displaying by date in the chart, is event_time the standard as well?

 

I counted the number of event_type of “view-mainfeed” in the entire event json, but it was less than the number in the chart

- event totals of chart : 9,458

- number of exported data: 9714

(maybe this isn't a big deal)


Q3. To see unique in the row data, I did unique based on the same `user_id` on json, but 4243 were found. The chart shows 8,008. Can you tell me what the "Uniques" criterion is?

 

Userlevel 6
Badge +8

Hi @Willy ,

 

  1. With regards to question 1, you are looking unique users so they will be the same as the same unique users did the events you have chosen, as we see from the first chart. However, the first chart looks at ANY active event, while the other looks at those two specific events and only looks at the users who fired those events of view-mainfeed and view-detail. THese are active events so when you use Any Active Event, you will get the users who did those events and the users who did any other event that was considered active. 
    Event totals looks at the amount of times an event was fired. 

     
  2. - Is event_time the standard for start and end of export api?
    For the Export API, you can refer to our article here. For the time parameter start and end, this is the first hour included in data series, formatted YYYYMMDDTHH. For example, '20220201T05 Would give 2022-02-01 from 05:00 in the morn. It is done by client event time. 
    - When displaying by date in the chart, is event_time the standard as well?
    You cannot chose to display or group by event_time unless you implement a custom property for that yourself.
     

    I counted the number of event_type of “view-mainfeed” in the entire event json, but it was less than the number in the chart
    Did you account for the timezone and the exact same time period as the chart? Then please show me the curl command you made and the chart you are referencing. The time is an important factor. 
     

  3. To see unique in the row data, I did unique based on the same `user_id` on json, but 4243 were found. The chart shows 8,008. Can you tell me what the "Uniques" criterion is?

     

    Sorry Willy, I don’t understand what you mean here. Which User ID? Can you show me the chart where you saw this? Are you accounting for timezones? Thanks

     

     

Hi @Denis Holmes 

 

Thanks, I was able to find the cause of the problem.

We compared the difference between client_event_time and server_received_time in raw data. In fact, there were cases where there was a difference of more than two weeks.
So I've actually found that the user closes the app and comes back too late.

 

ps.

  1. I found that to bind the data to a user-unique, use amplitude_id .

 

Thank you. It was very helpful

Reply