Making Multiple Selections Using the Control Button in Data Workbench

If you are working in an Adobe Workbench dashboard there will probably come a time when you have to select a large amount of data at once. Let’s take, for example, the scenario where you create a table that is pulling Entry Pages with Sessions as the Metric.

Making Multiple Selections Using the Control Button

For large websites, it’s safe to say your list of Entry Pages will be very long. If you need to select all the Entry Pages in order for the table to be highlighted, I would suggest the following:

  • Expand the table as far as you can vertically on the screen reaching it as far to the top and as far to the bottom as possible.
  • Press the Control Button and then with the Control button held down, select as many Entry Pages as you can, starting at the top of the table and going down.
  • Make sure the table stays highlighted and then scroll down until you see the next set of Entry Pages that are not selected.
  • Repeat step 2…Press the Control Button and then with the Control button held down, select as many Entry Pages as you can, starting at the top of the list of unselected Entry Pages and going down.
  • Keep performing this method until you have selected all the Entry Pages AND the table is still highlighted.

This is the only way I’m aware of to select multiple selections within a table while keeping the table highlighted.

Posted in Data Workbench | Tagged , | Leave a comment

Masking Data Using a Search in Data Workbench

You can mask data using either of the following search options:

Right-click an element or the label of the desired dimension, click Mask, and then in the Search box type the phrase for which you want to search.

masking data using a search in adobe data workbench

Right-click an element or the label of the desired dimension, click Mask > Display search bar, and then in the search box that displays in the dimension label cell, type the phrase for which you want to search.

masking data using a search in adobe analytics data workbench

As you type a search phrase, Adobe Data Workbench updates the dimension to reflect matches.

To further constrain the masking during a search, you can use any of the following methods:

  • You can type “re:” in the search box or bar to have the search phrase interpreted as a regular expression. You can use any of the syntax associated with regular expressions in your search phrase. For more information about regular expressions, see the “Regular Expression” appendix in tthe Dataset Configuration Guide.
  • You can type the $ symbol as the first character in your search string to find phrases that begin with the string you entered, or as the last character to find phrases that end with the string you entered.
  • You can type a space as the first character in your search string to find any words within a phrase that begin with the string you entered, or as the last character to find any words within a phrase that end with the string you entered.

Following are examples of different ways to mask a table using the string “on” in a search:

  • Typing “on” displays every phrase that contains the string “on” anywhere in the phrase: “online banking,” “contact buyers,” “bullion coins,” “bank online,” “gold options,” and “silver bullion.”
  • Typing “$on” displays every phrase that begins with the string “on”: “online banking” and “on-line payment.”
  • Typing “on$” displays every phrase that ends with the string “on”: “silver bullion” and “gold option.”
  • Typing “ on” displays every phrase that contains a word that begins with the string “on”: “online banking” and “bank online.”
  • Typing “on ” displays every phrase that contains a word that ends with the string “on”: “bullion coins” and “silver bullion.”
  • Using “ on ” displays every phrase that contains the string “on” as a word: “on line banking” and “bank on line.”

 

 

 

 

Posted in Data Workbench | Tagged , | Leave a comment

Pulling Search Phrases from the Adobe Insights Small Elements Category

The Search Phrase dimension is denormalized, so it is possible to pull specific phrases out of the Search Phrase dimension that may not otherwise appear because the traffic is smaller in comparison with other phrases. However, it is not possible to randomly browse the phrases with low traffic.

The Search Phrase dimension includes the top couple of thousand search phrases (depending on your configuration), the rest typically are shunted to the Small Elements other category. To pull them out refer to the following method:

  1. Right click on Search Phrase, select Mask > ‘At Least One’ > Extended > Session
  2. Right click on Search Phrase, select Mask, Type your ‘[The Search Phrase]’ into the text box

If your search phrases have a specific term in common, a good way to use this functionality is to setup a workspace with Entry Page, Search Engine, Search Term, and Search Phrase tables. Set Search Phrase to sort using Dynamic Selection by metric Sessions, then pick Search Terms you are interested in and capture the various phrase permutations pulled from the Small Elements bucket.

Posted in Data Workbench | Tagged , | Leave a comment