Photography KPI Dashboard Template

Each month, return to the Monthly Input sheet and add a new month of data. The KPI Dashboard and Revenue by Category sheets update automatically, so your charts and status indicators always reflect your latest numbers. The Booking Funnel sheet is worth reviewing each month too — enter the raw inquiry and conversion counts from your inbox or CRM, and you'll quickly see whether your conversion rate is trending up or down. Most photographers find that booking conversion is the number they'd been ignoring that matters most.

Print attach rate and cost of doing business per hour are the two metrics most photographers skip entirely. Print attach rate — the percentage of portrait clients who purchase prints or albums — is one of the highest-leverage numbers in the business because a single wall art sale can add $300–$1,500 to a booking with no additional shooting time. CODB per hour is what tells you whether your session fee is actually profitable: once you account for editing time, equipment depreciation, insurance, software subscriptions, and marketing, a $250 portrait session can easily net under $30 per hour of total time invested. Tracking both metrics makes the profitability math visible.