Morning data refresh did not complete
The dashboard may be showing yesterday's data.
Click to expand
Loading...
All Firms
▶
Channel CPCs & Source Breakdown
Loading historical data…
J&M Marketing Insights
Spend Type:
Year:
No data for selected firms.
| ✓ | Year Week # ▼ | Total Cases | Sel. Cases | 4 Wk Avg | 13 Wk Avg | YoY | Broadcast | CTV | Billboards | PPC Brand | PPC Non-Brand | LSA | Meta | Lead Gen | Total Spend | Total CPC | WoW Δ | 4 Wk CPC | 13 Wk CPC | Brand Cases | Brand 4 Wk | Brand 13 Wk | Brand CPC | Brand 4 Wk | Brand 13 Wk | LG Cases | LG CPC | Notes |
|---|
▶
Lead Gen Detail
Click to expand
| Vendor | Cases | Cost | CPC | 4-Wk Avg CPC | Status |
|---|
▶
Cases by Week
Click to expand
Firm:
BLG / JLL / EMB — no DMA data in pipeline
| Year Week # | Total Cases | WoW Δ | 4 Wk Avg | 13 Wk Avg | Total Spend | Cost/Case | Total CPC | WoW Δ | 4 Wk CPC | 13 Wk CPC | Brand Cases | WoW Δ | Brand 4 Wk | Brand 13 Wk | Brand CPC | Brand 4 Wk | Brand 13 Wk |
|---|
Non-Media Marketing Costs
Agency & management fees, SEO services, production, research, billboard installation, events, and consulting. These costs are tracked in the weekly spreadsheet but historically excluded from working spend CPC. Source: weekly spend spreadsheet (future: invoice request sheet via EPIC-JMRECON-31).
Category:
Firm:
Year:
Weeks:
–
Note
Select a firm and at least one category to build the grid.
Saved Entries
No spend entries saved yet.
Add Vendor Column
Remove Vendor Column
⚠ Removing a column hides it from the dashboard. Spend data already in the database is
preserved. If the column header still exists in your Google Drive spreadsheet, re-add the
column to restore it.
Manage Columns
Toggle visibility for individual vendor columns. Hidden columns are excluded from the spend grid but not deleted.
ⓘ The Visits tab shows jacobyandmeyers.com website data only
(Google Analytics 4, property 399569737). Select J&M or All Firms to view.
Channel Breakdown — Selected Week
| GA4 Channel | Visits | WoW | Associated Spend | Cost / Visit | 13-wk Avg Visits |
|---|
13-Week Session Trend
Channel attribution logic:
Direct → Broadcast TV + CTV + Billboard (dark media — drives URL navigation or recall).
Referral → Lead Gen vendor spend. Organic Social → Meta spend.
Organic Search → no spend (unpaid rankings).
Paid Search (PPC + LSA) is excluded from cost/visit — J&M ads use click-to-call ("Call Now" within the ad). Conversions happen by phone before any website visit, so GA4 sessions severely undercount paid search reach. Use ACT case source data for PPC/LSA attribution, not website sessions.
Direct visits spiking after a broadcast window is the primary signal for TV/CTV/Billboard attribution — people who saw the ad and typed the URL directly.
Paid Search (PPC + LSA) is excluded from cost/visit — J&M ads use click-to-call ("Call Now" within the ad). Conversions happen by phone before any website visit, so GA4 sessions severely undercount paid search reach. Use ACT case source data for PPC/LSA attribution, not website sessions.
Direct visits spiking after a broadcast window is the primary signal for TV/CTV/Billboard attribution — people who saw the ad and typed the URL directly.
Case Classification
Bulk:
Source:
| File # | Client | Date | Wk | DMA | ACT Source | Source Modified | Bucket | Classified By |
|---|
⊕ Multi-Season Selector
⇕ Before / After Pivot — Quick Setup
A · Before:
→
B · After:
→
Week-by-Week Comparison
Range A
Range B