Back
4 mins read

Try out regular expressions, this time in reverse

0 1*8x0xzilj3tuinkhefyz nw0 1*8x0xzilj3tuinkhefyz nw
Sometimes, thinking up keywords can be a pretty tough nut to crack, all the more if your data feed isn’t exactly tidy; for example, if the source’s product_name contains a lot of details which won’t be used in keywords because they are either too general, or too specific.
This can be resolved by modifying the variable, i.e. by creating a couple of your own, new variables and using regular expressions to remove groups of words or characters from them, until only the required word is left.

But maybe you have thought at one point or another that it would be nice if this lengthy process could be simplified. What if you could just extract a group of words from the text instead of removing it? Simply put, make the functionality be completely opposite to the traditional regular expression? And if you haven’t wondered that, then you no longer need to because we’ve created a new function for you which works precisely this way — Extract regex!

We’ll show you how it works in practice, using three different examples — electronics, fashion, and anything that falls outside these two categories.

In case of electronics, _brand_ + _model_number_ is a good keyword. Let’s say that Lenovo Legion Y520–15IKB, black, is our initial text, meaning that we want to post an ad for Lenovo Y520–15IKB. Using our own variable, we formulate a regular expression “A mix of letters and digits (in most cases): \b((?=[A-Za-z-\/]{0,19}\d)[A-Za-z0–9\/-]{4,20})\band choose the Extract regex function.

In case of clothes and shoes, it definitely pays off to have more variations. So, our initial text goes like Vans UltraRange 3D — Black/Asphalt 47, and we’d like to create these four variations:

1.)
name of the shoe, no color or size

2.)
name of the shoe + color

3.)
name of the shoe + size

4.)
name of the shoe + size + color

The number 1.) option can be created the same way you’re already used to — with a template of regular expressions, by removing color and quality. This gives you Vans UltraRange 3D.

In case of option number 2.), you have to create your own text variable for colors to go along with the shoe’s name. From the Find Regular Expressionfunction, select “Colors in English:\b(black|white|grey|gray|red|green|blue|silver|gold|brown|yellow|orange|pink|purple)\b. You end up with Vans UltraRange 3D Black.

Option number 3.) can be created in the same way — With the Extract Regexfunction: \b(35|36|37|38|39|40|41|42|43|44|45|46|47|48|L|XXS|XS|S|XL|M|XXL|XXXL)\b. We arrive at Vans UltraRange 3D 47.

The last option, number 4.), is created by simply adding your own text variable _color_ + _size_ to the shoe’s name. The final keyword is Vans UltraRange 3D 47 Black.

Let’s demonstrate the last example with a building set. The initial text goes LEGO Batman Movie 70905 Batmobil. You’d like to post an ad for it, using the keyword _brand_ + _set_number_, in this case LEGO 70905. Such a keyword can be extracted with your own text variable. Use the Extract Regexfunction to extract all — \d+ figures.

All you need to do after that is contact us at support@pppcbee.com and show off how much time this new function saved you! If anything at all is unclear to you, don’t hesitate to contact us.

Related articles

Read more

Meet PPC Bee Dashboard

All important information in a single place. A dashboard is a feature that tells you whether an issue occurred, or if everything is all right, giving you comprehensive knowledge of what’s going on within the app. And, what’s more, it’s the place in the app where you are redirected right after signing in, so you don’t miss anything important ever again.

By Michaela ZákopčaníkováDec 11, 2019 | 6 mins read

Read more

PPC Bee Partner Talks with Heureka.cz

Last week, we and our clients held the very first meeting from a planned series of events—PPC Bee Partner Talks. The pros running Heureka.cz were invited to the first Partner Talk which offered an interesting program spanning an entire afternoon.

By Adam VašendaOct 18, 2019 | 4 mins read

Read more

FAQs – November Edition

How do you remove or delete ad groups? And what happens when multiple CPC rules apply to a single product?

By Michaela ZákopčaníkováNov 15, 2019 | 2 mins read