How to create a feed file for real estate ads. RSS, XML, Atom - What is it and how will it help me use the Web more effectively? Additional feed settings

This article shows you how to create a tab-delimited data feed. If you are more comfortable using a text editor, skip the steps below, but make sure your feed meets the requirements listed at the bottom of the page.

You can also create a feed using Google Sheets. How to do this has been written. To create an XML feed, see the spec or.

Examples of data feeds
You can see examples of feeds in TXT and XLS formats. Please note that the XLS file is provided as an example only. The system does not support feeds in this format.

How to create a data feed

Step 1: Open a spreadsheet program

With spreadsheet programs such as Microsoft Excel, you can easily create a data feed and convert it to the format you want.

Step 2. Create a title bar

In the first line of the spreadsheet, enter the names of the attributes that describe the product (one in each column). For your products to appear on Google Shopping, you need to provide information about them in a highly structured manner. There are two types of attributes that will help you with this:

required;
recommended.

Products for which the required attributes are not specified will not be processed. You don't have to add the recommended attributes. However, we recommend that you do this so that your products appear more frequently in search results. Check out the example header row below to find out the required attributes for the selected target country.

Step 3. Enter information about the goods

In the lines under the heading, provide information about the products according to the selected attributes. Please note that each product should be assigned a separate line, and information about it should be distributed to the appropriate columns. For example, a product description should be in a column titled "description". If there is no attribute value for this product, leave the cell blank.

Step 4. Convert the spreadsheet

Most spreadsheet programs allow you to export data to a tab-delimited text file. This is the file that should be submitted to the Google Merchant Center. There are several ways to create it. Below are two of them.

If you are using Microsoft Excel, save the spreadsheet as a tab-delimited text file (.txt). To do this, click Save as in the tab File... In the dropdown menu File type select Text Files (Tab Delimited) (* .txt).
Using Google Sheets you can upload any of your spreadsheets or customize them to the Merchant Center. Alternatively, you can download the spreadsheet by following these steps: in the menu File click Download as, and then - TSV (current sheet)... To save the table as a TXT file, select Save as… on the menu File your browser.

If you have already registered the feed with your Google Merchant Center account, use the same name as the specified file.

Step 5. Submit your data feed

Make sure the generated file meets the format requirements below and.

Format requirements

The file must contain normal tab-delimited text.
The first line in the file must be a header, consisting of the attribute names, separated by a tab.
Each product should be on a separate line and attribute values \u200b\u200bshould be tab-delimited.
There should be no tab characters at the end of lines.
Attributes should not contain tabs and line breaks.
For group attributes such as tax [tax] and shipping [shipping], the sub-attributes must be separated by colons.

If the attribute accepts several values, specify them separated by commas, for example, blue, green, red. If a comma is part of an attribute value and cannot be used to separate it, enclose each value in quotation marks.

Note that for some attributes, such as id [identifier] or description [description], you can only specify one value.

Was this information helpful?

How can this article be improved?

Yandex.Direct offers a number of tools to help automate the creation of contextual advertising. In particular, it will be useful for online stores to create product feeds - a kind of databases of goods that, with certain manipulations, can be shown in Yandex.Direct ads without additional dreary manual work.

What are feeds in Direct

Feeds are used primarily to create and. That is, these types of ads, which provide a certain template, where you can simply substitute product names, price, some other data, and create ads for hundreds or thousands of products in a couple of clicks.

A product feed is a file in one of the following formats:

YML (Yandex Market Language) - a format created specifically for

It is very convenient to use the feed, because it makes it easier to update information on the availability of goods, prices, promotions, add product characteristics, group ads depending on the product category.

How to create a feed for Direct

As mentioned, feeds work for dynamic ads and smart banners, which have their own restrictions on the subject of goods. Perhaps the number of topics will expand over time.

We will analyze the creation of a feed for retail.

The feed for retail products must be in YML format (for other topics, CSV or XML are possible). Like an XML document, it uses one element: ... The list of all product offers is in the item and element contains information about one product. To make it clearer what it looks like:

There are several ways to create a YML file. We recommend trying out automated, using the service mysitemapgenerator.com.Here you will need to go to the section YML generator.

As you can see in the example above, there is a series parametersthat can be entered into an XML file (or YML). For retail, for example, the list looks like this.

As you can see, there are many settings. There is a list with its own characteristics for each topic, and the full set of parameters can be found in Yandex Help.

Create dynamic feed ads

When uploading a feed, select its type and enter a name.

We have released a new book, "Content Marketing on Social Media: How to Get Into the Heads of Subscribers and Fall in Love with Your Brand."

An XML feed is a structured database of real estate in XML format. This is a text file that allows Yandex to process and structure information. Its use saves time and facilitates the work of real estate specialists, eliminating the need to add and edit information in ads on their own.

What is an XML feed

In the course of work, companies that provide intermediary services between the seller and the buyer feel the need to connect the site to the popular information integrator system - Yandex.Real estate. The integrator is designed to publish and search ads for the sale / rent of apartments, houses, land and commercial areas.

