Zpět
8 min čtení

Working with Variables

Blog placeholder 2Blog placeholder 2
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.
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.



Zkuste trial na 30 dní zdarma
Zrušit lze kdykoliv. Platební karta není potřeba.
Registrace pomocí Google účtu
Nebo použijte váš email
Už jste přihlášení
Přejít do PPC Bee

Související články

Další články

Videotutoriály v PPC Bee

Uvědomujeme si, že ačkoliv vám kampaně vytvořené v PPC Bee přinášejí vysoký výkon, jejich nastavení nemusí být pro každého úplně hračka. A proto každý den usilujeme o vylepšení PPC Bee tak, aby se vám s ní pracovalo co nejpříjemněji. Zároveň se snažíme o to, abyste měli vždycky po ruce někoho nebo něco, co vám s nastavováním účtu píchne, když si nebudete vědět rady.

Od Michaela Zákopčaníková 3. 8. 2017 | 3 min čtení

Další články

Vyzkoušejte chytré kampaně v Nákupech Google v PPC Bee

Jednou z hlavních věci, které přináší poslední verze PPC Bee, je osamostatněný proces vytváření chytrých kampaní v Nákupech Google. Ty jsou kombinací standardních kampaní v Nákupech Google a obsahových kampaní s remarketingem. Nejen, že přinášejí opět o něco jednodušší správu kampaní, ale také díky nim můžete maximalizovat hodnotu konverzí a rozšířit zásah.

Od Michaela Zákopčaníková 9. 4. 2020 | 6 min čtení

Další články

Jak funguje dynamický remarketing na Facebooku

Remarketingové kampaně na Facebooku v podání PPC Bee už jsou ve fázi testování s prvními klienty. Dnes se však zaměříme na to, jak vlastně remarketing na Facebooku funguje.

Od Michaela Zákopčaníková22. 5. 2020 | 6 min čtení