Seasonal Trending & Demand Signals

Predictive Seasonal Demand & Holiday Sales Intelligence

Connect customer conversations, confirmed bank slip orders, and holiday calendars in Super Chat and Super API. Predict shopping frenzies for Payday, Songkran, 11.11, and New Year before inventory stockouts hit.

Seasonal Demand Cockpit Past 30 Days
Seasonal Lift Index +38.4%
฿2,480,000
฿680K surge above baseline
Peak Buying Window 4.1x Surge
Fri 20:00-23:00
Month-End Payday rush
Stockout Risk Buffer Urgent
3 SKUs
Reorder needed within 6 days
Closing Velocity Fast
1m 14s
94.2% PromptPay & COD match
Baseline vs. Seasonal Sales Lift
Baseline (฿) Seasonal Surge (฿) Multiplier Curve
Day 1 Day 7 Day 14 Day 25 (Payday Peak) Day 28 (Festival) Day 31
Seasonal AI Alert Month-End Payday rush generates 3.75x conversion surge with 94.2% PromptPay QR payment completion.
Database & Telemetry Architecture

How Seasonal Signals Link to PostgreSQL Entities

Zero-cookie telemetry joining historical social commerce timestamps to commercial holiday calendars and inventory safety buffers.

ENTITY 01 PostgreSQL

SocialConversationEntity

Stores every incoming chat message with nanosecond timestamps across Meta, TikTok, and Line LAP channels to map minute-by-minute buying waves.

• createdAt: timestamp (UTC)
• channelOrigin: Meta | TikTok | Line
• firstResponseSec: integer
ENTITY 02 Supabase / REST

HolidayCalendarRegistry

Regional holiday dictionary tracking Payday cycles, Songkran, 11.11, and New Year dates with verified historical surge multipliers.

• holidayDate: date
• holidayName: varchar
• surgeMultiplier: decimal(3,2)
ENTITY 03 TypeORM

OrderReconciliationEntity

Matches conversational intent directly to verified mobile bank slips and COD receipts to measure true seasonal revenue lift.

• outcome: 'bought' | 'not_bought'
• slipOcrMatch: boolean (99.4%)
• attributedRevenue: numeric
ENTITY 04 Predictive AI

InventorySafetyEngine

Calculates dynamic days-to-stockout based on seasonal velocity, alerting merchants before supplier factory cutoff windows arrive.

• dailyVelocity: units / day
• daysToStockout: integer
• safetyBufferReq: +25% to +85%
FUNCTION 01 Payday Spikes

Payday & Salary Surge Detection

Monitors month-end salary payout cycles (25th to 2nd) when purchasing power peaks, automatically timing broadcast promos for maximum conversion.

Explore Payday Telemetry →
FUNCTION 02 Regional Festivals

Regional Holiday Spike Forecasting

Anticipates commercial buying surges for Songkran, Water Festivals, Lunar New Year, and Loy Krathong based on multi-year chat histories.

Inspect Festival Calendars →
FUNCTION 03 Hourly Heatmap

Day & Hour Conversion Heatmap

Breaks down chat sales into Morning, Afternoon, Evening, and Night segments, pinpointing exact closing sweet spots like Friday 20:00-23:00.

View Heatmap Matrix →
FUNCTION 04 Category Velocity

Category Velocity Acceleration

Measures which catalog categories accelerate ahead of upcoming seasons (e.g. waterproof cosmetics and sunscreens 3 weeks before Songkran).

Track Category Trends →
FUNCTION 05 Stockout Prevention

Pre-Holiday Reorder Buffers

Calculates supplier lead times and warehouse velocity to trigger purchase orders before factory closures and logistics delivery cutoffs.

Simulate Safety Buffers →
FUNCTION 06 Attributed ROAS

Multi-Channel Holiday ROAS

Compares holiday ad spend effectiveness across Meta Ads, TikTok Marketing API, and Line LAP, showing which network dominates specific seasons.

Benchmark Networks →
FUNCTION 07 Chat Radar

Conversational Keyword Radar

Extracts rapidly surging conversational keywords, gift inquiries, and price objections directly from live inbound chats in Super Chat.

Inspect Surging Keywords →
FUNCTION 08 Generative Copy

AI Promo Broadcast Drafter

Automatically writes seasonal promotional copy, flash discount codes, and closing follow-up scripts tailored to the active shopping event.

Preview AI Broadcast Copy →
FUNCTION 09 Campaign Sync

Autonomous Campaign Schedule

Syncs seasonal campaign activation and automated agent replies with holiday start times, ensuring promotions run when customer intent is at peak.