You need to create an XML feed if you have a large number of objects. It allows you to work with many ads, making the task much easier for employees. Today almost every agency uses this tool. It is generated directly from the website of a real estate agency or an offline database in XML format, after which the ad goes to the real estate board. There are several ways to create a feed:

Create a web resource with a built-in XML upload module. This is the most reliable and fastest type of data transfer. When creating, we recommend using the CMS Sitebill real estate website builder script. It offers users several modules for forming a feed in XML format Yandex Real Estate, CIAN, AFY.
Using the services of external services. There is CRM application software that allows you to generate XLM feeds from ads. The most famous services are ReCRM and JCat.

These services save time and contain the optimal balance of the necessary functions. However, using them requires an investment of money, and in order to publish ads on popular boards on the Internet, you need to transfer them from the site base to the service base.

How to create a feed

There are several ways to create an XML feed. The first and the simplest one is to find a specialist. There are special generator services for independent work on the Internet. They allow you to automatically generate XML files for Yandex.Realty. The process of working in them is extremely simple: you need to specify a link to a web resource, set individual parameters and start generating.

Another way to create a feed is to manually configure it. To facilitate the process, it is recommended to use ready-made examples from Yandex and, using them, create files for your own site. Here you need Excel or another free text editor that provides the ability to edit text and automatically create a backup copy of the saved files. Upon completion of the work, you need to save the feeds in CSV format and upload the finished result to Yandex.

There are a number of rules that must be followed when filling out a feed. In particular, it should contain only relevant ads that are present on the web resource. Moreover, each category of ads must contain a separate set of parameters. If you do not follow these rules (incorrect display of the accuracy and number of parameters), the semantic match to the search query of the ads will decrease, and they will take low positions in the search results.

The ad text must not contain HTML-code elements, and the feed contains the parameters marked by the advertiser for Yandex.Realty. It is important to exclude all settings of a web resource related to geographic coordinates so that this information is not displayed in ads.

How to edit and validate an XML feed

Export XML files are validated using the Yandex XML feed validator. The tool simplifies the debugging of export files and significantly reduces the time it takes to get into the databases of partner programs. The validator allows you to check the structure of a file, but not its content.

After the files are uploaded, the user can view detailed information about all ads, find out what errors have occurred and what needs to be done. But validation of XML feeds doesn't end there. There are types of errors that neither the validator nor the loader can recognize.

First of all, you need to get a free text editor program Notepad ++, since a regular Excel spreadsheet will not be able to display data correctly. Notepad ++ has a lot of advantages, the main one of which is the ability to see the feed as it will be presented in Yandex. Here you need to check:

Completeness of the loaded data. To do this, select a random ad from the site, find it by IP in the uploaded file in a text editor and check how the site content matches the data presented in the file itself.
Correctness of data format. You need to check whether the existing format meets the basic requirements for an xml feed on Yandex. Real estate: correct spelling of numbers, units of measure, text content, etc.

If the site database contains a large number of ads (from several thousand to tens, hundreds of thousands of ads) and therefore the XML file is too large, we recommend using the gzip file compression and recovery utilities. This will speed up the boot process and protect against network outages.

Another useful feature on YouTube that will improve engagement with your audience is feeds ... ..

Many have not yet fully understood the purpose of this option, therefore, they often ignore it.

Below, we'll explain in detail how to open your YouTube feed and how your channel will benefit. ↓↓↓

Why is it needed?

On many sites you can find RSS feeds where all the latest news is published.

This is very convenient, because the user can skim through the fresh content from their phone or any other device ...

On YouTube, this option is called a feed and it reflects the user's activity (all his actions) - added videos, ratings, comments, and more.

Once on the page, you can see the owner's preferences and more.

So what is a channel feed?

Translated from English, "feed" is the food you give the audience.

In simple terms, this is your activity feed. Here the viewer can always see what has happened on the channel.

This is true, first of all, for popular projects with a large user audience.

If necessary, you can hide all this data.

3 reasons to open your YouTube feed: ↓↓↓

The page becomes more attractive;
Users learn about your preferences;
Trust in the project is increasing.

Simple instruction

First of all, you should go to the section with your account settings.

