Menu

Find Your Best Instagram Posting Hour in IST From an Insights CSV (Python, No Libraries Beyond csv)
📰

Find Your Best Instagram Posting Hour in IST From an Insights CSV (Python, No Libraries Beyond csv)

DEV Community: python·SEO - NT Tech Innovation·1 day ago
#IHaNVUh4
#devtopython#devto#dev#hour#reach
Reading 0:00
15s threshold

By MD Fozla Rabbi , SEO Specialist

Indian creators keep asking "what's the best time to post?" Every blog gives a different answer. Your own data gives the right one.

Instagram lets professional accounts export post-level insights. Once you have a CSV, a few lines of Python tell you which hour actually gets reach for your audience.

The CSV shape

Most exports (or a quick copy from Meta Business Suite) look roughly like this:

post_id , published_at_utc , reach , likes , comments 1 , 2026 - 10 - 01T03 : 30 : 00 , 1840 , 92 , 7 2 , 2026 - 10 - 02T14 : 10 : 00 , 620 , 30 , 1

Enter fullscreen mode

Exit fullscreen mode

The timestamps are UTC. India is UTC+5:30, which is the part people forget.

The script

import csv from datetime import datetime , timedelta from collections import defaultdict

IST = timedelta ( hours = 5 , minutes = 30 ) reach_by_hour = defaultdict ( list )

with open ( "insights.csv" , newline = "" ) as f : for row in csv . DictReader ( f ) : utc = datetime .…

Continue reading — create a free account

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