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
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.fromisoformat(row["published_at_utc"])
hour_ist = (utc + IST).hour
reach_by_hour[hour_ist].append(int(row["reach"]))
rows = []
for hour, values in reach_by_hour.items():
avg = sum(values) / len(values)
rows.append((avg, hour, len(values)))
for avg, hour, n in sorted(rows, reverse=True)[:5]:
print(f"{hour:02d}:00 IST avg reach {avg:,.0f} ({n} posts)")
Reading the output
09:00 IST avg reach 1,912 (6 posts)
21:00 IST avg reach 1,705 (9 posts)
13:00 IST avg reach 1,120 (4 posts)
Two warnings before you trust it:
- Small samples lie. An hour with one viral post looks amazing. Ignore hours with fewer than four posts.
- Content matters more than clock. A great Reel at a bad hour still beats a weak one at the perfect hour.
Going further
You can add a weekday split with (utc + IST).strftime("%a") and group by both. That usually shows weekends behave very differently for Indian audiences.
If reach is dropping no matter when you post, timing probably isn't the main issue. This plain guide on how to increase Instagram reach in India covers the content and algorithm side. And if you're building tools around growth services, SMMYodha publishes an API you can experiment with.
Happy hacking.
Top comments (0)