# JoinData — Full Content

> A complete, Markdown-formatted index of JoinData's public content, intended for ingestion by AI agents and retrieval pipelines. This file complements `/llms.txt` and is updated when product copy changes.

JoinData (also marketed as **JoinSea** in SEA retail circles) is a business-intelligence and AI-automation platform for multi-channel e-commerce sellers. Operated by JS HOME LIVING SDN BHD (1364223-T), Malaysia.

---

## Product overview

JoinData consolidates data from a seller's marketplaces (Shopee, Lazada, TikTok Shop) and ERP (QianYi) into a single warehouse, then exposes:

1. **BI dashboards** — live operational KPIs, shop comparisons, RFM customer segmentation, AOV trends.
2. **AI automation** — procurement co-pilot that drafts POs, matches suppliers, and summarises landed-cost changes.
3. **Marketing analytics** — unified ad performance across Shopee Ads, Lazada AMS and TikTok Ads Manager, with ROAS / ACOS alerts and underperformer callouts.
4. **ETL monitoring** — a Cron Job Module that shows scheduled ingestion runs, their status, and recent logs.

## Target users

- E-commerce operators running 2+ marketplaces simultaneously in SEA
- Brands with a QianYi ERP backbone that need marketplace data joined back into inventory and finance
- Small ops teams that want agent/AI help on procurement and reporting without building it in-house

## Feature modules

### Multi-marketplace sync

Scheduled ETL commands pull orders, products, promotions, customers and airway bills from each platform's Open API. Every ingestion is idempotent, locked against overlap, and tracked in `etl_runs` so the ETL Monitor page shows run history, timing and failures.

Platforms currently supported:

- **Shopee** — Open Platform v2 (partner.shopeemobile.com), SG / MY / ID / TH / VN / PH / BR / TW
- **Lazada** — Open Platform (api.lazada.\*), SG / MY / ID / TH / VN / PH
- **TikTok Shop** — Partner API (open-api.tiktokglobalshop.com), Global / SEA / US / UK

### Advertising analytics

Unified view across platform ad products, with separate auth for ads where the platform requires it (Lazada AMS, TikTok Ads Manager). Metrics: impressions, clicks, orders, GMV, spend, CPC, CTR, CVR, ROAS, ACOS.

Charts on `/bi/marketplace/advertising`:

1. KPI strip — Spend, GMV, ROAS, ACOS, Orders, CTR, CVR, CPC
2. Daily spend trend (stacked by platform)
3. Daily GMV trend (stacked by platform)
4. Platform comparison — Spend vs GMV
5. Campaign-type mix (doughnut)
6. Efficiency bubble — CPC × ROAS, bubble size = spend
7. Top 10 campaigns by GMV
8. Underperformer alerts — spend with no orders or ACOS > 60%

### AI procurement

Internal to each tenant: a procurement module that drafts POs based on stock projections, matches incoming ASNs against open POs, and flags cost anomalies. Powered by an agentic flow that reads ERP and marketplace stock history.

### Customer segmentation

7-tier RFM classification (VIP / loyal / active / new / at_risk / one_time / dormant) computed from order history and airway-bill-extracted shipping addresses.

## Pricing

Pricing is published on the `/pricing` page. Plans include a free trial; no credit card required. Enterprise plans with custom ETL cadence and SLA available via sales contact.

## Security posture

- Credentials (app keys, access tokens, advertiser IDs) stored per-tenant in encrypted configuration
- All third-party Envato licence / phone-home hooks have been neutralised in the distribution
- OPcache + config/route/view caching enforced in production
- Marketplace API credentials are masked for non-admin users in the UI and never logged in plaintext

## Frequently asked questions

### What marketplaces do you support?

Shopee, Lazada and TikTok Shop out of the box. Integrations expose a shared adapter interface so additional platforms can be added without touching BI code.

### Do I need separate credentials for ads APIs?

For Shopee, no — Shopee Ads reuses Shop API credentials. For **Lazada Sponsored Solutions (AMS)** and **TikTok Ads Manager** the platforms require a separate developer app and advertiser token; JoinData exposes a dedicated "Ads API" panel on the integrations page to store these alongside your Shop API credentials.

### Is my marketplace data shared across tenants?

No. All raw and unified tables key on `company_id` and queries filter on the authenticated user's company context.

### How often is data refreshed?

- Orders: every 15 minutes
- Airway bills: every 30 minutes
- Products: hourly
- Promotions: daily 03:10
- Ads data: daily 03:40 + unify at 04:25
- OCR retries: hourly
- Customer segments: daily 04:10

### How can AI agents interact with JoinData?

The public marketing site is fully agent-readable — see `/llms.txt`, `/.well-known/ai-plugin.json`, `/.well-known/agent.json`, and the Markdown versions of each page (append `.md` to any URL or send `Accept: text/markdown`). Authenticated programmatic access over a documented API surface is on the roadmap; see `/.well-known/mcp.json` for status.

## Legal

- **Company**: JS HOME LIVING SDN BHD, Company Number 1364223-T
- **Privacy policy**: `/page/privacy-policy`
- **Terms of use**: `/page/terms-of-use`
- **Data residency**: data is stored within the region applicable to each tenant's plan (contact sales for specifics)

## Change log

- 2026-04-23 — Added Advertising analytics module (unified Shopee Ads + Lazada AMS + TikTok Ads Manager); separated ads auth for Lazada/TikTok.
- 2026-04-22 — Marketplace logos updated to official brand marks; integrations form fields converted to preset selects.
- 2026-04-19 — ETL Monitor module launched under Developer menu; `etl_runs` tracking for every scheduled command.
- 2026-04-18 — Homepage redesign to match brand cyan palette; SEO + AI-readability audit.