Here you need a privacy clause (https://www.youtube.com/account_privacy).

Here you need to uncheck the "Like" section: ↓

Don't show information about what videos I liked;
Do not show information about saved playlists.

After that, we mark all the items that are available in the "Feed" section.

Here you can briefly familiarize yourself with why this option is needed and so on.

Then go to the main page of the channel and go to the "Details" tab.
Here in the upper corner of the page there is a "Pencil" icon, by clicking on which you can customize the appearance of the page.
In this section, we choose the "Overview" page view.
Here we set the necessary checkboxes so that the page displays “Like” marks, comments, and more.
Now you click on the "Save" button and you can proceed to the next stage.
To check it, you can put a few likes, watch interesting videos, leave comments and subscribe.

If everything is configured correctly, then the corresponding notifications should appear on the main page. This is what your users will see.

In March Yandex.Direct finished testing smart banners and made several additions to the format. Updated smart banners pass moderation faster, you can drag any field from the feed into the header, and now you can look at creatives before saving. In addition, the format is new types of feeds, including the universal Yandex feed. Thanks to it, almost any business can launch smart banners.

Let's take a look at how to create a smart banner campaign using Yandex Universal Feed.

What is a feed in Yandex.Direct

When creating smart banners or dynamic ads in Yandex.Direct, you need to prepare a feed - a file that contains information about the product range. On its basis, the system forms an ad in accordance with the user's requests. The offer dataset in the feed determines what information is shown to the user in the ad.

You can add to the feed the entire range of goods or services of the advertiser or a specific category that needs to be promoted.

Let's move on to creating a campaign in the Yandex.Direct interface.

Standard settings

Add feed

You can create a feed when setting up a campaign or on the Manage Feeds page.

Yandex.Direct has several types of feeds that are suitable for different areas of business:

retail - Yandex.Market feed, but also suitable for smart banners;
hotels;
cars;
the property;
air tickets;
other business.

The format of the document, the set of required elements and technical requirements depend on the type of business. You can save up to 20 feeds in Yandex.Direct simultaneously.

After choosing a topic, you need to upload a file in CSV format or provide a link to its location on the site. The file must be accessible via the link via HTTP, HTTPS or FTP. The feed size cannot exceed 512 MB.

The system can also automatically remove inappropriate UTM tags from links in the feed, if you enable the corresponding option during upload.

You can download examples and templates for almost all types of feeds in the Yandex Help Center.

After uploading, the file will be sent for validation, which usually takes no more than a few hours. The system checks the presence of required elements, their correct name and absence of repetitions.

If the check is successful, the feed status will be updated to "Upload successful". Then you can select it from the list and add it to the campaign.

Setting up the Other Business feed

Any of the following can be downloaded using the Other Business feed type:

yandex universal feed;
adWords "Special" feed;
adWords Travel feed.

All files must be in CSV format. The file can also be downloaded as an archive with the extension .zip or.gz. The first line should contain the names of the columns, the next - data about the advertised offer. All data must be in UTF-8 encoding. Columns are separated by commas, so avoid them in your feed.

The Yandex universal feed for smart banners contains the following required elements:

ID - a unique identifier for a product or service;
URL - link to the landing page;
Image - link to the image for the banner.
It is also recommended to add additional elements that will make your ad more informative and attractive:
Title - the name of the product or service;
Description - description;
Price and Currency - price and currency;
ID2 - the second identifier for stores with e-commerce connected to Metrica;
Old price - no discount price or old price.

You can download the Yandex universal feed template in the Yandex.Direct help.

Additional feed settings

After the feed has been loaded and validated, you can add URL parameters to the link, which will transmit data to the analytics system. To do this, select "Add parameters to links".

And one more option: you can enable the substitution of the title from the feed into the banner text by activating the setting "Substitute text from feed as title". Be sure to include the feed element that you want to pull up in your ad, such as Title.

Create a creative

A smart banner is created using the creative builder.

The ad design depends on the type of business. Each topic presented has certain layouts and image formats.

The new Preview feature allows you to see if the feed items were pulled up correctly in your ad. To do this, select the desired one from the list of loaded feeds.

Ad Maker lets you add your own background image, organization logo, call-to-action button, and change their color.

In some layouts, you can enable the "Special Offer" option. It makes it possible to add clickable text to the banner, and with its help draw attention to promotions or discounts. To do this, you need to fill in the field with the text of the special offer, choose a color scheme and provide a link to the page of the site where it is located.

A feed can have many products, and offers can be scrolled in a carousel or mosaic.

After you save your creative, you need to add it to the banner group for your campaign. There can be a maximum of 50 banners in one group.

Adjust filters

After creating the banner, you need to configure the settings for the ad group. A prerequisite for smart banners is filter settings. Using the filter, the advertiser can specify which products from the feed will be shown to the selected audience.

First, define your audience for the impression:

were interested in similar products on the network;
viewed products on my website;
both groups.

All or some of the products from the feed can be shown in the smart banner. To limit their number, write down the conditions for selecting goods.

For smart banners, you can set up to ten conditions and combine them by operators " AND " ... One condition can contain several ranges combined by the operator " OR " ... Range selects products that fall within the specified range.

In one campaign, you can create several groups of banners, divide them into categories and show users the offer that best suits their interests.

If you chose the Optimize Clicks or Optimize Conversions strategy when creating your campaign, you will need to limit your CPC.

Fill in the rest of the fields for the banner group: negative keywords, tags, and double-check your time and geographic targeting settings.

Finally

Smart banners are an effective way to advertise on networks, which helps tell or remind the audience about the offer they are interested in. Using a feed partially automates the creation of campaigns and allows you to make bulk changes to them. This helps Professionals save time and control ad groups in their account.

It might be helpful to read: