Menu

5 rules we used to turn 164,963 daily follower readings into one honest growth number
📰

5 rules we used to turn 164,963 daily follower readings into one honest growth number

DEV Community: datascience·Outfame Team·14 days ago
#qKldQROW
#devtodatascience#science#devto#dev#accounts
Reading 0:00
15s threshold

We publish an Instagram growth statistics page built from our own customer data: 164,963 daily follower-count readings from 7,271 Instagram accounts. The headline result is a median gain of +346 followers in the first 30 days across 981 accounts, with 86% of them growing. Below are the five cleaning rules that produced that number, why each one exists, and a SQL sketch of the core query.

1. Measure at "the reading closest to day N", within a window

Daily readings are not perfectly daily. A job fails, an account is private for a day, a request times out. So the gain at day 30 is the reading closest to day 30, as long as it falls within 3 days of it, minus the first reading. Same rule for day 60 and day 90.

Without a window you either lose most accounts (an exact day-30 reading is often missing) or you silently mix day-24 and day-37 readings into one "30-day" number.

2.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.