Find Winning Affiliate Campaigns - Advanced Queries

Strategy in a Nutshell

This is not a new strategy per se. We will try to utilize the strategies used in the first 3 articles of this series and combine each strategy into a single query. By doing this, you are:

  • Not required to change the dropdown filter multiple times to get the results
  • Aggregating the results into a single view
  • Becoming more productive by saving the query for future use using our advanced search features

Procedure

As explained in our introduction to advanced search, you will need to open the advanced search dialog box by clicking Adv. Search button and selecting the Text Search from the dropdown. Instead of describing the procedure, we are going to post a series of screenshots along with query algorithms from each of the previous 3 articles as shown below.


Advanced Search Query From Article I

Here we are going to use boolean OR operator to get results from all the ad-networks of interest as described in Article I. In addition a sorting order is specified. After executing the query below, all you need to do is apply Days Running Slider to identify the desired results as described in Article I


Advanced Search Query From Article I
    Ad_Network IS 'Revcontent'
OR  Ad_Network IS 'Contentad'
OR  Ad_Network IS 'Mgid'
OR  Ad_Network IS 'Spoutable'
OR  Ad_Network IS 'Earnify'
SORT BY Date_Last_Seen DESC
Important Tip: Don't forget to save your advanced search so that you don't have to generate the query again, when you want to use it next time.

Advanced Search Query From Article II:

Here we are going to use boolean OR operator to get results from all the ad-networks of interest as described in Article II. In addition, a sorting order of Duration (Desc) is specified. We are also adding a title keyword search option as shown below to narrow down the search results to desired niche.


Advanced Search Query From Article II
    Ad_Network IS 'Revcontent'
OR  Ad_Network IS 'Contentad'
OR  Ad_Network IS 'Mgid'
OR  Ad_Network IS 'Spoutable'
OR  Ad_Network IS 'Earnify'
AND Title CONTAINS 'diet'
SORT BY Duration DESC

Advanced Search Query From Article III:

As described in the Part III of Advanced Strategies Article Series, we can use the advanced query builder to our advantage by combining several search terms in a single query using boolean OR operator as shown below. In addition, we are applying Ad-strength (Desc) sort order.


Advanced Search Query From Article II
    Title CONTAINS 'diet'
OR  Title CONTAINS 'weight loss'
OR  Title CONTAINS 'fat'
OR  Title CONTAINS 'lose pounds'
OR  Title CONTAINS 'lose kg'
SORT BY Duration Ad-Strength DESC