Extractors are a way to help you automatically extract values from dimension with the help of functions on Clarisights. These functions will run across the set of dimensions mentioned in the extractor expression. You can additionally customise the extractor to run on certain values by adding a rule-filter. 

Let’s consider an example where campaigns are named as  sem_india_M_25  or sem_australia_F_26  and you want to fetch name of the country from these campaigns, you can use the #SPLIT  extractor command to get the name of the country. #SPLIT ( #CAMPAIGN, '_', 1)   would result in india  and australia respectively.

Functions

There are four functions supported on the platform currently. 

  • #EXTRACT : Returns a segment between the first prefix and suffix #EXTRACT (string, prefix_string, suffix_string)

Example: For Campaign, dis_reach_web_[FI_ALL_XX_[RR]_[ST]_GELA_NFA_LPA  , the extractor expression,  #EXTRACT(#CAMPAIGN, “[”, “]”)   will result to FI_ALL_XX_[RR

  • #SPLIT : Returns the nth occurrence of a segment of a string divided around a specified character/string. n starts from 0. #SPLIT (string, delimiter, occurrence_number)

Example: For Account, 10_network_ios , the extractor expression,  #SPLIT(#ACCOUNT, “_”, 2)  will result to ios

  • #SUB : Returns a segment of a string between specified index. Index starts from 0, and both starting index and ending index are included in the extracted segment. #SUB (string, starting_index, ending_index) 

Example: For Campaign, Promo_Instagram_Engagement , the extractor expression, #SUB(#CAMPAIGN, 0, 4)  will result to Promo

  • #CONCAT : Returns the concatenation of strings. #CONCAT (string 1, string 2, string 3, ..., string n) 

Example: For Campaign and Account, namely - ios_br  and Europe  #CONCAT(#CAMPAIGN, #ACCOUNT)  will result to ios_brEurope


Advanced use cases

You could use a combination of extractor functions. For example:
#SPLIT(#EXTRACT(#CAMPAIGN, “web_”, “_GELA”), “[“, 0) . Campaign, dis_reach_web_[FI_ALL_XX_[RR]_[ST]_GELA_NFA_LPA will result to  FI_ALL_XX_ .

Steps for setting up Extractor Expressions

Click on the Edit button to get inside the modal window to view or add or update rules and values.

Click on + New Value followed by clicking on Extract Values to start defining the functions and dimensions on which these functions would run.

Start by typing out # to get the list of extractor functions. This list of dimensions shown here are the only ones on which extractors will run on.

Enter the Extractor Expression

Select Channels to proceed

Please note that the list of channels displayed in have been filtered for those that have the specified dimension. 

Click on Extract Sample Values to view resulting values from a sample size selected

Save the changes by clicking on Save Extractor

Limitations

These functions work only on certain dimensions, covering all the commonly used dimensions across standard advertising channels

Custom Advertising

  • ACCOUNT

  • CAMPAIGN

  • ADGROUP

  • AD

POD

  • ACCOUNT

Facebook

  • ACCOUNT

  • CAMPAIGN

  • ADSET

  • AD

  • SEGMENT

Google Ad Words

  • ACCOUNT

  • CAMPAIGN

  • AD_GROUP

  • AD

  • KEYWORD

  • DYNAMIC_AD_TARGET

  • SEGMENT

Liftoff

  • ACCOUNT

  • CAMPAIGN

  • AD_GROUP

  • AD

Twitter

  • ACCOUNT

  • CAMPAIGN

  • LINE_ITEM

  • PROMOTED_TWEET

  • MEDIA_CREATIVE

Bing

  • ACCOUNT

  • CAMPAIGN

  • AD_GROUP

  • AD

  • KEYWORD

Criteo

  • ACCOUNT

  • CAMPAIGN

  • CATEGORY

Snapchat

  • ACCOUNT

  • CAMPAIGN

  • ADSQUAD

  • AD

Yahoo

  • ACCOUNT

  • CAMPAIGN

  • AD_GROUP

  • AD

  • KEYWORD

Apple Search Ads

  • ACCOUNT

  • CAMPAIGN

  • ADGROUP

  • KEYWORD

Seznam

  • ACCOUNT

  • CAMPAIGN

  • GROUP

  • AD

  • KEYWORD

TV Squared

  • ACCOUNT

  • CAMPAIGN

  • SPOT

  • SEGMENT

Google Search Console

  • ACCOUNT

  • OBJECT

Naver

  • ACCOUNT

  • CAMPAIGN

  • ADGROUP

  • AD

  • KEYWORD

Neo Reach

  • ACCOUNT

  • CAMPAIGN

  • POST

Remerge

  • ACCOUNT

  • CAMPAIGN

  • AD

Awin

  • ACCOUNT

  • PUBLISHER

  • OBJECT

Did this answer your question?