Generated from Tern's reporting catalog. Edits made here are overwritten.
Find the dashboard or saved report that answers your question. New to reporting? Start with Reporting Overview and Key Reporting Terms.
Sales and commission
What are my bookings, sales and income so far this month and year?
Just me: Your KPIs
Entire agency (owners and admins): Agency KPIs
What are my monthly sales, by supplier and product type?
Just me: Your sales and expected commission
Entire agency (owners and admins): Agency sales and expected commission
Which commission is still waiting, and what's on my next payout?
Just me: Your commission tracker
Entire agency (owners and admins): Agency commission tracker
Which suppliers still owe me commission?
Entire agency (owners and admins): Agency commission still owed by supplier
Counts commission that's due and not yet received in full, including bookings marked Received that were paid less than expected and traveled bookings with no expected commission date.
How does expected commission compare with what I've received, by month?
Entire agency (owners and admins): Agency expected vs received commission by month
Covers booked bookings over the last 12 months, by the month commission was expected.
Which suppliers paid me commission, and when?
Just me: Your received commission
Entire agency (owners and admins): Agency received commission
Each payment counts on the date it was received, including bonuses, overrides and other adjustments that sales reports leave out.
What have I booked, by supplier, destination or advisor?
Just me: Your bookings this year
Entire agency (owners and admins): Agency bookings this year
What's booked for travel in the next 12 months?
Grouped by travel start date.
Which destinations do I sell most, by year?
Just me: Booked sales by destination and year
How much has each advisor sold?
Entire agency (owners and admins): Sales by advisor (the infamous pie chart)
What have we paid each advisor, by month?
Entire agency (owners and admins): Advisor payouts
How much does each advisor earn, and how much does the agency keep?
Entire agency (owners and admins): Payouts and agency income by advisor
Team and pipeline
How much of our sales do I book myself, and how much does the team?
Entire agency (owners and admins): Booked sales, my own vs the team, by year
How do sales on collaborator trips compare with solo trips?
Entire agency (owners and admins): Booked sales on collaborator trips vs solo, by year
Who's on our team, and in what role?
Entire agency (owners and admins): My Agents
How many leads does each advisor turn into bookings?
Entire agency (owners and admins): Leads and converted trips by advisor, last 12 months
Covers leads created in the last 12 months.
How many of my leads get a proposal, get booked or go stale?
Just me: Your trips
Entire agency (owners and admins): Agency trips
Which trip request forms turn into bookings?
Entire agency (owners and admins): Agency booked rate by trip request form, last 12 months
Covers the last 12 months. Forms with fewer than 5 leads, imported trips and trips created by hand are left out.
Which leads have gone stale?
Trips with no bookings and no updates in more than 14 days.
Which bookings still need to be marked Booked?
Just me: Your bookings not yet marked Booked
Entire agency (owners and admins): Agency bookings not yet marked Booked
Covers trips that start in the last 12 months or later. Lists only items you can mark Booked. Info blocks, ports, option blocks, flight legs and hotel check-outs aren't included.
Which suppliers and clients have the most bookings still in planning?
Entire agency (owners and admins): Agency planning bookings by supplier and client
Lists only items you can mark Booked. Info blocks, ports, option blocks, flight legs and hotel check-outs aren't included.
Which lead sources bring in the most income?
Just me: Lifetime income by client tag
Based on client tags. A client with several tags counts under each.
Clients
Which clients have booked with me more than once this year?
Just me: Your repeat clients this year
Entire agency (owners and admins): Agency repeat clients this year
Counts trips first booked this year. Canceled trips don't count.
Which clients have birthdays coming up, are VIPs or have gone quiet?
Just me: Your clients
Entire agency (owners and admins): Agency clients
Who are our top clients by lifetime income?
Entire agency (owners and admins): Clients by lifetime agency income and last booking advisor
Where are my clients right now, or next month?
Just me: Where are my clients?
Entire agency (owners and admins): Where are our clients?
What do my clients still owe?
Just me: Your client payments due
Entire agency (owners and admins): Agency client payments due
Which client payments are past due?
Just me: Client payments past due
Who opened or clicked my campaign emails?
Entire agency (owners and admins): Agency campaign opens and clicks, last 90 days
