How to build a crossover report

In this article, we are going to show you how to build a crossover report in Your Reports. Crossover reports are a brilliant way of getting to know your customers a little better and develop your targeted marketing strategy. 

What is a crossover report?

You might already have a good understanding of your different audience segments and their characteristics - for example, maybe you know that your Panto bookers are often families, only attend once a year, and typically buy between 2 - 4 tickets. You can pretty confidently say that they are a good target segment for future Pantos, and probably other family shows. But, what else are you missing?

This is where crossover reports come in! Crossover reports allow you to take a segment of customers, like Panto bookers, and explore what other shows or genres they have booked for and may be inclined to book for again. You can then use this data to understand the relationships between shows, and expand your targeted marketing to new customer segments. For example, you might find that your Panto bookers also love to dance the night away at live music nights!

How to build a crossover report

To create a crossover report you will need to create two separate reports:

Report A is for the show/event category that you want to analyse and Report B will show you what the crossovers are. 

Create your segment of bookers (Report A)

1. To create Report A go to Reports > Your Reports.

  • Create a new report by clicking on Add New and then Report.


2. Name the report and then:

  • Add it to a folder.
  • Select the type Line Items Facts View report type because we want to look at ticket sales data.
  • Click Save.  


3. Now you select the filter.

To look at the crossover by a show select the filter saw shows...

saw_shows.png find the crossover by an event category select the filter events of category


In this example, we will look at a crossover analysis for customers who purchased tickets to a panto show, so we are using the filter saw shows.

  • Search for the show.
  • Click to include it.
  • Click Save.


Bring your segment into a new report to explore what else they have booked for (Report B).

1. To create Report B go to Reports > Your Reports.

  • Create a new report by clicking on Add New and then Report.

2. Name the report and then:

  • Add it to a folder.
  • Select the type Line Items Facts View report type.
  • Click Save

 3. Now select the filter based on customers in because we want to bring in the segment of customers we created in Report A.


2. Select Report A.

  • Click to include it.
  • Click Save.


3. Now you can use the Reporting Views to explore the data. We'd recommend looking at the Revenue view and looking at the by Show tab to see what other Shows this segment of customers have booked for.

 Ticketsolve Tip

You can also explore the data by Program and Event Category to get a wider picture of what your this segment of customers also books for, or select the Event view for a more granular look at specific dates/times of a Show. 

From here you can also download the data as a CSV to explore and sort it, for example to see which shows had the highest revenue or ticket quantity sold to this customer segment.


Want to Know More?

Was this article helpful?



Please sign in to leave a comment.