Running marketing inquiries on firms
The first category of queries you can run in Marketing Inquiry are Firms based. This section explains all of the available queries to run in this category and why they’re beneficial to run.
Step-by-step instructions
On the left-hand side of the Marketing Inquiry screen, select Firms in the Category drop-down.
Depending on the Type selected, you will have different search criteria. After defining your search criteria, click
(Search) to see results on the right-hand side of the screen.
New – The first query you can run is for new firms entered in RB9. This query allows you to set an Entered From to Entered To date range search, which will produce a list of firms that were entered within that date range. This will allow you to keep up with your new clients, and review any important details about the firms.
This can also be beneficial as a form of quality control if you have the RB Connect plug-in and allow your resources to enter new firms during the Turn-in process. You’ll easily be able to recognize existing firm names and check to make sure they’re not a duplicate entry.
No Calendar – This query allows you to set a Scheduled Date From/To date range, and pull up any firms that did not schedule within that time period, but had scheduled jobs with you within the exact same time period last year. So you’re seeing who fell off the calendar compared to last year. Great information to know, and gives you a list of firms you can now market to, to see if there are any services you can provide for them.
Top N Calendar by Ordering – This query lets you search by Scheduled Date From/To to show you your top number (N) firms that ordered jobs from you. The results will be sorted by top ordering firm at the top and give you the total number of jobs scheduled within the date range searched. (N) is a number you define. The number you input represents the number of top clients that will be listed. So, if you’re looking for your Top 10, simply input 10 in the Top N field.
No Revenue – Search by Invoice Post Date From/To to see which clients generated no revenue with you within the date range searched. The results are based on a comparison from the exact same time period last year. So if a firm appears in the results, it means they had at least one invoice posted between the dates searched for the previous year.
Top N Revenue – This will show you your top revenue-generating firms for the Invoice Post Date From/To date range that you search. Top N represents the top number of clients, so if you’re looking for the Top 10, input 10 in that field. The top revenue-generating firm will be listed at the top, and the far-right column will display the amount of revenue posted in the date range searched.
By default, this query includes copy sales invoices from the top revenue firms. This is great to give you an overall view of the real top revenue-generating firms with you because it’s not only including their invoices, but any other invoices posted for the jobs they schedule with you.
If you only want it based on their invoices, set Exclude Copies to Yes.