📅 Loading...

📊 Sample vs Full Order Logic

Full Orders = Real revenue (tagged sample_not_included or sample_included)
Sample Requests = Leads only, not real revenue (tagged sample_only)
All CAC and ROAS calculations use Full Order metrics only. Meta-reported purchases may include samples.

📈

Executive Summary

Full
Full Orders
21
Excl. samples
Full
Full Revenue
$10,874
Real revenue
Full
Full Order AOV
$517.81
Avg order value
Leads
Sample Requests
99
Potential customers
Meta Ad Spend
$2,268
7-day total
True CAC
$107.99
Spend ÷ Full Orders
Blended ROAS
4.79x
Full Rev ÷ Spend
🏢

A&D / Trade Sales (HubSpot Commercial Pipeline)

📦 Orders Placed (30 Days)
$127.7K
22 orders confirmed
📦 Orders Placed (90 Days)
$302.9K
48 orders confirmed
🎯 Active Pipeline
$2.44M
277 opportunities
30 Days
Orders Placed (Last 30 Days)
$127,747
22 orders entered Confirmed stage
90 Days
Orders Placed (Last 90 Days)
$302,870
48 orders entered Confirmed stage
Pipeline Value (Bidding)
$2.44M
277 active opportunities

📦 Top Recent Orders (By Confirmed Date)

Order Confirmed Value
SO1112539 Jan 29 $12,527
SO1112532 Jan 28 $17,766
SO1112540 Jan 29 $7,443
SO1112528 Jan 27 $6,370
SO1112509 Jan 21 $4,620
SO1112527 Jan 26 $2,335
SO1112512 Jan 22 $2,380
✓ Dates based on when deals entered "Confirmed" stage (not close date)

🎯 Top Bidding Opportunities

Deal Name Value
Skanska USA - Center for Environmental Science $365,526
Dawn Elizabeth Interiors - Three Rivers $153,510
Vertical Resources - Apollo $119,329
pwtwalls.com - The Artisan, 510 Tremont $77,639
Coveredclad - Humo & Fuego, Gainesville $60,750
💡 Top opportunity: Skanska USA at $365K could be a major win
🎧

Gorgias Customer Support

Open Tickets
57
Needs attention
Email Channel
91%
Primary channel
Chat
3
Live chat tickets
Social
5
FB + Instagram

📋 Recent Open Tickets (Needs Review)

Subject Channel Status
upcoming sales 📧 email PROMOTION
Not at those prices sorry 📘 facebook Open
Product Question 💬 chat Open
APPs (IOS & Android)? 📧 email Open
Direct message with maikdrassdo 📸 instagram Open
⚠️ Note: Some open tickets are spam/marketing emails that should be auto-closed

🤖 AI Handling Tags

ai_answered
Auto-resolved
ai_handover
Needs Human
ai_processing
In Progress
ai_failed_action
Failed
💡 Maxrow Integration: Can poll & respond to tickets via API — ask to enable
📱

Meta Ads Performance

7-Day Spend
$2,267.86
Impressions
103.6K
Clicks
5,315
CPC
$0.43
CPM
$21.90
Link Clicks
3,703
Landing Page Views
2,012
Add to Cart
177
Meta Purchases
31
⚠️ May include samples
🛒

Shopify Orders (Segmented)

Full
Full Orders
21
Full
Full Revenue
$10,874
Leads
Sample Orders
99
Leads
Sample Value
$1,416
Not counted as revenue

Recent Full Orders

Order Customer Type Total
#223590 Kristian Full $117.79
#223580 Michael Full $956.54
#223579 Kirsten Full $228.66
#223575 John Full $318.94
#223572 Luther R Full $687.15
#223569 Kaila Full $1,004.87
#223562 Bernard Full $224.91
#223559 Corinne Full $425.89
#223554 Cora Full $213.86
#223545 William Full $193.39
📊

GA4 Website Traffic

Total Sessions
5,216
Active Users
4,302
GA4 Revenue
$6,591
May differ from Shopify
🔍

Search Console

Total Clicks
1,322
Impressions
246.5K

Top Search Queries

Query Clicks Pos
stikwood 35 1.1
stickwood 16 1.6
shiplap vs beadboard 14 1.0
what is shiplap 12 3.9
beadboard 11 1.7
beadboard vs shiplap 9 2.1
mdf wood 7 10.3
shiplap vs nickel gap 7 2.1
how to install shiplap... 6 1.7
shiplap 6 4.0
📧

Klaviyo Email Marketing

Campaign Recipients (30d)
--
Open Rate
--
Click Rate
--
Campaign Revenue (30d)
--

Recent Campaigns

Campaign Sent Opens Clicks
Loading...

Top Flows by Revenue (30d)

Total Flow Revenue
--
Flow Recipients Revenue $/Recip
Loading...