Direct ROAS Attribution & Campaign Intelligence for Social Commerce
Connect ad spend across Meta Ads, TikTok Marketing API, and Line LAP directly to closed chat orders, verified bank slips, and customer conversations in Super Chat and Super API. Know your true return on ad spend with zero cookie loss.
How Ad Spend Connects to Closed Revenue in the Database
Zero-cookie telemetry linking click IDs to PostgreSQL conversation entities and confirmed bank transfers.
Inbound Handshake
Captures fbclid, ttclid, ad_id, and campaign_id when the customer initiates a chat.
Identity Stitching
Stitches anonymous click IDs to customer social profiles and conversation threads inside Super Chat.
Conversation Ledger
Stores social_conversation_entity with aiPurchaseOutcome ('bought', 'lost', 'pending') and slip verification.
ROAS & CAC Derivation
Divides confirmed transfer amounts by ad spend, deriving True ROAS, CAC, creative fatigue warnings, and budget shifts.
True ROAS Attribution
Calculates return on ad spend based on confirmed bank slip QR transfers and checkout receipts rather than imprecise pixel cookies.
Creative Fatigue Radar
Monitors declining CTR, rising cost-per-lead, and chat drop-offs to warn you before ad creative fatigue wastes marketing capital.
Multi-Touch Attribution
Evaluates first-click discovery, chat-assisted touchpoints, and last-message closing to measure the true role of each ad network.
Won vs. Lost Ad Deals
Categorizes every inbound ad inquiry into Closed Won, Abandoned Lost, or Pending, exposing the exact message where leads exit.
High-Intent Retargeting
Isolates leads who asked for bank details or received a quotation but haven't transferred, powering high-yield retargeting audiences.
Cross-Network Optimization
Normalizes cost-per-won-order across Meta Ads, TikTok Spark Ads, and Line LAP on a single screen without manual spreadsheet exports.
AI Copy & Angle Revision
Generates prescriptive headline, hook, and offer revisions directly informed by in-stock inventory and customer chat objections.
Placement & Regional ROI
Pinpoints which ad placements (Reels vs Feed vs Stories) and buyer provinces deliver the highest order value and lowest CAC.
Predictive Budget Reallocation
Autonomous recommendations to shift ad budget from stagnant ad sets to top-converting campaigns to capture maximum incremental profit.
Multi-Channel Campaign Attribution Table
Real-time ledger attributing verified customer bank transfers and paid chat orders in Super Chat to specific ad campaigns across Meta, TikTok, Line, and Google.
|
Campaign & Creative Hook
↕
|
Network |
Ad Spend
↕
|
Inbound Chats
↕
|
Won Orders
↕
|
CAC / Won Order
↕
|
Attributed Revenue
↕
|
True ROAS
▼
|
Status | Drilldown |
|---|---|---|---|---|---|---|---|---|---|
|
Meta Retargeting 7-Day Carts
Carousel • Dynamic Abandoned Cart Reminder
|
Meta Ads | ฿44,000 | 1,190 | 148 | ฿297 | ฿340,000 | 7.72x ROAS | Scaling | |
|
Conversion Funnel
Ad Clicks: 9,600
Inbound Chats: 1,190 (12.4%)
Quotations: 320 (26.9%)
Bank Slips Verified: 148 (46.3%)
Primary Won Driver
Doorstep COD (54%)
Second driver: PromptPay QR (46%). Slip match rate 99.4%.
Top Drop / Objection
Price Hesitation (22%)
Super Chat automated follow-up recovered 34 lost carts.
Closing Velocity & Action
Median Closing Time: 48 seconds
Recommendation: Increase daily spend +20%
|
|||||||||
|
Meta Lookalike 1% Bangkok VIPs
Reels Video • Customer Testimonial & Unboxing
|
Meta Ads | ฿120,000 | 4,200 | 370 | ฿324 | ฿740,000 | 6.16x ROAS | Peak | |
|
Conversion Funnel
Ad Clicks: 47,800
Inbound Chats: 4,200 (8.8%)
Quotations: 890 (21.2%)
Bank Slips Verified: 370 (41.6%)
Primary Won Driver
Bank Slip QR (68%)
High ticket average order value ฿2,000+. Slip match 99.8%.
Top Drop / Objection
Out of Stock (38%)
Size M and L restocked in Super Sales ERP yesterday.
Closing Velocity & Action
Median Closing Time: 1m 15s
Recommendation: Scale budget shift into this set
|
|||||||||
|
Line OA LAP Broadcast - Payday
Smart Channel • Exclusive Payday Discount Code
|
Line LAP | ฿65,000 | 2,050 | 195 | ฿333 | ฿390,000 | 6.00x ROAS | Healthy | |
|
Conversion Funnel
Broadcast Reach: 21,500
Inbound Chats: 2,050 (9.5%)
Quotations: 410 (20.0%)
Bank Slips Verified: 195 (47.5%)
Primary Won Driver
1-Click Voucher (72%)
High repeat purchase rate among existing Line OA followers.
Top Drop / Objection
Delivery Fee (24%)
Free shipping threshold voucher added to quick reply.
Closing Velocity & Action
Median Closing Time: 55 seconds
Recommendation: Schedule next broadcast 2 days before payday
|
|||||||||
|
TikTok Spark Ads - Beauty Viral
Native UGC 9:16 • Creator Demonstration
|
TikTok | ฿95,000 | 3,940 | 280 | ฿339 | ฿480,000 | 5.05x ROAS | Healthy | |
|
Conversion Funnel
Video Impressions: 55,400
Inbound Chats: 3,940 (7.1%)
Quotations: 680 (17.3%)
Bank Slips Verified: 280 (41.2%)
Primary Won Driver
Instant Reply Bot (46%)
Super Chat bot answered size questions in 4 seconds.
Top Drop / Objection
COD Preference (31%)
TikTok users strongly favor doorstep cash delivery.
Closing Velocity & Action
Median Closing Time: 1m 32s
Recommendation: Maintain spend, test 2 new creator hooks
|
|||||||||
|
TikTok Flash Promo Urgency
Urgency Timer • Limited Stock Countdown
|
TikTok | ฿48,000 | 1,810 | 145 | ฿331 | ฿248,000 | 5.16x ROAS | Fatiguing | |
|
Conversion Funnel
Video Impressions: 28,400
Inbound Chats: 1,810 (6.4%)
Quotations: 340 (18.8%)
Bank Slips Verified: 145 (42.6%)
Primary Won Driver
Flash Urgency Badge (62%)
High conversion in first 4 hours of ad delivery.
Top Drop / Objection
Expired Promo (28%)
Users arrived after the promo ended; AI offered standard bundle.
Closing Velocity & Action
Median Closing Time: 1m 08s
Recommendation: Shift ฿18,000 to Meta Lookalike set
|
|||||||||
|
Google Search High-Intent Brand
Exact Match Search • Direct to Line/WhatsApp Chat
|
฿32,000 | 720 | 90 | ฿355 | ฿152,200 | 4.75x ROAS | Stable | ||
|
Conversion Funnel
Search Impressions: 4,800
Inbound Chats: 720 (15.0%)
Quotations: 165 (22.9%)
Bank Slips Verified: 90 (54.5%)
Primary Won Driver
High Intent Search (78%)
Users searched brand keyword directly before clicking ad.
Top Drop / Objection
Competitor Comparison (19%)
Customers asked for comparison sheet vs alternative brands.
Closing Velocity & Action
Median Closing Time: 38 seconds
Recommendation: Maintain exact match keywords
|
|||||||||
| Total / Blended Portfolio | All Networks | ฿404,000 | 13,910 | 1,428 | ฿283 | ฿1,950,200 | 4.82x ROAS | Net +฿1.54M | 6 Active Sets |
Proactive ad creative fatigue detection & angle optimization
Ad fatigue costs social sellers thousands in wasted clicks. Business AI analyzes CTR decay, frequency saturation, and chat drop-off velocities to prescribe new copy angles before ad sets burn out.
- Early Warning Telemetry: Flags rising cost-per-inquiry before your monthly budget is depleted.
- AI Copywriter Revision: Automatically writes new ad headlines and hooks directly tailored to current in-stock catalog.
- Creative Angle Benchmarking: Compares UGC video vs Carousel vs Image static conversion rates in Super Chat.
Understand true platform roles across discovery, chat assist, and closing
Single-touch attribution misleads marketers. A buyer might discover your brand via a TikTok Spark ad, chat for sizing in Super Chat, and finish checkout on a Meta retargeting reminder. Ads Insights tracks the entire buyer voyage.
- Data-Driven Chat Assist: Credits the ad that initiated the consultation, even if the final checkout occurs days later.
- Cross-Platform De-duplication: Eliminates duplicate conversion counting between Meta and TikTok Ads Managers.
- True Cost Per Acquired Customer: Aggregated blended CAC across all active channels.
| Network | First Touch | Chat Assist | Last Click | Attributed Revenue |
|---|---|---|---|---|
| Meta Ads | 42% | 52% | 68% | ฿1,080,000 |
| TikTok Spark | 38% | 26% | 14% | ฿480,000 |
| Line LAP | 12% | 16% | 12% | ฿390,000 |
| Google Ads | 8% | 6% | 6% | ฿145,000 |
Buyers discover products via TikTok Spark video ads, but 64% complete the bank transfer after a Super Chat automated reminder. Chat Assist attribution ensures TikTok receives proper credit.
Placement Efficiency & Regional Buying Ledger
Compare performance across ad placements (Reels vs Feeds vs Stories) and geographic sales distribution with verified bank slip match rates.
| Placement Inventory | Network | Creative Format | Avg CTR | Chat Conv % | Won Orders | Spend | Revenue | ROAS | AI Recommendation |
|---|---|---|---|---|---|---|---|---|---|
| Instagram Reels | Meta Ads | Vertical Video 9:16 | 4.8% | 9.4% | 340 | ฿84,000 | ฿512,000 | 6.10x | Scale Spend +25% |
| Line LAP Smart Channel | Line LAP | Top Banner / Text | 3.9% | 8.8% | 195 | ฿65,000 | ฿390,000 | 5.80x | Increase Frequency |
| Facebook Mobile Feed | Meta Ads | Square Image Carousel | 3.4% | 7.9% | 480 | ฿126,000 | ฿680,000 | 5.40x | Maintain Budget |
| TikTok For You Page (FYP) | TikTok | In-Feed Native Video | 4.2% | 7.1% | 280 | ฿73,000 | ฿368,000 | 5.05x | Refresh Hook |
| Market / Province | Revenue Share | Closed Deals | Avg Order Value (AOV) | Preferred Payment Method | Slip OCR Match % | Total Net Revenue | Localized ROAS |
|---|---|---|---|---|---|---|---|
| 1. Bangkok Metropolis & Vicinity | 58.0% | 828 | ฿2,450 | PromptPay QR Transfer (78%) | 99.4% | ฿1,131,000 | 6.20x |
| 2. Chiang Mai & Northern Region | 18.0% | 257 | ฿1,980 | Bank Mobile Slip (64%) | 98.2% | ฿351,000 | 5.40x |
| 3. Chonburi & Eastern Seaboard | 14.0% | 200 | ฿1,890 | PromptPay Instant Slip (72%) | 98.8% | ฿273,000 | 5.10x |
| 4. Other Provinces & Upcountry | 10.0% | 143 | ฿1,680 | Doorstep COD Cash (48%) | 95.2% | ฿195,200 | 4.20x |
Automated budget reallocation for maximum incremental profit
Stop burning ad budget on saturated ads. Business AI continuously calculates marginal ROAS and suggests optimal budget shifts from fatiguing campaigns into high-converting scaling sets.
- Marginal Return Modeling: Simulates revenue returns before you move a single baht of ad budget.
- 1-Click Optimization: Apply recommended budget increases directly to Meta and TikTok ad accounts via Super API.
- Profit Protection Guardrails: Automatic spend reduction if cost-per-won-order exceeds your target CAC threshold.
Shift ฿18,000 from TikTok Flash Promo (Fatiguing at 3.4x) into Meta Lookalike 1% Bangkok (Scaling at 6.16x).
Turn ad spend into verified chat revenue with Super Sales Ads Insights
Connect Meta Ads, TikTok Marketing API, and Line LAP in under 5 minutes to unlock true ROAS analytics and conversion attribution in Super Chat and Super API.