Comment by @paulburke • Hey
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
Stats
Actions: 0
Comments: 0
Likes: 3
Mirrors: 0
Quotes: 0
Comments
Apparently @lenster.lens completely hides code blocks 😅 Here's 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';