π Summary:
What it is: The precise local time zone timestamp indicating exactly when a direct-to-consumer wine order was completed and processed.
How to use it:
β’ Filter sales reports to analyze order patterns by specific dates or time periods
β’ Create customer segments based on purchasing timing and seasonal trends
Tip: When selecting multiple date ranges, choose adjacent time bands to create cumulative analysis (e.g., selecting 3-month, 6-month, and 12-month values to understand full annual purchasing activity).
This summary was generated by AI.
π Quick Stats:
π·οΈ Type: timestamp
π Build Beyond Limits Group: Order General
π Last Updated: 2024-10-02T21:22:54Z
π Description
This is the to local time zone converted date time of the order_completed_at (UTC timestamp)
π Build Beyond Limits Group
Order General
π Other Dimensions in this Group
Bundle Item Quantity
Bundle Item Quantity Ratio
COS
βοΈ Technical Details
Type: timestamp
Format: mm/dd/yyyy hh:mm:ss
βΉοΈ Additional Details
Created: 2024-10-02T20:44:30Z
Last Updated: 2024-10-02T21:22:54Z
Key:
[dimension].[Completed Date/Time]ID:
50a052c3-47e9-4ab5-be61-0f0e2365fdc7
π·οΈ Tags
Completed Date/Time
Order General
