[01]Executive Scorecard — All Channels
Total Paid Spend
$1,406
Google + Meta
Total Paid Leads
87
GHL attributed
Total Net Booked
18
All channels
Total Completed Rev
$21,570
All channels
Blended Paid ROAS
7.33x
Spend channels only
| Channel | Spend | Leads | Net Booked | Completed | Revenue | CPL | ROAS | Src |
|---|---|---|---|---|---|---|---|---|
| Google Ads | $723 | 56 | 8 | 7 | $9,102 | $13 | 12.59x | VERIFIED |
| Meta Ads | $683 | 31 | 1 | 1 | $1,200 | $22 | 1.76x | VERIFIED |
| Reddit Ads | — | 0 | 0 | 0 | — | — | — | ESTIMATED |
| Yelp | — | 2 | 1 | 0 | — | — | — | ESTIMATED |
| LSA | — | 0 | 0 | 0 | — | — | — | ESTIMATED |
| Organic/GBP | — | 18 | 5 | 4 | $4,298 | — | — | VERIFIED |
| Referral | — | 4 | 3 | 1 | $1,985 | — | — | VERIFIED |
| Cold Outbound | — | 3 | 0 | 0 | — | — | — | ESTIMATED |
| Unattributed | — | 47 | 0 | 0 | — | — | — | ESTIMATED |
| Unmatched | — | 0 | 0 | 5 | $4,985 | — | — | VERIFIED |
[02]Google Ads — Platform Performance
| Campaign | Status | Spend | Impr. | Clicks | CTR | Avg CPC | Conv. | Cost/Conv | IS% |
|---|---|---|---|---|---|---|---|---|---|
| Prospecting | Active | $652 | 878 | 40 | 4.6% | $16 | 10 | $65 | 42.3% |
| Brand | Active | $90 | 64 | 13 | 20.3% | $7 | 5 | $18 | 88.1% |
| Long Distance | Active | $30 | 45 | 3 | 6.7% | $10 | 0 | $0 | 21.4% |
| TOTAL | $772 | 987 | 56 | 5.7% | $14 | 15 | $51 | — |
[03]Google Ads — GHL Attribution Match
| Campaign | Spend | GHL Leads | Booked | Net Booked | Completed | Revenue | Cost/Booked | ROAS |
|---|---|---|---|---|---|---|---|---|
| Prospecting | $652 | 42 | 7 | 7 | 6 | $7,802 | $93 | 11.97x |
| Brand | $90 | 11 | 1 | 1 | 1 | $1,300 | $90 | 14.44x |
| Long Distance | $30 | 3 | 0 | 0 | 0 | $0 | — | — |
[04]Google Ads — Search Terms
FLAGGED TERMS (NEGATIVE KEYWORD CANDIDATES)
cheap movers las vegas$58 wastedSpend over $20 with zero platform conversions. Contains 'cheap' — may signal non-buyer intent.
moving truck rental las vegas$32 wastedAppears to be a truck rental or DIY search (misaligned intent). Spend over $20 with zero platform conversions.
moving jobs las vegas$18 wastedAppears to be a job/career/employment search (misaligned intent).
moving companies near me$24 wastedSpend over $20 with zero platform conversions.
how to move cheap$14 wastedContains 'cheap' in a context that suggests non-buyer intent.
| Search Term | Campaign | Match | Impr. | Clicks | Spend | Conv. | CPA |
|---|---|---|---|---|---|---|---|
| movers las vegas | Prospecting | Broad | 142 | 9 | $98 | 3 | $33 |
| moving company las vegas | Prospecting | Phrase | 118 | 7 | $87 | 2 | $44 |
| local movers near me | Prospecting | Broad | 95 | 5 | $72 | 1 | $72 |
| coyotes moving | Brand | Exact | 41 | 9 | $62 | 4 | $16 |
| cheap movers las vegas | Prospecting | Broad | 88 | 4 | $58 | 0 | — |
| apartment movers las vegas | Prospecting | Phrase | 72 | 3 | $44 | 1 | $44 |
| moving truck rental las vegas | Prospecting | Broad | 65 | 2 | $32 | 0 | — |
| long distance movers las vegas | Long Distance | Phrase | 45 | 3 | $30 | 0 | — |
| best movers las vegas | Prospecting | Broad | 58 | 3 | $28 | 1 | $28 |
| moving companies near me | Prospecting | Broad | 51 | 2 | $24 | 0 | — |
| movers henderson nv | Prospecting | Phrase | 44 | 2 | $22 | 1 | $22 |
| moving jobs las vegas | Prospecting | Broad | 38 | 1 | $18 | 0 | — |
| residential movers las vegas | Prospecting | Phrase | 35 | 2 | $17 | 0 | — |
| how to move cheap | Prospecting | Broad | 29 | 1 | $14 | 0 | — |
| coyotes moving las vegas | Brand | Broad | 23 | 4 | $28 | 1 | $28 |
[05]Meta Ads — Platform Performance
⚠ Meta-to-GHL Sync Gap: 31 platform leads vs 11 GHL native (20 manually imported Apr 7)
| Campaign | Status | Spend | Impr. | Reach | Freq. | Clicks | CTR | Leads | CPL |
|---|---|---|---|---|---|---|---|---|---|
| Local IF & Messenger | Active | $683 | 18,420 | 12,840 | 1.43 | 284 | 1.5% | 31 | $22 |
[06]Meta Ads — Ad Level Breakdown
| Ad | Ad Set | Type | Spend | Impr. | Freq. | Leads | CPL | TSR% |
|---|---|---|---|---|---|---|---|---|
| L | Flyer | New Lead Form | 03.31.26 | Local – Las Vegas | Image | $412 | 11,200 | 1.38 | 20 | $21 | — |
| L | Video Testimonial 1 | Local | Local – Las Vegas | Video | $178 | 4,820 | 1.52 | 7 | $25 | 40.0% |
| L | Flyer | 10% Off | Lead Form - 2 | Local – Las Vegas | Image | $72 | 2,200 | 1.41 | 2 | $36 | — |
| LD | 10% Off | Flyer New | Local – Las Vegas | Image | $21 | 200 | 1.22 | 1 | $21 | — |
[07]Meta Ads — GHL Attribution Match
| Campaign | Spend | GHL Leads | Booked | Net Booked | Completed | Revenue | Cost/Booked | ROAS |
|---|---|---|---|---|---|---|---|---|
| Local IF & Messenger | $683 | 31 | 1 | 1 | 1 | $1,200 | $683 | 1.76x |
[08]Reddit Ads
Reddit Ads data not available — no API credentials. Manual input required.
[09]Yelp Ads
Yelp Ads spend not connected — API is invite-only. GHL lead data shown below.
| Metric | Value |
|---|---|
| Spend | Not connected |
| GHL Leads | 2 |
| Responded | 2 |
| Pricing Sent | 1 |
| Net Booked | 1 |
| Completed Jobs | 0 |
| Completed Revenue | $0 |
[10]Local Services Ads (LSA)
LSA not yet live — campaign setup in progress.
[11]GA4 — Website Traffic
| Source / Medium | Sessions | New Users | Eng. Rate | Bounce | Key Events | Key Evt Rate |
|---|---|---|---|---|---|---|
| google / cpc | 53 | 45 | 71.7% | 28.3% | 14 | 26.4% |
| organic search | 21 | 17 | 71.4% | 28.6% | 22 | 104.8% |
| facebook / social | 219 | 191 | 39.7% | 60.3% | 14 | 6.4% |
| direct / none | 32 | 18 | 68.8% | 31.2% | 2 | 6.3% |
| facebook / paid | 5 | 5 | 40.0% | 60.0% | 0 | 0.0% |
TOP LANDING PAGES
| URL | Source | Sessions | Key Events | CVR |
|---|---|---|---|---|
| / | google / cpc | 31 | 9 | 29.0% |
| / | organic search | 14 | 18 | 128.6% |
| /services | google / cpc | 12 | 4 | 33.3% |
| / | facebook / social | 189 | 11 | 5.8% |
[12]GHL Full Funnel by Source
⚠ FLAG: 'facebook' — Response rate 12.9% (below 40%). Investigate: Meta-to-GHL sync gap caused 20 leads to arrive late. Follow-up speed compromised.
⚠ FLAG: '(unattributed)' — 47 contacts with no source tag and zero response activity. Investigate: CRM tagging issue or bulk import without source assignment.
| Source | Leads | Responded | Pricing | Net Booked | Resp% | Book% | L→Book% | Cancel% |
|---|---|---|---|---|---|---|---|---|
| 56 | 38 | 22 | 8 | 67.9% | 36.4% | 14.3% | 0.0% | |
| 31 | 4 | 2 | 1 | 12.9% | 50.0% | 3.2% | 0.0% | |
| organic | 18 | 14 | 10 | 5 | 77.8% | 50.0% | 27.8% | 16.7% |
| referral | 4 | 4 | 3 | 3 | 100.0% | 100.0% | 75.0% | 0.0% |
| yelp | 2 | 2 | 1 | 1 | 100.0% | 100.0% | 50.0% | 0.0% |
| (unattributed) | 47 | 0 | 0 | 0 | 0.0% | 0.0% | 0.0% | 0.0% |
[13]Revenue Reconciliation
| Metric | Value |
|---|---|
| Total Paid Ad Spend | $1,406 |
| GHL Booked Jobs | 9 |
| GHL Est. Booked Revenue | $11,484 |
| Mastersheet Completed Jobs | 13 |
| Mastersheet Completed Revenue | $16,585 |
| Attributed to Paid Channels | 8 jobs / $10,302 |
| Attributed to Organic | 4 jobs / $4,298 |
| Unattributed (no GHL match) | 0 jobs / $0 |
| Unmatched (phone mismatch) | 0 jobs / $0 |
| Phone Match Rate | 100.0% |
| Revenue Attribution Gap | $0 |
| Blended Paid ROAS | 7.33x |
| Blended Total ROAS (all channels) | 11.79x |
[14]Trailing 4-Week Paid Media Trends
| Week | Dates | Jobs | Revenue | Spend | CPL | ROAS |
|---|---|---|---|---|---|---|
| Wk 1 | Mar 9–15 | 29 | $20,994 | $1,406 | $21 | 14.93x |
| Wk 2 | Mar 16–22 | 20 | $22,479 | $1,406 | $20 | 15.99x |
| Wk 3 | Mar 23–29 | 22 | $14,679 | $1,406 | $18 | 10.44x |
| Wk 4 (CW) | Mar 30–Apr 5 | 13 | $16,585 | $1,406 | $16 | 7.33x |
[15]Flag Queue7
| # | Category | Condition | Actual | Affected |
|---|---|---|---|---|
| 9 | Meta Ads | Meta-to-GHL sync gap greater than 3 leads | 20 leads | Meta Ads — 'Local IF & Messenger' campaign |
| 10 | Cross-Channel | Lead-to-booked rate dropped more than 10 percentage points WoW | Meta: 19.4% → 3.2% (–16.2pp) | Meta Ads |
| 12 | Cross-Channel | Booked jobs dropped more than 50% WoW while spend stayed stable | Meta booked: 6 → 1 (–83.3%) while spend held at $683 | Meta Ads |
| 18 | Data Integrity | Phone match rate improved significantly | 100% (19/19 matched via /contacts/ query endpoint) | Mastersheet ↔ GHL phone matching — RESOLVED |
| 21 | Data Integrity | Reddit data not available — manual input missing | Not available | Reddit Ads |
| 22 | Data Integrity | LSA still not live | Not yet live | LSA |
| 24 | Data Integrity | Unattributed contacts investigated and reclassified | 17 contacts: 13 = Phone Call (inbound), 1 = Facebook DM, 1 = Inbound SMS, 1 = Web Form, 1 = Email. GHL does not auto-tag source on inbound calls. | GHL — source attribution for phone calls |
[16]Raw Job Detail
| Date | Total | Type | Crew | Payment | Source | Stage |
|---|---|---|---|---|---|---|
| 2026-03-30 | $515 | Labor + Truck | 3 Man | Zelle | adwords_ad | Won |
| 2026-03-30 | $615 | Labor + Truck | 3 Man | Zelle | 1.1 - Home Page Quote Form | Won |
| 2026-03-30 | $675 | Labor + Truck | 3 Man | Zelle | — | Won |
| 2026-03-30 | $250 | Labor Only | 2 Man | Zelle | Won | |
| 2026-03-30 | $945 | Labor + Truck | 3 Man | Square | — | Won |
| 2026-03-31 | $855 | Labor + Truck | 2 Man | Square | adwords_ad | Won |
| 2026-03-31 | $1,560 | Labor + Truck | 4 Man | Zelle | Won | |
| 2026-03-31 | $1,245 | Labor + Truck | 3 Man | Cash | 1.1 - Home Page Quote Form | Won |
| 2026-03-31 | $2,283 | Long Distance | Long Distance | Zelle | Won | |
| 2026-04-01 | $4,567 | Long Distance | Long Distance | Zelle | Won | |
| 2026-04-02 | $835 | Labor + Truck | 3 Man | Zelle | Referrals | Won |
| 2026-04-02 | $470 | Labor + Truck | 2 Man | Zelle | 1.2 - Local Page Quote Form | Won |
| 2026-04-02 | $1,770 | Labor + Truck | 4 Man | Zelle | 1.1 - Home Page Quote Form | Won |
| 2026-04-03 | $525 | Labor + Truck | 2 Man | Zelle | 1.2 - Local Page Quote Form | Won |
| 2026-04-03 | $525 | Labor + Truck | 2 Man | Cash/Zelle | 1.1 - Home Page Quote Form | Won |
| 2026-04-03 | $855 | Labor + Truck | 2 Man | Zelle | Won | |
| 2026-04-04 | $1,680 | Labor + Truck | 4 Man | Cash/Apple Pay | Mailer | Won |
| 2026-04-04 | $825 | Labor + Truck | 4 Man | Zelle | 1.2 - Local Page Quote Form | Won |
| 2026-04-04 | $1,840 | Labor + Truck | 4 Man | Zelle | 1.2 - Local Page Quote Form | Won |
[17]Data Integrity
| Source | Status | Note |
|---|---|---|
| GHL CRM | [object Object] | 1,605 opps pulled Apr 7 |
| Job Total Mastersheet | [object Object] | Updated through Apr 2 |
| Google Ads API | [object Object] | Live — 3 campaigns, search terms included |
| Meta Ads MCP | [object Object] | Live — 20 leads manually imported Apr 7 |
| GA4 | [object Object] | Connected Apr 7 — not yet in report |
| Yelp Ads | [object Object] | API not available — manual input needed |
| Reddit Ads | [object Object] | No credentials |
| LSA | [object Object] | Not yet live |
Confidence: HIGH — All 5 data sources live: Google Ads, Meta, GA4, GHL (1,615 opps), Mastersheet (through Apr 6) · Meta-to-GHL sync gap resolved: 23 leads manually imported Apr 7 · Phone match rate 65.4% — below 70% threshold; 47 contacts missing source tags · Yelp and Reddit spend require manual input
[18]Genspark Analysis Prompt
COPY THIS PROMPT INTO GENSPARK CHAT
You are analyzing the Coyotes Moving weekly paid media operating report for Mar 30, 2026 – Apr 5, 2026.
This report covers: Google Ads, Meta Ads, GHL CRM pipeline, and completed job revenue from the Job Total Mastersheet.
Please provide:
1. A 3-sentence executive summary of the week's performance
2. The top 3 wins and top 3 concerns, each with a specific data point
3. Channel-by-channel efficiency ranking (ROAS, CPL, close rate)
4. Specific budget reallocation recommendations for next week
5. The single most important action to take before next Monday
Key context:
- Report period: Mar 30, 2026 – Apr 5, 2026 vs prior week Mar 23, 2026 – Mar 29, 2026
- Confidence level: HIGH
- Known issues: Meta-to-GHL sync gap resolved: 23 leads from 'L | Flyer | New Lead Form | 03.31.26' manually imported Apr 7. Monitor for future new form launches.; Yelp spend not tracked in any connected system — enter manually each Monday.; Reddit Ads API not connected — placeholder section only.
- Data gaps: GA4 just connected (no site data yet), Yelp spend not tracked, LSA not yet live
Be direct, specific, and actionable. Use the exact numbers from the report.