Claude.ai & MCP supported — another step towards a more powerful AdzviserRead Me
Templates / Google Sheets / CallRail / CallRail Monthly Performance Dashboard
CallRail+Google Sheets

CallRail Monthly Performance Dashboard

A CallRail monthly performance report for Google Sheets — track calls, leads, answer rate, missed calls, and average call duration at a glance, with source performance, device breakdown, and calls-by-campaign charts, per-agent and per-campaign tables, plus a raw call-level log with tracking and UTM data and a form submissions tab.

Get the template →
CallRail Monthly Performance Dashboard preview

Metrics & Dimensions

The CallRail metrics and dimensions this template is pre-built with — no manual setup needed.

Metrics

Calls
Answered Calls
Missed Calls
Leads
First Time Callers
Answer Rate
Leads Rate
Avg. Call Duration (Sec)
Call Duration (Sec)
Form Submissions
First-Time Submissions
Total Value
Value

Dimensions

Month
Agent Email
Call ID
Call Start Time
Call Direction
Was Answered
First-Time Call
Customer State
Tracking Phone Number
Number Name
Device Type
Lead Status
Call Tags
Call Source
Call Medium
Call Campaign
Call Keywords
Call Landing Page URL
Call UTM Source
Call UTM Campaign
Call GCLID
Setup guide

How to Get Started

Set up your CallRail Google Sheets template in three simple steps.

1

Sign up for Adzviser

Create your account and start your 14-day trial for just $0.99. Cancel anytime. Start your trial

2

Connect CallRail

Link your account through secure authentication and select the data you want to report on. Explore the CallRail connector

3

Copy the template

Open the template in Google Sheets, connect Adzviser, and customize it to your needs. Learn about Google Sheets

CallRail Monthly Performance Dashboard FAQs

This template is prebuilt with 13 metrics and 21 dimensions, along with the charts, tables, formulas, or controls shown in the preview. The Metrics & Dimensions section above lists the exact fields included in this version.

Make a copy of the spreadsheet, connect CallRail to an Adzviser workspace, enter the exact workspace name in the adzviserQuery worksheet, and run Refresh all queries from the Adzviser add-on. Open the CallRail connector guide

Yes. Connect the accounts to your Adzviser workspace, then select or query the accounts needed for the report. For agency workflows, you can also keep a separate copy per client so access, filters, and branding stay independent.

Use Refresh all queries for an on-demand update, or add an automatic refresh trigger from the Adzviser add-on's Schedule tab. Google Sheets triggers can run daily, weekly, or monthly. See refresh instructions

Yes. You can change formulas, charts, pivot tables, formatting, queries, and tabs. Keep imported column names and ranges stable—or update anything that references them—so later refreshes continue feeding the report correctly.

Confirm that you copied the file, installed the Adzviser add-on, connected CallRail, and entered the exact workspace name expected by adzviserQuery. Run Refresh all queries and review any error shown in the add-on sidebar.

Yes. The template itself is free to copy and customize in your own account. You need an Adzviser account when you want to replace its sample data with a live CallRail connection and keep that data refreshed. See Adzviser pricing

Start building reports
with Adzviser

Have a question?