Which of your shoot locations brings in the most revenue? Here’s how to find out with Light Blue.

We recently had a great question land in our support inbox from David, a portrait photographer who works in a variety of locations:

“I’m trying to run a query to see which location has generated the most income in 2024.”

It’s exactly the kind of smart, business-focused question we love to help with – because it shows how useful Light Blue’s reporting tools can be for making strategic decisions.

Here’s what we suggested:

1. Open the Query tool and set up a search for all the shoots you want to include – for example, shoots with a status of Confirmed or Completed, with a start date in the last calendar year. You can narrow it down further by shoot type if you’d like.
2. View the results in the List View.
3. Go to Window > Customise List View to tailor the view to your needs.
4. Add Location to the Group by section.
5. Make sure the Sales column is included, so you can see totals and averages.
6. That’s it! You’ll now see all your shoots grouped by location, with revenue data for each one.

This kind of insight is incredibly useful for portrait photographers working across multiple locations, as well as wedding and event photographers. It can help you spot which places are generating the most bookings – and, more importantly, the most income.

You might decide to prioritise your most profitable locations, or concentrate your marketing efforts on venues and areas that deliver the best results.

Got a question about how to get more from Light Blue’s reporting tools? Drop us a message – we love helping you uncover valuable insights like these!