Daily Overview

AZ | TX Advanced Imaging
📅
📊

Monthly Insights

Connect your data to generate monthly insights.

🗓️

YTD Insights

Connect your data to generate year-to-date insights.

📋

Daily Insights

Connect your data to generate insights.

📍

No Locations Connected

Add CSV URLs in Data Setup to see per-location performance.

Tech Efficiency

Connect your data to view per-tech performance.

🎓

Tech Coaching

Connect your data to generate coaching cards for each active tech.

📅

Year to Date

Connect your data to view YTD performance.

⚠️

No-Show Tracker

No-show analysis by location will appear here once connected.

📅

Weekly Summary

Week-to-date totals and comparisons will appear here once connected.

📆

Month-over-Month

Connect your data in Data Setup to see MoM comparisons.

Cancellation & Reschedule

Connect your data in Data Setup to see cancellation analysis.

📊

Claustrophobia Trend

Connect your data in Data Setup to see claustro rate trends.

📅

Show Rate by Day of Week

Connect your data in Data Setup to see day-of-week patterns.

⚖️

Compare Locations

Connect your data in Data Setup to compare locations head-to-head.

🔥

Show Rate Streaks

Connect your data in Data Setup to see streak tracking.

🎓

Location Scorecard

Connect your data in Data Setup to see location grades.

🎯

Target Tracker

Connect your data in Data Setup to track goals vs actuals.

🩻

Imaging Volume

Add your Counts sheet URL in Data Setup to see scan type breakdown.

📡

Connect Google Sheet Data

Two separate data sources. Publish each as CSV — one-time setup, saves automatically.

High Level Summary — Master Sheet DOMINANT SOURCE

Curated by ops with clean tech names, properly separated Reschedule (col G) and Add-Ons (col I) columns. Dashboard auto-merges this with each location tab on every load — master wins on tech names and reschedule/add-on counts; per-location wins on SCH/SEEN/NO SHOW/CLAUSTRO/CANCELLED. Fixes the Phoenix tech-ID issue automatically.

What this does: auto-fills the location URL list below with all 8 published-CSV URLs from the master document (Central, Chandler, Mesa, Phoenix, Scottsdale, Tucson, Tucson Open, West Phoenix), and registers the High Level Summary master tab for cross-reference. Click Load / Refresh after.
🔍 Google Search Console External tool

Click below to open Search Console for azadvancedimaging.com in a new tab. SEO data lives natively in GSC's own UI — no integration needed.

Open Search Console ↗
📘
Data Import Guide
Step-by-step instructions for Isaac and the team — which tabs to create, exact column formats, how to publish as CSV, update schedule, and troubleshooting.
🩻 Counts Sheet — Scan Type Data SCAN MIX PAGE

This is your Counts Google Sheet — the one with MRI, CT, US, and X-Ray counts per location. Paste its published CSV URL here.

How to get this URL: Open the Counts sheet → File → Share → Publish to web → select first tab → CSV → Publish → copy URL.
📍 Location Schedule Tabs — Daily Data

These are your 8 Arizona location tabs from the ARIZONA SCHEDULE TRACKER — Mesa, Chandler, Phoenix, etc. Each needs its own CSV URL.

1 Open ARIZONA SCHEDULE TRACKER
2 File → Share → Publish to web
3 Select a location tab (e.g. Mesa_NEW) → CSV → Publish
4 Paste URL below with the location name. Repeat for each.
Add a location
🏥 RamSoft PACS/RIS — Clinical Data Tabs PHASE 2 · OPTIONAL

When RamSoft scheduled exports are set up, they write to new tabs in your Google Sheet. Add the published CSV URLs for each tab below. Leave empty until exports are configured by Isaac. The dashboard will use these automatically when data appears — no existing data is affected.

📅 OpenDR Scheduling — Appointment Data Tabs PHASE 2 · OPTIONAL

When OpenDR analytics exports are configured, they write to new tabs in your Google Sheet. Add the published CSV URLs below. Leave empty until exports are configured.

🔍 Data Diagnostic

Shows exactly what dates are loaded per location and what the dashboard thinks "today" is.

🏆

Tech Leaderboard

Connect your data in Data Setup to see tech performance rankings.

Add-Ons Conversion

Connect your data in Data Setup to see add-on rates by location.

📨

Location Briefing

Connect your data in Data Setup to generate site manager briefings.

🔔

Alerts

Connect your data in Data Setup to see automated alerts.