Use this link to share with your colleagues:
All About Reporting: https://help.pm.leapevent.tech/a/1150370
PatronManager comes with robust reporting capabilities; with reports, you and your colleagues can distill important data about the many ways your patrons interact with your organization. In this article, we'll introduce you to reporting and provide resources to help you become more familiar with all reporting has to offer.
Specifically, we'll cover:
- Why report on the data in your PatronManager account?
- What reports come with PatronManager?
- Can I customize reports?
- What controls the data I see in my report?
- Where can I go to find more reporting resources?
Why use reports?
Track trends
Easily track your progress on ticket sales goals, donation trends, and more with easy to read dashboards (which are just reports in picture form!).
Create mailing lists
Reports allow for targeted (read: much more effective) marketing, whether you’re emailing potential subscribers or sending a donation ask by snail mail.
Stay informed about up-to-date weekly numbers
If you (or your supervisor) always want to know “What were our ticket sales last week?”, take all the manual labor out of the equation with scheduled reports.
Reconcile your finances
If your financial department needs to see ticketing or donation revenue or you need to reconcile your payouts PatronManager's financial reports will help you achieve this.
What reports come with PatronManager?
Your PatronManager account comes with a number of reports set up and ready for you to use:
CRM Snapshots
The CRM Snapshots tab lets you easily pull complex ticketing, donation, membership, and combination reports with a guided process to help you narrow your results.
Need to report on patrons who donated last year but not this (LYBUNT/SYBUNT)? Want to know who of your patrons have purchased tickets to a show and donated to your organization within a certain time frame? Want to know which patrons came to an event so that you can let them know about a similar one?
There's a CRM snapshot for each of these scenarios and more.
Financial Reports tab
The Financial Reports tab is your go-to for running financial reports. Report on transactions within a time frame, revenue for the run of a show or a specific performance, or reconcile your payouts.
Packaged report templates in the Reports tab
Your Reports tab comes with a plethora of stock reports for Contacts, Accounts, Email List, Donations, Tickets, and more.
To find out more about available report templates in the Reports tab, check out our Library of Useful Pre-Loaded Reports article.
Can I customize reports?
Absolutely! You can add, remove and reorder columns in reports:
- Move Columns: Click and drag columns in the main report editor to reorder them
- Add Columns: Use the search bar to find fields you want to see in the report
- Remove Columns: Click the "x" next to fields you don't want to see in the report
Add filters to narrow down your report criteria:
Group your report however you like:
Check out this Help tab article to learn more about customizing your reports.
You can also add Cross filters!
Cross filters can do things like filter a Contact report to only show Contacts who have donated $10 or more - perfect for soliciting more donations. We love ‘em, and so will you!
Learn more about cross filters here.
What controls the data I see in my report?
Every report is based on a Report Type. The Report Type controls the data you see on each row of the report, as well as what fields are available to show data and filter the report.
The available fields in the report will depend on the report type you choose - for instance, a Contacts & Accounts report contains fields from the Account object and the Contact object.
Report Type | Each row is a... | The report contains fields and filters from the... |
---|---|---|
Contacts & Accounts | Contact | Contact record and the Account record |
Donations | Donation | Donation record |
Contacts with Benefits |
Contact that has an associated Benefit |
Contact record and the Benefit record |
Ticket Orders with Ticket Order Items | Ticket Order Item |
Ticket Order Item record and the Ticket Order record |
Donations and Ticket Order | Donation that has an associated Ticket Order | Ticket Order record and the Donation record |
Ticket Orders with Ticket Order Items and Discount Code |
Ticket Order Item that has an associated Discount Code | Ticket Order Item record and the Discount Code record |
Want to learn more about report types? Check out Salesforce's ultimate guide to report types and our Help article about modifying existing report types.
Where can I go to find more reporting resources?
To get started on your reporting journey, here are additional resources from both the PatronManager Help tab and Salesforce.
PatronManager Help Tab
- Anatomy of a Report
- All About Direct Mailing, Email, and Phone Lists
- On-Demand Reports and Dashboards
- Basic Reporting Customizations
- How to Add the CRM Snapshots Tab to the Reporting App
Trailhead
Salesforce Help