Align advertising cost dates with the analytics reporting timezone before comparing daily performance. Preparation only, not an account action.
Download the free skill
One complete Markdown file. No subscription or fabricated setup files.
Download SKILL.mdWhat to provide
Source timestamps, vendor timezone, analytics timezone, daylight-saving evidence and approved daily rule.
How it works
- Preserve original timestamps and explicit offsets before resolving reporting dates.
- Convert only with the supplied timezone/rule; missing offset remains unresolved.
- Separate calendar-day movement from cost changes and check boundary rows.
- Return a daily assignment map; do not change account timezones or claim campaign improvement.
The output
row | source timestamp/offset | approved target zone | reporting day | boundary shift | gap
Worked fictional example
Fictional cost event 2026-10-01T23:30:00Z maps to October 2 at UTC+05:30. Date-only Oct 1 without source timezone stays unresolved, not silently shifted.
Checks and limits
Keep source versions and original values. Unknowns stay unknown. Use qualified review for regulated, legal or hiring decisions. No live account compatibility test, send, share, schedule, ledger change or payment is authorized.
More marketing workflows · How-to guides
Method: reviewed source. Demand lead: Oct6 GSC marketingcopilot37,PlanableClaude33,PlanableChatGPT23,brief12/report11 impressions; source window Sep12-Oct3, exact topic monthly volume unmeasured. Site impressions and method evidence are not exact new-topic monthly volume. Checked October 6, 2026.