Blank editorial worksheet · N073-TZ-01

Post time-zone alignment card

One card covers one post and the reports that will be compared. Copy the source block for each report, or use the blank CSV register. The clock map shows the idea with made-up offsets.

Local blank template. No submit action, no saving, no example creator, platform setting or result. Keep real post links and analytics exports in your own workspace. This is an editorial method, not legal or accounting advice.

A. Fix the post as one instant

Post instant with UTC offset (date, time, offset)

Where that time came from (platform screen, publish log, creator message)

Went public at this time, or only scheduled for it?

Reference clock for the whole sheet (for example UTC)

Post instant written in the reference clock

B. One block per report or export

Source and report or export name

Metric or column

Time zone this report uses

Where and when you read it (page or setting, date)

Bucket size

Daylight saving change inside the window?

First whole bucket after the post: its start, written in the reference clock

Bucket containing the post is partial?

Test row checked against a known event time?

Settings changed during the window, with date (for example a property time zone change)

C. Before comparing

Window end rule, written once for every report

Hours between the reports' first whole buckets (this is a window difference, not a result)

Owner, checked-at date and time with time zone