Setting up properly constructed search queries is an essential part of capturing relevant metrics for an Advertiser. Attribute provides a flexible model that allows you to build custom queries to meet the unique needs of a variety of use cases. You can create layered keyword sets using different Criteria options and AND/OR combinations to hone in on specific information and return accurate results. 

To help you create powerful, effective queries, we’ve put together a few best practice guidelines that you can follow. In addition, Attribute provides a preview of results on demand as you create your query, so it’s easy to play around with different configurations and find the formula that returns the results you’re looking for.

Search Criteria

When building a query for tracking Pre-Recorded Spots, you can choose a Criteria that provides specific instructions on how to search for the term you enter. There are four Criteria options to select from, which are covered in more detail below: Contains (default), Does Not Contain, Is, and Is Not

Contains

Searches for exact matches of the entered term as well as for words that contain the term. Contains is the most flexible and commonly used search criteria option. It returns a broader result set and it allows you to refine search instructions by using AND/OR or by adding a second criteria such as Does Not Contain or Is Not to eliminate specific terms. 

Example: A Contains search for the word market returns results for market, markets, and marketing.

 

Does Not Contain

Returns all items that do not contain a full or partial match of the word or phrase that was entered. Does Not Contain must be used in conjunction with the Contains or Is criteria options, which define base search keyword(s) or phrase(s) to find. 

Example: A query with Contains: market and Does Not Contain: farm returns results such as market, marketing report, and local market. Results that have the root word farm (such as farmer, farms, farmer’s market, or farming) will be excluded. 

 

Is

Finds precise matches to the word or phrase you enter. When using this option, you’ll select from a list of suggested results to add words or phrases to your query. Simply begin entering a word and a list of matching terms auto-populates as you type.  

 

Is Not

Finds matches to your query elements that do not contain the word you entered. Is Not must be used in conjunction with the Contains or Is criteria, which define base keyword(s) or phrase(s) to find. When using this option, you’ll select from a list of suggested results to add words or phrases to your query. Simply begin entering a word and a list of matching terms auto-populates as you type. 

 

AND/OR Operators

Attribute uses AND and OR operators to combine multiple search terms in a single query. These allow you to specify whether you want to get results that include all of the keywords (using AND), or results where one or both of the keywords is found (using OR). 

  • A space between keywords/phrases represents AND
  • A comma used between words/phrases represents OR.
  • AND: The AND operator narrows searches and finds records that contain both terms. This is helpful when you want to find a smaller part of a broad topic. For example, searching for dogs AND Poodles will return results where both words are found in a the same record. 
  • OR: Using OR broadens searches and finds records that use either term. The OR operator is typically used when searching for a topic that has multiple names or words associated with it. For example, a search for founder OR owner will return records that contain either or both of the words. 
  • In multiple-term searches, the AND operator is automatically placed between each word or phrase in the query. For example, a search for the words NBA player will return results containing NBA player as well as records where the individual terms NBA and player were both found but not together.
  • The AND and OR operators can be changed from directly within the search box. Simply click on the operator and select a different option.
  • Searches that contain both AND and OR operators are performed in order from left to right.

Keyword Search Tips

  • Phrases are searched exactly as they are entered. Results include records where the words display right next to one other as well as those where one or more of the words in the phrase were found individually. For example, entering the words rock climbing will return results that contain rock climbing as a phrase as well as the individual words rock and climbing. To search for a phrase exactly as it appears, enclose it in quotes. For example, enter “rock climbing” to only get matches of the exact phrase rock climbing.
  • Keyword search is case insensitive, so whether you search with capital or lowercase letters, your results will be the same. For example, a keyword search for Industries and industries returns the same results.
  • Enclose terms in quotes to search for exact phrases.
Did this answer your question?