Total Annual Visitors

Anna Blanton

I'm needing to get an estimation for total annual visitors in a fiscal year. It's a bit complicated. If anyone has a query they currently use or have advice I'd appreciate it. Here are ways we track visitors:

• Vehicle entry donations
• School groups
• Ticketed events

Tamara Christensen

@Anna Blanton Hi Anna - I use a combination of a query and the sales comparison report (for group sales). We used to be able to get most of the information from the sales comparison report, but when we started selling tickets online - they show up on the report as the day they were purchased, not the day they were used plus not everyone shows up who has tickets so the query is for tickets scanned during the particular time period. I calculate attendance every month for our dashboard and then we keep track of cumulative attendance so we know our counts for each month, ytd, each year, and cumulative since we have been open.

Each month, I run the query, and the sales comparison report, and then I check for any events that occurred that will also have to be added. This is the query that I use - I download to a spreadsheet and then pivot table and filter for what I need.

Tamara

Breanne Leach

@Anna Blanton I'm not sure how far in advance you sell online or what your vehicle entry donations are (and how they're built in Altru), but I would use Sales by price type for this. As you're just looking for an estimate, this should give you a count that is close to attendance for your programs (including group sales) even though it's a sales report.