Manage to advertise centrally using configuration CSVs

Learn a new way to set up advertising in Mergado automatically and in bulk. Ever since we introduced the rule for importing data from CSV files, you can edit specific parts of your advertising from one place by creating configuration CSVs. Let's see how you set everything up in a few minutes.

How to create bulk settings using CSV

Let's explain everything with an example:

We need to set different CPCs for different hours of the day. We have an export for a comparison engine with a default CPC bid in the CPC element. We want to change its value over the day by multiplying the default CPC by a certain coefficient. Its amount will vary from hour to hour. We have several such exports, and we want to manage the coefficients centrally.

Postup:

To create a configuration CSV, we must first get the current hour element into the products. In the same way, we can work with days of the week, month, and so on. We will use the Bidding Fox Elements application and turn on the BFE_D_EXECUTE_HOUR element. It will be filled with an integer value from 0 to 23 indicating the hour. E. g. at 15:24 is number 15.

Let's create a CSV file that will contain columns:

  • BFE_D_EXECUTE_HOUR numbers 0 - 23 indicating the hour
  • CPC_COEF coefficient by which we will multiply the default value of CPC – in our case numbers with a decimal point
  • separate columns with a comma

How to create a CSV

We will create a CSV in an ordinary text editor – e. g. Gedit, LibreOffice, Notepad, or the eM Files app.

How to get CSV on the Internet

The URL of the CSV file must be available, so we must place it on the Internet. The eM Files app will help us with this, which allows you to post the file to a public URL (with access by other users in Mergado) and make changes to it using its simple editor.

Method:

1. In the export for the coefficient, create a new element CPC_COEF.

2. Use the Import data file rule to import data from CSV into the CPC_COEF element.

 

  • The pairing column is the BFE_D_EXECUTE_HOUR element.
  • For example, if the time is 15:24, the BFE_D_EXECUTE_HOUR element contains a value of 15 for all item items.
  • The number from line 15 is imported into the CPC_COEF element. In the case above, the number 1.2.

3. We assume that we have set a default CPC value before.

  • To take into account the coefficient, we will use the calculation rule.
  • Multiply the default CPC by CPC_COEF, i. e. %CPC% *%CPC_COEF%, and enter it in the CPC element.

And that's all. The output value will now start to change according to the hour when the data is regenerated. The change in the configuration file will be reflected in many exports.

 

  • You can share settings between exports - you will prepare one configuration file and use it repeatedly.
  • Configuration can be linked to Bidding Fox Elements – hour, day of the week, etc.
  • You can also use the principle of the central configuration CSV, for example, for transfers of clothing sizes or other tasks repeated on multiple exports.

You can handle this setting in a few minutes. Probably faster than how long it took you to read this guide.

Bidding Fox Elements

Improve your advertising with dozens of new elements with Bidding Fox Elements. This app works with statistical data from different sources and creates new elements. This will help you fine-tune your advertising and enhance your performance.

eM Files

With eM Files, you place files on the Internet so that they are publicly available and accessible to multiple users. This can greatly facilitate your work, because you do not have to wait for the data to complete an online store itself.

Read more:

Speed up the import and export of data in Mergado. Using Google Sheets

The goal of every e-shopper and marketer is to speed up the work of setting up advertising. In Mergado, in addition to the usual tasks, you can now reduce the time of data import and export by using Google Sheets. Let's show you how to use this function.

20.11.2020
Setting categories is not difficult anymore. With the smart rule in Mergado

When managing advertising for comparison engines, you need to set the correct categories according to the category tree of the specific engine. Mergado users can do it with a rule which will significantly speed up the selection of categories. See how to do it.

29.10.2020
Learn how to work with the Find and Replace rule. It speeds up your work in the feed

Set up advertising as you need by using a handy tool for editing text in an XML feed. With the Find and Replace rule, you can replace, remove, or fix bugs on products across the entire feed. Let's show you how to use the rule and set it up for your online store.

20.10.2020

Add new comment