What is a Query Builder?
Query Builder is a tool for creating queries to retrieve lists of meetings and organizations from the database for prospecting purposes. Each query category contains fields to enter specific qualifications the results must meet.
Using Query Builder
The Query Builder offers three search categories: Organization, Meeting Location Information and Meeting Preferences. Each category and its available filters are accessible by clicking the expand/collapse icon.
Organization
The Organization category allows searches based on an organization's location, market segment classifications and keywords.
Organization Location: This filters and retrieves information based on the host organization's location. The organization's location may include the city, state, country, zip code, or other location information associated with its address. States and provinces must be entered by their two-letter abbreviation. You can search for a specific city in a particular state by using the following style: “city:ST”
Organization Keyword: The option is helpful for retrieving meetings by a common name associated with the organization, such as 'Medical' or ‘Technology’.
Classifications: Narrow your search based on the organization's Key Classification, NTEE code, or NAICS code. The MINT+ team assigned these codes using various automated API lookup processes and manual review.
Key Classifications: The MINT+ team has categorized specific market segments into broad categories based on common industry segmentation to enable easy searching. Each Key Classification comprises related codes from both the NAICS and NTEE code lists. For example, when you select "Environmental" on the key classifications tab, your results will include companies related to NTEE or NAICS environmental codes.
Nonprofit (or NTEE): National Taxonomy of Exempt Entities. This is the standard classification system used for non-profit organizations to classify themselves for US government purposes.
Profit (or NAICS): North American Industry Classification System. This is the standard classification system used by for-profit businesses and organizations to classify themselves for US government purposes.
Advanced: Use this if you want to query using specific NAICS or NTEE codes. You can enter full or partial codes based on the level of detail you need for your search (Ex: B01, C, 524113, or 611). The reference buttons to the right of the fields provide a list of codes.
Legacy MINT+ Market Segments: Before implementing the NTEE and NAICS systems, MINT+ used this classification method for organizations. It was based on the Market Segment structure recommended by Destinations International for DMOs. This system relied on DMOs' self-labeling, making the assigning process more subjective and less complete than in the newer systems.
For more information on NTEE and NAICS codes and why MINT+ chose them to classify our system, click here to watch our webinar.
Updated Since: This field narrows your search by the date the Organization record was last updated. For example, if you set the date to March 1, 2023, the Query will return MINT+ Organizations that have been updated on or after that date.
Added Since: This field narrows your search by the date the Organization record was added to MINT+. For example, if you set the date to March 1, 2023, the Query will return MINT+ Organizations that have been added on or after that date.
CRM Original Market Segment: Use this option to filter based on original Market Segment labels reported by DMO CRMs when their bookings are reported.
Meeting Location Information
The Meeting Location Information enables users to search for results based on a meeting’s location and venue.
City, State, Country: This field searches for meetings based on the meeting location. The meeting’s location may include the city, state, country, zip code, or other location information associated with its address. States and provinces must be entered by their two-letter abbreviation. You can search for a specific city in a particular state by using the following style: “city:ST”
Venue Name: This selection searches for occurrences specifically in the ‘Venue / HQ Hotel’ field.
Omit Meetings: By default, this filter shows all meetings, regardless of whether they have met in your destination in the past. You can change this filter to increase or decrease the time used to filter out your destination’s booked meetings.
Meeting Preferences
Use the Meeting Preferences criteria to narrow your search based on a meeting's additional details. This section is helpful when trying to fill a need period.
Months: This field filters based on the months that a meeting has historically taken place. Select the months of the year you are trying to target for business; you can select multiple months.
Regions: Filter results based on regions where meetings have occurred. By selecting this field, you can narrow results based on the location of a past meeting. Click on the “Regions List” Link to see a breakdown of each region.
Custom Regions: If your DMO admin has set up any custom regions, you can select them here. Custom Regions can include any state or province in the US or Canada.
Note: Admins can add and edit their regions by going to the profile icon in the top right, clicking on 'My DMO Profile', and then editing to see a list of their custom regions or to add more.
Dates: Use this date range filter to limit your results based on an event's date of occurrence. By default, the query will only show you meetings with a start date in the last five years or the future.
Unreported Years: Check the box and select a range to include meetings that have yet to report upcoming meetings for specific years. If you are getting too many results, consider searching for one year instead of a range of years at a time.
Day of Week - Start Day: This multi-select field allows you to filter results based on the day an event started, as reported by the DMO that provided the data.
Day of Week - Main Arrival: This multi-select field allows you to filter results based on the meeting's Main Arrival day. The Main Arrival day is set as the first day of the room block with greater than 80% peak. Occurrences without room flow will not have a Main Arrival day.
Length of Stay: Enter a range to indicate the length of stay you want to look for. Length of stay is the number of days between the calculated Main Arrival (first day with +80% of peak) and Main Departure (first day after the last day with +80% of peak) date for an occurrence. This field is only calculated for occurrences with room flows.
Attendance: Enter a range to indicate the attendance size you want to look for in your query.
Peak Rooms (Contracted): Enter a range to search for the Peak Rooms based on an event’s contracted Room Block peak.
Peak Rooms (Pickup): Enter a range to search for Peak Rooms based on an event’s Pickup Room Block peak.
Convention Center: Use the dropdown to limit the results to meetings held in convention centers (Yes), exclude convention center meetings (No), or the default, which includes all results regardless of whether they used a convention center (Any).
Current Top 250 Events: Check this box to search MINT+'s current top 250 events in MINT+. The Top 250 lists the largest meetings in MINT+ based on Peak room size and is updated once a year. This list excludes sports events.
Exhibits GSF (Requested or Reserved): Enter a range to indicate the gross square feet a meeting has requested or reserved.
Updated Since: This field narrows your search by the date a Meeting record was updated. For example, if the user sets the date to March 1, 2023, the Query will return MINT+ Meetings that were updated on or after the selected date.
Added Since: By choosing a date in this field, your search will include Meetings entered into the system on or after the selected date.
Query Building
Only one criterion is necessary when building a query, as options within fields have an implied “or” statement. For example, in the Day of the Week section, by checking the box for Monday and Tuesday, you indicate you want to find meetings that start Monday OR Tuesday.
However, if your query shows too many meetings, it can be a good practice to include at least two criteria to narrow the results, as the meetings listed must match each filter. Each new filter operates as an AND condition with any other filters utilized. For example, you may want a meeting that starts on a Monday or a Tuesday, AND it must have a length of stay over three days.
Once you have specified your Query parameters, click 'Search.'
The next page displays a list of events that fit your criteria. Save and Export options are available from this page.
Results
Once you've chosen the parameters for your query and clicked "Search," the results page will show information that matches your criteria. If you need to change your query, it's best to use the "Back to Query" button instead of the browser's "Back" button. Using the "Back to Query" button will prevent your query from being reset and will take you back to the Query Builder page, where you can add or edit parameters as needed.
Saving Queries
After running the query and reviewing the results, click on the 'Save' tab to easily access this results list in the future or to check for new results. On the next screen, you will be prompted to provide a title to identify the query. It is recommended to use an intuitive title to easily remember your query parameters in the future.
These are the steps in saving a query:
- Create the parameters of your query using the filter options outlined above
- Run the query
- Review results
- Click the 'Save' Tab
- Write a title for the query
- Click 'Save'
- If desired, use the "Notify of new Matches" dropdown to receive email notifications when new results are added to this query
For more information about saved queries, read 'My Saved Queries'.
Exporting Queries
To export the Query, click the 'Export' tab, select the 'All' checkbox, or choose specific MINT+ records for export. Depending on the file type you need, click either "Export to Excel" or "Export to HTML." Please note that the exported file will display additional data columns on the results screen, which provide more insight than can be displayed on the website, like primary contact information.