Back
8 mins read

Working with Variables

For good product advertising, the key is to create ads that are the most tailored for each product. And so we are extracting the so-called variables from your feed and playing with them: supplementing, cutting shorter, sometimes adding a regular expression. Variables are one of the charms that make the resulting campaigns more powerful and working with PPC Bee more efficient. Variables in PPC Bee are of two types: text and numeric.
By
Michaela Zákopčaníková
| Mar 28, 2017
Text Variables

are product information downloaded from a data feed. They are specific to each product and updated daily in PPC Bee. Product names in the feed are not always in a form which can be used in an ad or keyword. Therefore, in PPC Bee there are “custom text variables” which you can define yourself and build just like playing with Lego.

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaTBDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--de680bad3bfe08ddb98507848194b4ef8f6faff6/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/0-0*SFD0j9hLeGo5ykCg.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaTBDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--de680bad3bfe08ddb98507848194b4ef8f6faff6/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/0-0*SFD0j9hLeGo5ykCg.png


An example of one of the predefined variables from the data feed

What functions does PPC Bee offer to modify the feed and what can be defined by your own variable?

You can remove:
  • Accents
  • Duplicate words in the name
  • Punctuation
  • Stop-words (conjunctions, prepositions, etc.)

Another option is cutting down
  • The number of words [recommend 3–5 words. Specific product names tend to be longer, but no more than five words (only rarely).];
The number of characters (we recommend a maximum of 35–40 characters.)

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaTRDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--0aa5d4e9e2ae00e945c841d0469b90c8379c5e7b/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/1-0*Ls3xkEIzU9hvvA2T.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaTRDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--0aa5d4e9e2ae00e945c841d0469b90c8379c5e7b/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/1-0*Ls3xkEIzU9hvvA2T.png


You can also play around with resizing fonts

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaThDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--0c9432791c611062219d27f36879ab664ea3bcf8/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/2-0*GkuOAY97FS57ibOn.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaThDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--0c9432791c611062219d27f36879ab664ea3bcf8/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/2-0*GkuOAY97FS57ibOn.png


Using Prefix and Suffix

If the above adjustments to feed are still not enough for you, we have something extra! You can enrich your custom variable and add your own words or variable from the feed. With no limits to quantity. Just choose if you wish to add a word before (prefix) or after (suffix) your custom variable or at both positions at once.

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBakFDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--11e3e93b12357947b615e316d04ffff83843b064/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/3-0*qL6eU1yDVIyTXgte.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBakFDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--11e3e93b12357947b615e316d04ffff83843b064/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/3-0*qL6eU1yDVIyTXgte.png


You can use the prefix and suffix together

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBakVDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--78abc92a90e77ec29dea2b98ab8d8afb31d906c5/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/4-0*tGAOsQdcPbrFwIF_.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBakVDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--78abc92a90e77ec29dea2b98ab8d8afb31d906c5/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/4-0*tGAOsQdcPbrFwIF_.png


Find and Replace

You can replace:
  • A text with another text
  • A text with nothing (the selected text is deleted)
  • Select and delete unwanted text using RegExp (regular expressions — see our article on the blog)

Let’s look at a specific example. Imagine a “product name” in the feed in the following form:

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaklDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--0022038e7e12d1c508642a711094780672fbcd47/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/5-0*XZqs8r56QAeTmVuj.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBaklDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--0022038e7e12d1c508642a711094780672fbcd47/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/5-0*XZqs8r56QAeTmVuj.png


But we don’t like the form of the product name which should be inserted into the advertisement. We want to remove the numbers, dashes and replace the English “dolls” with Czech “panenky”. What can we do about it?

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBak1DIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--4c3befb0e334634e0f8137c393e9235cd30ce415/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/6-0*Ah7P7QecaYhF1dZh.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBak1DIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--4c3befb0e334634e0f8137c393e9235cd30ce415/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/6-0*Ah7P7QecaYhF1dZh.png



  1. Using the \d RegExp remove the numbers from the feed
  2. Insert a dash in the first box and leave the second box blank (dash is replaced with nothing)
  3. In the first line, insert the word Dolls that we want to replace. In the second line insert the word panenky which will be inserted instead of dolls.

