Marketing Dashboard

Loading Dashboard
Connecting to ServiceTitan...

Unified Marketing Dashboard

Real-time ServiceTitan + Google Ads • CPA, Conversion Rate, Revenue & ROI

Account Name:

ServiceTitan: --
Google Ads: --
Last updated: --
Total Calls
?
Total Calls Count of all inbound calls with campaign attribution from ServiceTitan Telecom API.
COUNT(calls WHERE campaign_id EXISTS)
Source: ServiceTitan Telecom API
0
ServiceTitan
Answered Calls
?
Answered Calls Count of all inbound calls with campaign attribution from ServiceTitan Telecom API having call duration greater than 0.
COUNT(calls WHERE campaign_id EXISTS and duration > 0)
Source: ServiceTitan Telecom API
0
Service Titan
Missed Calls
?
Total Calls Count of all inbound calls with campaign attribution from ServiceTitan Telecom API having call duration less than equal to 0.
COUNT(calls WHERE campaign_id EXISTS and duration <= 0)
Source: ServiceTitan Telecom API
0
Service Titan
Google Generated Calls
?
Google Generated Calls Count of all inbound calls with campaign attribution from ServiceTitan Telecom API and having call campaign category as INTERNET.
COUNT(calls WHERE campaign_id EXISTS and campaign category = INTERNET)
Source: ServiceTitan Telecom API
0
Service Titan
Average Duration
?
Average Duration It's a ration of total duration and total calls.
Total Duration / Total Calls)
Source: ServiceTitan Telecom API
0
Service Titan
Average First Time Call Rate
?
Average First Time Call Rate Count of all inbound calls with campaign attribution from ServiceTitan Telecom API and created date and call date same or membership length not exist or a single contact.
Total First Time Call / Total Calls
Source: ServiceTitan Telecom API
0
Service Titan
Booked Jobs
?
Booked Jobs Jobs with a valid booking status and cancelled bookings linked to marketing campaigns. showing Booked Jobs/Cancelled Jobs = Total Jobs
COUNT(jobs WHERE status IN [Completed, Dispatched, Hold, Scheduled] and [Canceled])
Source: ServiceTitan Jobs API
0
ServiceTitan
All Calls Booking Rate
?
All Calls Booking Rate Percentage of calls that converted into booked jobs. Higher is better.
(Booked Jobs / Total Calls) × 100
Source: Calculated from ServiceTitan data
0%
Jobs ÷ Calls
Actual Booking Rate
?
Actual Booking Rate Percentage of total leads that converted into booked jobs. Higher is better.
(Booked Jobs / Total Leads) × 100
Source: Calculated from ServiceTitan data
0%
Jobs ÷ Calls
Revenue
?
Revenue Total revenue from invoices linked to jobs that came from marketing campaigns.
SUM(invoice.total WHERE job.campaign_id EXISTS)
Source: ServiceTitan Accounting API
$0
ServiceTitan Invoices
Future Revenue
?
Future Revenue Total revenue from invoices linked to jobs which are Scheduled but not Completed.
SUM(jobs.total)
Source: ServiceTitan Accounting API
$0
ServiceTitan Jobs
Total Revenue
?
Total Revenue Total revenue from invoices + job total which are invoiced and which are are scheduled.
SUM(invoice.total + jobs.total)
Source: ServiceTitan Accounting API
$0
ServiceTitan Invoices and Jobs
Ad Spend
?
Ad Spend Total advertising spend from Google Ads campaigns in the selected date range.
SUM(cost_micros) ÷ 1,000,000
Source: Google Ads API
$0
Google Ads
CPA
?
Cost Per Acquisition (CPA) Average cost to acquire one booked job. Lower is better.
Ad Spend / Booked Jobs
Source: Google Ads + ServiceTitan
$0
Spend ÷ Jobs
Cost/Call
?
Cost Per Call Average cost to generate one inbound call. Lower is better.
Ad Spend / Total Calls
Source: Google Ads + ServiceTitan
$0
Spend ÷ Calls
ROI
?
Return on Investment (ROI) Percentage return on ad spend. 100% means you doubled your money.
((Revenue - Ad Spend) ÷ Ad Spend) × 100
Source: Google Ads + ServiceTitan
0%
(Rev - Spend) / Spend
Clicks
?
Clicks Count of all clicks data from Google Ads API.
COUNT(clicks WHERE campaign_id EXISTS)
Source: ServiceTitan Telecom API
0
Google Ads
Cost Per Click
?
Cost Per Click Ratio of total Spend and total clicks data from Google Ads API.
Total Spend / Total Clicks
Source: ServiceTitan Telecom API
0
Google Ads
ROAs
?
ROAs Ratio of the Total service titan revenue and google ad spend.
Total Service Titan Revenue / Google Ad Spend
Source: ServiceTitan Telecom API
0
Google Ads
CPA Over Time ?
CPA Over Time Daily cost per acquisition trend. Shows how efficiently ad spend converts to booked jobs.
Ad Spend ÷ Booked Jobs
Booking Rate Over Time ?
Booking Rate Trend Daily percentage of calls that convert to booked jobs. Higher is better.
(Jobs ÷ Calls) × 100
Calls & Jobs ?
Volume Over Time Daily count of inbound calls (blue) and booked jobs (orange) from marketing campaigns.
Revenue Over Time ?
Revenue Trend Daily revenue from invoices linked to marketing-attributed jobs.
Source: ServiceTitan Accounting API
Booked Jobs ?
Booke Jobs Booked Jobs over time in given date range
Booked Jobs Revenue ?
Booke Jobs Revenue Booked Jobs Revenue over time in given date range
Cost Per Job ?
Cost Per Job Cost per Jobs over time in given date range
Cost Per Call ?
Cost Per Call Cost per Call over time in given date range.
Calls Total ?
Calls Total Calls Total over time in given date range.
Conversion Rate (Calls into Jobs) ?
Conversion Rate (Calls into Jobs) Calls converted to Jobs over time in given date range.
Ad Spends ?
Ad Spends Ad Spends over time in given date range.
Cancelled Jobs ?
Cancelled Jobs Cancelled Jobs over time in given date range.
Campaign Performance
Campaign Calls ?
Calls Inbound calls attributed to this campaign.
Source: ServiceTitan
 		Jobs ?
Jobs Booked jobs from this campaign.
Source: ServiceTitan
 		Leads ?
Leads Lead calls from this campaign.
Source: ServiceTitan
 		Cancelled Jobs ?
Cancelled Jobs
COUNT(Cancelled Jobs from Jobs data)
Source: ServiceTitan
 		Booking % ?
Booking Rate
Jobs ÷ Calls × 100
Source: Calculated
 		Cancellation % ?
Cancellation Rate
(Cancelled Jobs ÷ All Jobs Including Cancelled) × 100
Source: Calculated
 		Revenue ?
Revenue Total invoice revenue from this campaign's jobs.
Source: ServiceTitan