銷售表現 Sales Performance
Shopify + HKTVmall
--
渠道分析 Channel Breakdown
| Channel | Revenue HKD | Orders | AOV | New Customers | Returning | Refunds HKD | Discounts HKD |
|---|---|---|---|---|---|---|---|
No sales data Connect your sales data source to the sales table. | |||||||
付費媒體 Paid Media
Meta Ads + Google Ads
--
| Channel | Spend HKD | Impressions | Reach | Clicks | CTR | CPC | CPM | ROAS | Purchases |
|---|---|---|---|---|---|---|---|---|---|
No paid media data Connect Meta Ads and Google Ads via Coupler.io to see spend, ROAS, and campaign performance. Action: Configure Coupler.io -> paid_media table | |||||||||
廣告活動 Campaign Breakdown
parsed from naming convention · {YYMMDD}-{brand}-{objective}
| Campaign | Objective | Channel | Spend HKD | Impressions | CTR | CPC | ROAS | Purchases |
|---|---|---|---|---|---|---|---|---|
No campaign data Loads after paid media syncs. | ||||||||
預算對比 Budget vs Actual
--
No budget set
Add monthly budgets in the budget table to track spend vs plan.
網站流量 Web Traffic
Google Analytics
--
流量來源 Traffic Sources
| Source Group | Sessions | % of Total | Transactions | Revenue HKD |
|---|---|---|---|---|
No traffic source data Connect web_traffic table via Coupler.io. | ||||
裝置分佈 Device Split
門店客流 Retail Footfall
Store performance
--
| Store | Foot Traffic | Transactions | CVR % | Revenue HKD | Avg Basket | Staff | Rev / Staff |
|---|---|---|---|---|---|---|---|
No retail footfall data Connect store data to the retail_footfall table. | |||||||
推廣表現 Promotion Performance
--
| Status | Promo Code | Channel | Type | Dates | PIC | Uses | Orders | Gross Rev | Net Rev | WOW | MOM | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
No promotions planned Click "Plan Promo" to set up a new promotion. | ||||||||||||
Budget vs Actual
--
No budget set
Set sales targets above to see budget vs actual.
營銷支出記錄 Marketing Spend Log
All categories
--
| Date | Brand | Category | Description | Vendor / Payee | Amount (HKD net) | Status |
|---|---|---|---|---|---|---|
No marketing expenses recorded Submit expenses via the Expense Submission form, categorised as marketing spend. | ||||||
粉絲數
Followers
--
End of month
粉絲增長
Follower Change
--
This month
觸達人數
Total Reach
--
This month
互動率
Avg Engagement Rate
--
Avg across days
Reels 播放
Reels Plays
--
This month
平台表現 Platform Performance
organic_social · synced daily
--
| 平台 Platform | 粉絲 Followers | 觸達 Reach | 曝光 Impressions | 互動 Engagement | 互動率 Eng Rate | 儲存 Saves | 分享 Shares | Reels 播放 |
|---|---|---|---|---|---|---|---|---|
暫無社交數據 No social data Organic data syncs daily via sync-meta-organic. Instagram and Facebook data appear here automatically. | ||||||||
貼文記錄 Post Feed
social_posts · manually submitted
--
本月線索
WA Leads
--
Incoming this month
廣播次數
Blasts
--
This month
總觸達
Total Reach
--
Messages sent
廣播成本
Blast Cost
--
HKD, this month
點擊轉化
Conversions
--
From blast UTM links
廣播記錄 Blast Log
wa_blasts table · UTM tracked
--
| Date | Brand | Blast Name | UTM Campaign | Sent | Delivered | Read | Clicks | Conv. | Cost HKD |
|---|---|---|---|---|---|---|---|---|---|
No blasts recorded Use the Log Blast button above when you send a Chatobuy broadcast. Include the UTM campaign name so GA4 tracks clicks and conversions automatically. | |||||||||
WhatsApp 線索 Incoming Leads
wa_leads · auto-captured via Chatobuy webhook
--
| Date | Brand | Name | Phone | Source | Status | First Message |
|---|---|---|---|---|---|---|
No leads yet When customers message your WhatsApp channels via Chatobuy, they auto-appear here. Configure webhook URLs in Chatobuy → Channels → Edit. | ||||||
數據來源狀態 Data Freshness
source_refresh_log
--
| Source | Table | Method | Last Success | Last Attempt | Expected Frequency | Status |
|---|---|---|---|---|---|---|
No source refresh data Populate the source_refresh_log table to track data freshness. | ||||||
行動警示 Operational Alerts
--
沒有警示 No alerts
所有行動均已指定負責人且進度正常。All actions have owners and are on track.
貢獻排行 Contribution Leaderboard
得分 Score = 負責行動的權重總和 sum of weights for owned actions
| 團隊成員 Team Member | 負責 Owned | 得分 Score | 主要類型 Top Types |
|---|---|---|---|
尚無行動記錄 No actions recorded 新增行動並指定負責人以查看貢獻得分。Add actions and assign owners to see contribution scores. | |||
角色分佈 Role Distribution
所有行動的角色統計 Across all actions
暫無角色數據 No role data
按類型分析 Actions by Type
| 類型 Type | 數量 Count | 權重 Weight | 完成 Done | 進行中 Live | 計劃 Planned |
|---|---|---|---|---|---|
暫無數據 No data | |||||
按品牌分析 Actions by Brand
| 品牌 Brand | 行動 Actions | 權重 Weight | 完成 Done | 進行中 Live |
|---|---|---|---|---|
暫無數據 No data | ||||
最近行動 Recent Actions
--
| 行動名稱 Action | 類型 Type | 品牌 Brand | 負責人 Owner | 狀態 Status | 權重 Weight | 開始 Start | 結束 End |
|---|---|---|---|---|---|---|---|
尚無行動 No actions 點擊「新增行動」開始記錄。Click "+ Log Action" to get started. | |||||||
Meta 廣告命名 + UTM
Campaign · Ad Set · Ad · UTM link generator
Campaign
Campaign Name
—
Ad Set
Ad Set Name
—
Ad Creative
Ad Name
—
UTM Link
UTM URL
Enter landing page URL above
Google 廣告命名 + UTM
Campaign naming · tracking templates · reference
Campaign
Campaign Name
—
Tracking Template
Google Ads → Campaign → Settings → Tracking → Tracking template
—
Final URL Suffix
For use in Final URL suffix field (no {lpurl} prefix)
—
Google UTM Reference
| Type | utm_medium | utm_campaign |
|---|---|---|
| Performance Max | cpc | pmax |
| Search (Brand) | cpc | sem_brand |
| Search | cpc | sem |
| YouTube | cpv | youtube |
| Demand Gen | cpc | dem |
| Shopping | cpc | sho |
Meta UTM Medium Reference
| Objective | utm_source | utm_medium |
|---|---|---|
| Conversion | paid_conversion | |
| Traffic (CPC) | paid_traffic_cpc | |
| Traffic (ATC) | paid_traffic_atc | |
| Traffic (Engage) | paid_traffic_engage | |
| Awareness | paid_awareness | |
| Engagement (Follow) | paid_engage_follow |