user-property-timezone
Installation
SKILL.md
User Property Timezone Handling Solution
Background
In ThinkingEngine, user properties do not have a timezone field. When user properties store time-related data (registration time, last login time, etc.), they cannot dynamically adjust the timezone display based on the event's timezone as event properties do. This Skill analyzes the specific scenario and provides a targeted solution.
Decision Matrix
Use this table to pick the right solution at a glance. Details for each solution and the diagnosis flow follow.
| Field type | Solution | Formula (see Step 4) |
|---|---|---|
| datetime + user local time with confirmed matching event offset | Solution 1 | Direct mapping |
| datetime + timezone field reported | Solution 2-A | datetime + timezone field |
| datetime + fixed timezone reporting | Solution 2-A | datetime + fixed timezone |
| number (Unix timestamp) | Solution 2-B | Timestamp formula after unit and conversion-baseline checks |
Key rule for numeric timestamps: A confirmed Unix timestamp needs no source-timezone question. Confirm seconds versus milliseconds and calibrate
from_unixtimebefore choosing the formula.