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
ACCOUNT
CAMPAIGN
ADSET
AD
SEGMENT
Google Ad Words
ACCOUNT
CAMPAIGN
AD_GROUP
AD
KEYWORD
DYNAMIC_AD_TARGET
SEGMENT
Liftoff
ACCOUNT
CAMPAIGN
AD_GROUP
AD
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