PPC se mění na Dotidot.

Zjistěte více
Zpět
8 min čtení

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.
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
Jste již přihlášení
Přejít do PPC Bee

Související články

Další články

Buďte více vidět díky Google Ads rozšířením

Jak jen ta konkurence dostala ke své reklamě obrázek, telefonní číslo a informaci o slevě? Použila rozšíření reklam ve svém Google Ads účtu. Díky dodatečným informacím a vizuálním prvkům může získat více kliknutí. A vy můžete s PPC Bee taky. Dokonce umíme pár vychytávek.

Od Marek Turnhöfer16. 10. 2022 | 7 min čtení

Další články

Volná shoda se mění a s ní celý svět PPC

Klíčová slova ve volné shodě dostávají v posledních letech od Googlu daleko větší péči. Volná shoda je navržena tak, aby se vaše reklamy zobrazovaly i na spousty souvisejících dotazů. Tato výhoda však bývala kdysi vykoupena řadou nevýhod. To už však dnes neplatí. Představíme vám, proč byste měli začít používat volnou shodu ve svých kampaních také vy.

Od Marek Turnhöfer24. 10. 2022 | 8 min čtení

Další články

Jak expandovat s PPC Bee do světa

Kampaně již máte v PPC Bee vyladěné a poohlížíte se po sousedních trzích? Expanze je ve světě ecommerce čím dál častěji zmiňovaným tématem. Pojďme se tedy podívat, jak vám s ní alespoň v oblasti vyhledávání může PPC Bee pomoci.

Od Jiří Fiala14. 8. 2019 | 3 min čtení