This bit of magic is enough to get a product name usable for adverts.

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBalFDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--2f68e8454f52b436ec0db7503e9943625c62a342/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/7-0*u20zpQBu6lj7lbke.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBalFDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--2f68e8454f52b436ec0db7503e9943625c62a342/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/7-0*u20zpQBu6lj7lbke.png


In the top line you see your result. The bottom line is a preview of the original product name.

This way you can also remove the brand from the name.

Working with the product name free of the brand will then be pleasant without having to worry about problems with trademarks.


https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBalVDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--c621ca4aefc6e78d21b6bbb961d3c762ed4bb074/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/8-0*qoZfx-QRZoFaWGTs.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBalVDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--c621ca4aefc6e78d21b6bbb961d3c762ed4bb074/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/8-0*qoZfx-QRZoFaWGTs.png


In the preview, you can see how the brands were removed from the name.

Be careful not to become so enthusiastic about modifying that your product name remains too general.

Custom Numeric Variables

are used primarily to modify the unsatisfactory appearance of numbers in the feed:

You can round off, increase and decrease the price or “delivery_date”, or even add the missing VAT, see example:

Insert the _pricemin_ variable into the “custom variable” box, multiply it by the sum of VAT (21%) and 100% divided by 100: _pricemin_*(21+100/100). You get the following formula: _pricemin_*1,21

Besides the original values (bottom line in light gray), you see a preview of your final variables plus VAT (top row) in the right column.

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBallDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--a53cfd2b1c46decf66382eac4c888447d1b7301f/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/9-0*FLPpjqYQVNhP44Bq.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBallDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--a53cfd2b1c46decf66382eac4c888447d1b7301f/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/9-0*FLPpjqYQVNhP44Bq.png



Nevertheless, you can create much more using numeric variables:

Do you find “price for the product and delivery time” in your feed a little dull? Would you like to highlight in the advertisement (for some products) how many % of the price your client will save? Simply use a numeric variable.

Enter a formula and a variable to subtract % of the price (100%) in the “Input text” box: _pricemin_ / (100-discount) * 100 — _pricemin_

For example, if you have a 20 % discount, specify:

_pricemin_ / (100–20) * 100 — _pricemin_

The result then differs depending on the value of pricemin.

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBamNDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--5dc8c624fbe8c42ddea81babc79a5f4f037ef53d/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/10-0*yjAoIpmgNEPxjvom.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBamNDIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--5dc8c624fbe8c42ddea81babc79a5f4f037ef53d/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/10-0*yjAoIpmgNEPxjvom.png


There are many examples of how to use variables. Every client has different needs. Are you confused? Contact us and we will advise you specifically for your situation.



Michaela Zákopčaníková
Editor of PPC Bee
Start your 30-day free trial
Cancel anytime. No credit card required
Sign up with Google account
Or use your email
You're already signed in
Jump into PPC Bee

Related articles

Read more

FAQs – Summer Edition

or Answers to the questions you’ve been asking us most often lately.

By Michaela ZákopčaníkováJun 24, 2019 | 2 mins read

Read more

Capitalization in Ads

In the past, PPC Bee automatically changed your capitalized words. Because of them your ads can be rejected (primarily by AdWords). There are, however, several clients whose brand name is comprised of uppercase letters, and there was no way for them to keep this in their ads. Thus we have decided to meet their needs and now we have enabled capitalized words in ads.

By Michaela ZákopčaníkováSep 5, 2017 | 1 min read

Read more

Automate and win!

With PPC Bee, every information your data feed contains can be automated. Either you want to make sure that only ads for products in stock are running, or create keywords or ad texts. And since we are very curious about your approach to automation, and to what extent you make use of it, we decided to organize a competition!

By Michaela ZákopčaníkováAug 3, 2020 | 3 mins read