A data source that is correctly and clearly structured is vital if your PPC Bee experience is to go without a hitch. Nonetheless, you may find yourself saddled with a source that contains a random jumble of information and data instead of a tidy list of products – the individual parameters contain more information than they should, etc. Just to give you an idea – you have a _product_name_ variable which features not only the product name, but also the name of the manufacturer. But you don’t actually want the name of the manufacturer to be present in the product name, so how do you extract what you need from the variable? Create your own variable!
In the data source menu, click the Variables section, and you’ll see a list of all variables contained in the source. The variables you’re going to create will later be displayed here as well. So, let’s get down to business and click the Create text variable button.
The custom variable consists of a name and an input text.
Give your variable such a name that lets you know what value it communicates.
In the Input text box, you’ll find variables that can be simply dragged into different fields. Only those variables which are turned on (be they original, or those created by you) are displayed here; the ones that are turned off aren’t shown.
EXAMPLE: Let’s create our own “name without brand” variable. As the input text, use the _product_name_ variable which contains the product’s name and brand.
Use the find and replace function to remove the brand. You can enter variables as well as your own text.
Firstly, type in the _brand_ variable and replace it with a blank space – this will remove the brand (1.). Let’s say that you don’t like the word “Barbie” in the product name; replace “Barbie” with “Doll” (2.). On the right, you can see a preview of the input and output text which makes it easy for you to check if the changes were made correctly (3.).
Another way to adjust your own variables is to use regular expressions.
By creating regular expressions, you can automatically remove or extract particular groups of words, characters… We’ve already added the ones which are most frequently used – click regular expression examples and a window pops up where you can choose the expression you’re going to be using.
Click + and the expression will be copied into the find regex box. When using regular expressions, don’t forget to switch the replace text option to replace regex or extract regex.
The extract regex function is a relatively new feature in the application. If it’s not entirely clear to you how it works, you can learn more about it here. Our blog will tell you how to create basic regular expressions.