Instagram shows a retention graph but gives no data. I had Claude read the graph’s pixels.

by•

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?

13 views

Add a comment

Replies

Be the first to reply

Have a question or a thought to share? Add a comment above to start the conversation.