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.…