Loading data…
Data refreshes on login
Bank⟳
—
Balance
—
Accounts
—
Positive
QuickBooks⟳
—
Total Income
—
Total Expenses
—
Net Income
Square⟳
—
Total Sales
—
Transactions
—
Avg Sale
Google Analytics⟳
—
Sessions
—
Users
—
Bounce Rate
Meta Ads⟳
—
Total Spend
—
Clicks
—
CTR
Yelp⟳
—
Rating
—
Reviews
—
Views
Total Balance
—
All Bank Accounts
| Account Name | Type | Balance |
|---|---|---|
| Loading... | ||
Profit & Loss
Balance Sheet
Date Range
Total Income
—
Cost Of Goods Sold
—
Total Expenses
—
Net Income
—
Profit & Loss Statement
| Account / Category | Amount |
|---|---|
| Select a date range and click Run Report | |
Beyond Marketing
Think Bullish
Advert Logix
Cobia Marketing
Date Range
Sessions
—
Total visits to your website.
Active Users
—
Unique individuals who visited.
New Users
—
First-time visitors in this period.
Bounce Rate
—
% who left after one page. Lower is better.
Avg Session Duration
—
Avg time spent per visit.
Page Views
—
Total pages viewed.
Top Pages
| Page | Views | Users |
|---|---|---|
| Run report to load | ||
Traffic Sources
| Channel | Sessions |
|---|---|
| Run report to load | |
What these mean
Organic Search — Visitors who found you through Google or other search engines without paid ads.
Direct — Visitors who typed your URL directly or used a bookmark.
Organic Social — Visitors who came from unpaid social media posts (Instagram, Facebook, etc).
Referral — Visitors who clicked a link from another website.
Paid Search — Visitors from Google Ads or other paid search campaigns.
Unassigned — Traffic Google couldn't categorize, often from apps or missing tracking data.
Data From Last 30 Days
Impressions
—
Page Visits
—
Page Visits from Ads
—
Total Leads from Yelp
—
Total Leads from Yelp Ads
—
Date Range
Total Sales
—
Transactions
—
Avg Transaction
—
Sales by Location
Revenue by Service
| Service | Qty Sold | Net Revenue | % of Total |
|---|---|---|---|
| Loading... | |||
Date Range
Total Leads
—
Total Open
—
Total Closed Won
—
Total Closed Lost
—
Service Performance Overview
INTEGRATED PLATFORM
Practice Fusion
Electronic Health Records
EHR
Platform
HIPAA
Compliant
Cloud
Based
Access patient records, appointments, clinical notes, and billing — all in one secure, cloud-based EHR system built for modern practices.
Open Practice Fusion
Secured with end-to-end encryption · Opens in new tab
DOCUMENT MANAGEMENT
Microsoft SharePoint
Hawaii Wellness Clinic Portal
Docs
& Files
Team
Collaboration
M365
Integrated
Your central hub for company documents, training materials, SOPs, and internal resources — organized and accessible to your entire team.
Open SharePoint
Secured by Microsoft 365 · Opens in new tab
PRICING REFERENCE
Master Price List
Hawaii Wellness Clinic — All Services
Live
Pricing
Excel
Online
All
Locations
The master reference for all HWC service pricing across every location. Always up to date — opens directly in Microsoft Excel Online for easy viewing and editing.
Open Master Price List
Hosted on SharePoint · Opens in Microsoft Excel Online
Apps Script Web App URL
This is the Google Apps Script URL that reads your Google Sheet. You already created this — paste it here once and it's saved permanently in your browser.
Tab Name Mapping
Enter the exact tab names from your Google Sheet. Must match exactly — including capitalization and spaces.
Available Tabs in Your Sheet
Save your Apps Script URL above to see your available tabs.
How your data pipeline works:
Make.com runs daily → pulls data from QuickBooks, Meta Ads, GHL, GA → writes into Google Sheets tabs → this dashboard reads those tabs automatically via your Apps Script URL → data always stays fresh with zero manual work.
Make.com runs daily → pulls data from QuickBooks, Meta Ads, GHL, GA → writes into Google Sheets tabs → this dashboard reads those tabs automatically via your Apps Script URL → data always stays fresh with zero manual work.