Comment by @hajun • Hey
I believe these active users are the one who create new posts🤔
Comments
- But wouldn't that be the "Daily Lens Posts" user count? Interestingly, when I query the BigQuery public dataset from Lens I get 20,001 unique users having posted on the 11th. That's much closer to the 15k that restamov's dashboard shows, and that discrepency might just be a matter of time zones.
The query:
```
SELECT COUNT(DISTINCT(SPLIT(publication_id, '-')[OFFSET(0)])) AS unique_users
FROM `lens-public-data.polygon.public_publication_pointer`
WHERE DATE(block_timestamp) = '2023-04-11';
```
@rickydata.lens Hey, does that query look right to you?
This appears to be accurate, as simply counting the `publication_id` gives 89,933 which is basically the same number shown in rustamov's "Daily Lens Owner Actions" if you add up the posts, comments, and mirrors. Same numbers in https://dune.com/gm365/lens as well.
Attached is a chart of the unique users that created a publication over the last 30 days. The light green line is the trend line, showing a slight progression in the past month.