Configure Auto-Schedule →
Seasonal Events & Promotions

Interactive Commercial Events Ledger

Real-time ledger tracking historical sales lift multipliers, surge demand projections, and supplier reorder lead times for major shopping events.

Showing 6 of 6 events
Commercial Event & Timing ↕
Target Category
Sales Lift Multiplier ▼
Projected Volume ↕
Average Order Value ↕
Reorder Lead Time ↕
Stockout Risk Drilldown
11.11 Global Mega Carnival November 10 - 12 • Annual E-Commerce Peak
Electronics & Beauty 5.6x ฿3,200,000 ฿3,150 24 Days Critical
Songkran Festival & Summer Splash April 11 - 16 • Summer Vacation & Travel Surge
Sun Care & Waterproof 4.8x ฿2,400,000 ฿2,890 18 Days Critical
New Year & Gifting Season December 18 - January 2 • Premium Corporate & Family Gifting
Gift Sets & Bundles 4.2x ฿2,650,000 ฿3,400 21 Days High
Month-End Payday Rush (25th - 2nd) Monthly Recurring Cycle • Salary Disbursement Peak
All Active Catalogs 3.4x ฿1,850,000 ฿2,450 7 Days High
Mid-Year 6.6 Mega Clearance June 5 - 8 • Mid-Year Inventory Flash Blowout
Apparel & Overstock 2.9x ฿1,420,000 ฿1,980 12 Days Moderate
Valentine's Romance & Couples Flash February 10 - 14 • Couples Gift & Urgent Express Dispatch
Jewelry & Fragrance 2.5x ฿980,000 ฿2,100 10 Days Stable
Behavioral Purchase Heatmap

Day-of-Week & Hourly Conversion Matrix

Visual heatmap quantifying conversational closing rates across 4 diurnal windows. Know exactly when your customer audience has their digital wallets ready.

Darker green indicates highest GMV closed volume
Day / Period Morning (06:00 - 12:00) Afternoon (12:00 - 17:00) Evening (17:00 - 22:00) Night (22:00 - 06:00) Daily Closed Total
Monday 1.2% (฿42K) 2.4% (฿78K) 3.1% (฿112K) 1.0% (฿31K) ฿263,000
Tuesday 1.4% (฿48K) 2.6% (฿82K) 3.2% (฿118K) 1.1% (฿35K) ฿283,000
Wednesday 1.5% (฿51K) 2.8% (฿91K) 3.5% (฿124K) 1.3% (฿41K) ฿307,000
Thursday 1.8% (฿59K) 3.1% (฿98K) 3.9% (฿142K) 1.4% (฿44K) ฿343,000
Friday (Payday Peak) 3.4% (฿110K) 4.8% (฿185K) 6.8% (฿340K) ★ 3.1% (฿98K) ฿733,000
Saturday 2.9% (฿92K) 4.2% (฿155K) 5.1% (฿198K) 2.1% (฿68K) ฿513,000
Sunday 2.8% (฿88K) 4.5% (฿168K) 5.4% (฿210K) 2.3% (฿74K) ฿540,000
Key Behavioral Takeaway: Friday Evening (17:00 - 22:00) during month-end accounts for 46.3% of total weekly sales with median chat-to-paid duration of 48 seconds.
6.8% Conversion
Inventory Safety Simulation

Autonomous Safety Buffer & Reorder Engine

Eliminate holiday stockouts that cost social merchants up to 34% of potential seasonal profit. Business AI models lead times, current SKU velocities, and factory closure windows to prescribe exact reorder quantities.

✓
Lead Time & Courier Bottleneck Warning:

Alerts operations teams 18-24 days before national logistics networks face holiday backlogs.

✓
Automated SKU Reorder Drafting:

Generates ready-to-dispatch purchase order specifications mapped directly to supplier units.

✓
Capital Preservation Guardrails:

Prevents overstocking on non-seasonal inventory while protecting top 3 fast-moving holiday hero products.

Pre-Season Buffer Simulator

Predictive AI
Adjust Demand Surge Multiplier: 2.2x Surge
1.0x (Baseline) 2.5x 4.0x (Peak Surge)
Recommended Reorder Buffer: +45% (+1,250 Units)
• Protected Seasonal Revenue: ฿285,000
• Stockout Probability without buffer: 84.2% (Day 2 of Event)
• Supplier Purchase Order Deadline: 7 Days Remaining
Super Sales Marketing Hub

Never Miss Another Seasonal Shopping Surge

Activate predictive demand forecasting, protect warehouse inventory, and time social promotions with surgical precision in Super Chat and Super API.