Skip to content
Astera Technology

Check recipient publication windows using supplied fixed offsets

Evaluate each audience’s local window at one proposed reference instant.

State offsets as scenario inputs

Fictional audiences N and S use fixed offsets+2h and+5h from a reference clock. Local release window is 09:00 inclusive to 18:00 exclusive for both. Proposed reference time 14:00 gives N16:00 and S19:00. No real timezone, daylight-saving behaviour or sending-platform feature is implied.

Audience-local release check
AudienceLocal timeEligible
N+2h16:00Yes
S+5h19:00No
Download editable CSV ↓

Convert the proposed instant per audience

  1. Read supplied fixed offsets
  2. Add offset to reference instant
  3. Check 09≤local<18
  4. Keep S out of this release window

If the offset is unknown, the audience timing remains unresolved.

How many audiences fit 14:00 reference release, and does 13:00 allow S?

Show the worked answer

One audience N. At reference 13:00 S is 18:00, still excluded; S needs a reference time before 13:00 and within its lower bound.

Select eligible audience windows

Filled campaign-operation checks
CaseDecision or resultReason
S at local 18:00OutsideEnd excluded
N at local 16:00InsideBetween 09 and 18
Download editable CSV ↓

For actual audiences obtain the actual calendar/offset rules separately. This worksheet supports only the two supplied fixed offsets.

Related resources