Google campaign report loaded
This page is wired to load Google Ads rows from the customer reporting workspace when an export or importer snapshot is present. It does not change budgets, campaigns, or account settings.
Google spend
6 rows loaded
Load campaign/ad group/keyword rows to make Google comparable to Meta.
Calls + forms
Conversion count before GHL matchback
Separate phone calls, forms, and booked jobs before judging search quality.
Cost per conversion
Calls/forms only
This is useful only after spam calls and unbooked forms are filtered through GHL.
Google ROAS
Revenue matchback pending
Import booked and won revenue before comparing Google against Facebook.
Campaign performance
Google rows will appear here after the export is saved to the attribution workspace. Until then, the page shows the exact data contract needed for the automatic report.
| Campaign | Status | Clicks | Calls | Forms | Spend | Cost/Conv. | Booked | Revenue | ROAS | Note |
|---|---|---|---|---|---|---|---|---|---|---|
| Banner Ads - Tru Shine 2021 | Off | 2180 | 1 | 0 | $1,030.30 | $1,030.30 | Needs GHL | Needs GHL | Needs GHL | Imported live from Google Ads API. |
| Search Campaign - Gutter and Window Cleaning - Expresso Company (RJ) | Off | 5396 | 358 | 246 | $49,518.54 | $81.98 | Needs GHL | Needs GHL | Needs GHL | Imported live from Google Ads API. |
| Window Cleaning Services | Off | 12 | 0 | 0 | $63.15 | Needs GHL | Needs GHL | Needs GHL | Needs GHL | Imported live from Google Ads API. |
| Window Cleaning Services | Off | 0 | 0 | 0 | $0.00 | Needs GHL | Needs GHL | Needs GHL | Needs GHL | Imported live from Google Ads API. |
| Window Cleaning video | Off | 169 | 11 | 0 | $898.10 | $81.65 | Needs GHL | Needs GHL | Needs GHL | Imported live from Google Ads API. |
| neighborhood walking video | Off | 0 | 0 | 0 | $1.84 | Needs GHL | Needs GHL | Needs GHL | Needs GHL | Imported live from Google Ads API. |
Connection boundary
This page does not use credentials, fetch Google Ads data, or touch campaign settings until a secure customer OAuth connection exists. It defines the reporting surface and import data contract.
Connection checklist
Confirm which Google Ads account and conversion actions belong to TruShine.
Export campaign, ad group, keyword/search-theme, spend, clicks, calls, and form conversion rows.
Save the export as `automation/trushine/ads-attribution/data/google-campaigns-2026.csv`.
Map Google calls/forms to GHL contacts or opportunities using phone, email, source, and created date.
Add booked-job and won-revenue columns once secure GHL matchback is available.