Tours
Total Scheduled Tours
Definition
Total Scheduled Tours refers to the total number of new tours booked during the selected time period. This includes all tour scheduling events completed by prospects or captured through API integrations. Reschedules are excluded—only the original booking counts. Two additional breakdowns are included:
• Total Prospect Scheduled Tours: Tours scheduled directly by the prospect, including those coming through API sources (ILS, partner integrations).
• Total Hyly Schedules: Tours scheduled through Hyly-powered interfaces—Hayley Mail Bot, Hayley Chat Bot, and Hyly Scheduler—identified using h_stream = hyly.
• Total Prospect Scheduled Tours: Tours scheduled directly by the prospect, including those coming through API sources (ILS, partner integrations).
• Total Hyly Schedules: Tours scheduled through Hyly-powered interfaces—Hayley Mail Bot, Hayley Chat Bot, and Hyly Scheduler—identified using h_stream = hyly.
Calculation
1. Total Scheduled Tours Total Scheduled Tours = SUM(Schedules) (Counts all first-time schedules; excludes all reschedules.) 2. Total Prospect Scheduled Tours Total Prospect Scheduled Tours = SUM(Schedules where channel = Prospect OR channel = API) 3. Total Hyly Schedules (one line) Total Hyly Schedules = SUM(Schedules where channel = Prospect AND h_stream = hyly) (Includes schedules completed via Hayley Mail Bot, Hayley Chat Bot, and Hyly Scheduler.)
Example
Let’s say in a given month:
• Prospect-submitted schedules → 50
• API-submitted schedules (ILS) → 20
• Hyly Chat Bot schedules → 18
• Hayley Mail Bot schedules → 12
• Reschedules → 15 (excluded) Total Scheduled Tours = 50 + 20 + 18 + 12 = 100 Total Prospect Scheduled Tours = 50 + 20 = 70 Total Hyly Schedules = 18 + 12 = 30
• Prospect-submitted schedules → 50
• API-submitted schedules (ILS) → 20
• Hyly Chat Bot schedules → 18
• Hayley Mail Bot schedules → 12
• Reschedules → 15 (excluded) Total Scheduled Tours = 50 + 20 + 18 + 12 = 100 Total Prospect Scheduled Tours = 50 + 20 = 70 Total Hyly Schedules = 18 + 12 = 30
