This lesson explores segmentation using the PatronBase Marketing Module. 



Key points: 

  • As a verb, to ‘segment’ is to take the action of filtering and dividing an audience, in our case, that’s our patrons and stakeholders - into subgroups of audiences based on some types of shared characteristics.
  • As a noun, each of those subgroups of audiences is called a ‘segment.’
  • The purpose of segmentation is to enable better targeting of campaigns towards specific audiences
  • Utilising segmentation, marketing strategies may be tailored to meet the specific needs, preferences and behaviours of specific groups 
  • Working in the Marketing Module Reporting window we refer to as “running queries” and “mining the patron database”. The reporting window itself may also be referred to as the “query window” or “query engine”.
  • The buttons with left and right pointing arrows add filters to or remove filters from the query. 
  • With the exclude criterion window we are asking the system to exclude those in the added filter group or groups from the audience segment produced 
  • clicking the double arrows clears all the filters from both the include and exclude criterion window in one step 
  • Include Patrons in ANY or ALL of is most important when there are multiple filters selected. ANY has a wider focus, whilst ALL has a narrow focus. The exclude criterion window only has the ANY option. 
  • The report box on the bottom left of the screen gives you options for report outputs
  • The options box gives you further options in relation to data sorting
  • To the right of the options box are some options for including patron relationships. Please contact the support team if you’re interested in using this feature. 
  • Go executes the query
  • On the right of the Go button there is a dropdown menu which presents the options of preview and create fundraising opportunities. Create fundraising opportunities is associated with the PatronBase Fundraising Module - ask the support team for further details. Preview allows you to see a preview of your query without executing it. 
  • Add Patrons to Group > selecting a group from the dropdown menu allows you to add patrons filtered from a query to the selected group. Alternatively you can type a new group name in the field, creating a new group for filtered patrons to be added to. 
  • Add Patrons to Group is useful in a couple of ways: a) saving group segments you can later re-target e.g. with a follow-up campaign b) saving group segments you can use to construct future queries. 
  • If Add Patrons to Group is used with Preview, patrons will not be added to the group until the query is executed, with the Go button. 
  • The Remove Existing Patrons From A Group checkbox will remove filtered Patrons from the selected Group. As with Add Patrons to Group, patrons will not be removed from the the group until the query is executed, with the Go button, allowing you to preview the query first using Preview. Preview also has a count on the bottom left, which helps act as a check on your query. 
  • In addition to previewing and executing a query you can also save a query to reuse. The Save Query button opens a window to allow you to save the query as a file. Select shared drive Z to save the query to Z Drive. You can then click Load Query to select your previous query to load it and run it again.
  • Be careful before running a query of a complete list of everyone in your database - marketing emails should be opt-in.
  • In order to create a list of everyone in your database (including staff, contractors and anyone else) first create a Group Attribute called No-one. This group will be empty. Add the no-one group to the exclude criterion window, choose contact list with all other options (including privacy boxes) deselected. The list extracted will exclude no-one, or include everyone. The number of people can be found on the last page of the report.

Administrator Course Videos

Video Course: Administrator: Lesson 1: The Administration Module - An Overview

Video Course: Administrator: Lesson 2: The Administration Module: How to navigate the toolbar

Video Course: Administrator: Lesson 3: How to set up an operator with Administrator Security Privileges

Video Course: Administrator: Lesson 4: Understanding the Hierarchy: Venue, Production, Performance

Video Course: Administrator: Lesson 5: How to set up a venue - Step 1 - Form Filling

Video Course: Administrator: Lesson 6: How to set up a venue: Step 2: Defining a seating plan for a venue - setting up a section

Video Course: Administrator: Lesson 7: How to set up a venue: Step 3 - Setting up an Area

Video Course: Administrator: Lesson 8: How to set up a venue - Step 4 - Defining a seating plan for a venue - How to create seats

Video Course: Administrator: Lesson 9: How to set up a production (or event): Step 1 - Creating a new production from scratch

Video Course: Administrator: Lesson 10: How to set up a production: Step 2 - Setting up a pricing plan

Video Course: Administrator: Lesson 11: How to set up a Production - Step 3 - Creating Performances

Video Course: Administrator: Lesson 12: How to set up a production - Step 4 - Making the production live online

Video Course: Administrator: Lesson 13: How to set up a production - Step 5: Adding an image and some copy


Box Office Video Course 


Video Course: Box Office Operator: Lesson 1: The Box Office Module - An Overview

Video Course: Box Office Operator: Lesson 2: How to navigate the toolbar

Video Course: Box Office Operator: Lesson 3: Finding a performance using the production list and locating the statistics legend

Video Course: Box Office Operator: Lesson 4: Understanding the Performance Graphic Step 2: Understanding Sections and Areas

Video Course: Box Office Operator: Lesson 5: Understanding Unreserved or General Admittance Displays

Video Course: Box Office Operator: Lesson 6: How to display seats by Status, Type or Hold Code

Video Course: Box Office Operator: Lesson 7: Displaying additional seat info: configuring seat label & cursor text display

Video Course: Box Office Operator: Lesson 8: How to select seats

Video Course: Box Office Operator: Lesson 9: How to place holds, and how to release them

Video Course: Box Office Operator: Lesson 10: How to book a ticket: The standard booking process

Video Course: Box Office Operator: Lesson 11: Ways to find a sale


Administrator Level 2 - Page Styling Course


Video Course: Administrator Level 2: Lesson 1: Page Styling: An Overview

Video Course: Administrator Level 2: Lesson 2: Page Styling: Front Page Styling

Video Course: Administrator Level 2: Lesson 3: Page Styling: Previewing events

Video Course: Administrator Level 2: Lesson 4: Page Styling: List styling and productions list details

Video Course: Administrator Level 2: Lesson 5: Page Styling: Seasons, Donations, Memberships, Products & Vouchers

Video Course: Administrator Level 2: Lesson 6: Page Styling Misc (Miscellaneous) settings


Marketing Level 1 - Video Course


Video Course: Marketing Module Level 1 Lesson 1: Who?!

Video Course: Marketing Module Level 1 Lesson 2: Preparing your system data for accurate reporting in the Marketing Module

Video Course: Marketing Module Level 1 Lesson 3: common reports and queries, how to set up and use Patron Custom Attributes

Video Course: Marketing Module Level 1 Lesson 4: Manage consent for your organisation's patrons and stakeholders (New Zealand)

Video Course: Marketing Module Level 1 Lesson 5: Segment your audience and stakeholders

Video Course: Marketing Module Level 1 Lesson 6: Understanding report outputs and saving and downloading files from queries

Video Course: Marketing Module Level 1 Lesson 7: Using Marketing in WebHub

Video Course: Marketing Module Level 1 Lesson 8: How to send a marketing email to a segment of your database