DEV Community

SEO - NT Tech Innovation
SEO - NT Tech Innovation

Posted on

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

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.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)")
Enter fullscreen mode Exit fullscreen mode

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)
Enter fullscreen mode Exit fullscreen mode

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)