Instagram shows a retention graph but gives no data. I had Claude read the graph’s pixels.
Instagram’s insights show a retention graph for each reel, with no export and no table. I wanted real numbers to compare reels, so I took four screenshots and asked Claude to extract them.
How it worked: the line on each graph is one distinctive color. Claude found the pixels of that color in every column of the screenshot. It used the 100%, 50% and 0% gridlines to turn pixel height into percent, and the time axis to turn horizontal position into seconds. The output was a list of time and percent points per reel, with a stated error of about 2 percentage points.
What it showed (approximate): a 13-second reel kept about 63% of viewers at 5 seconds. A 35-second reel kept about 44%, and half were gone by 4 seconds. A 30-second reel kept about 70%. A 56-second reel kept about 59%, held around 35% for most of its length, then fell to about 14% in the last 2 seconds.
The weak spots. A screenshot is compressed, and the line is several pixels thick with soft edges, so 2 points is a tolerance, not a measurement against the true data. The method only works when each chart has one line and visible gridlines. And four reels is a tiny sample. It shows a pattern on my account, not a rule.
If a platform gives you charts but no data, how do you get numbers out: screenshot extraction like this, manual reading, or something I’m not thinking of?
p/runevr
p/producthunt
p/google-cloud-platform
p/aperture-7
p/raycast
p/kuc-kuc
p/lasso-11
p/kodlo
p/ai-context-flow
p/offiai
p/many-displays
p/reso
p/dino-kids
p/dex-by-exmergo
p/supabase
p/jev
p/htmldrag
p/murror
p/nexupira
p/jot-2-0
Replies
Be the first to reply
Have a question or a thought to share? Add a comment above to start the conversation.