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

This article explains how to create a tab delimited data feed. If you prefer to work in text editor, skip the steps below, but check if 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 is written. To create an XML feed, study the specification or .

Data feed examples
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

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

Step 2: Create a title bar

In the first row of the spreadsheet, enter the names of the attributes that describe the product (one in each column). In order for your products to appear on Google Shopping, you must provide information about them in a strictly structured way. Two types of attributes will help you with this:

  1. mandatory;
  2. recommended.

Items not listed required attributes, will not be processed. Recommended attributes can be omitted. However, we recommend that you do this so that your products appear more often in search results. Check out the title bar example below for the required attributes for the selected target country.


Step 3: Enter product details

In the lines below the heading, enter information about the goods in accordance with the selected attributes. Please note that each product should be assigned a separate line, and information about it should be distributed in the appropriate columns. For example, a product description should be in a column with the heading "description". If there is no attribute value for this product, do not fill in the cell.


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 sent to the Google Merchant Center. You can create it in several ways. Below are two of them.

  • If you are using Microsoft Excel, save the spreadsheet as a tab-delimited text (.txt) file. To do this, click Save as tab File. drop down menu File type select Text files (tab delimited) (*.txt).
  • With Google Sheets you can upload any of your spreadsheets to the Merchant Center or customize . In addition, you can download the table by doing the following: in the menu File click Download as, and then - TSV (current sheet). To save the spreadsheet as a .txt file, select Save as… on the menu File your browser.

If you have already registered your 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 plain text with a tab delimiter.
  • The first line in the file must be a header consisting of attribute names separated by tabs.
  • Each product must be on a separate line, and attribute values ​​must be separated by tabs.
  • Lines must not end with a tab character.
  • Attributes should not contain tabs or line breaks.
  • For group attributes such as tax [tax] and shipping [shipping] , nested attributes should be added separated by a colon.

    • If the attribute accepts multiple values, specify them separated by commas, such as blue, green, red. If a comma is included in an attribute value and cannot be used as a separator, enclose each value in quotation marks.

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

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, i.e. a kind of database of products that, with certain manipulations, can be shown in Yandex.Direct ads without additional tedious manual work.

What are feeds in Yandex.Direct

Feeds are primarily used to create and . That is, such types of ads that provide a template where you can simply substitute the names of goods, price, and 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

Using a feed is very convenient, 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 Yandex.Direct

As mentioned, feeds work for dynamic ads and smart banners, which have their own restrictions on product topics. 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 is possible). It, like an XML document, uses one element: . List of all product offers is in the element , and the 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 an automated, using the service mysitemapgenerator.com. Here you will need to go to the section yml generator.

As seen in the example above, there is a series parameters, which 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. Each topic has its own list with its own characteristics, and the full set of parameters can be found in Yandex Help.

Creating Dynamic Feed Ads

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

We released new book"Content Marketing in in social networks: How to get into the head of subscribers and fall in love with your brand.

An XML feed is a structured real estate database presented 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 professionals, eliminating the need to manually add and edit information in ads.

What is an XML feed

In the course of work, companies that provide intermediary services between the seller and the buyer, they 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 plots and commercial areas.

An XML feed must be created in case of a large number of objects. It allows you to work with multiple ads, significantly simplifying the task for employees. Today, almost every agency uses this tool. It is generated directly from the site of a real estate agency or an offline database in XML format, after which the ad is sent to the real estate board. There are several ways to create a feed:

  1. 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 generating a feed in XML format Yandex Real Estate, CYAN, AFY.
  2. Use of external services. There is an applied software CRM, it allows you to generate XLM feeds from ads. The most famous services are ReCRM and JCat.

These services save time and contain the optimal ratio of necessary functions. However, their use requires investment. Money, and in order to publish ads on popular boards on the Internet, you need to transfer them from the site database to the service database.

How to create a feed

There are several ways to create an XML feed. The first, and easiest, is to find a specialist. For independent work on the Internet, there are special services-generators. They allow in automatic mode generate XML files for Yandex.Real Estate. 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 manual setting. 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 will need Excel or another free text editor that provides the ability to edit text and automatically create backup copies of 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 observed when filling the feed. In particular, it should contain only relevant ads that are present on the web resource. In addition, each category of ads must contain a separate set of parameters. If you do not follow these rules (incorrectly display the accuracy and number of parameters), the semantic match search query ads will go down, and they will rank low in the search results.

The ad text must not contain HTML code elements, and the feed contains the parameters specified by the advertiser for Yandex.Real Estate. It is important to exclude all web resource settings 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 Yandex's XML feed validator. The tool simplifies debugging of export files and significantly reduces the time it takes to enter databases affiliate 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 announcements, find out what errors have occurred, and what needs to be done. But the 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 the free text editor program Notepad ++, since the usual spreadsheet Excel will not be able to display the data correctly. Notepad++ has a lot of advantages, the main of which is the ability to see the feed as it will be presented in Yandex. Here you need to check:

  1. The completeness of the uploaded 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.
  2. The correctness of the data format. It is necessary to check whether the existing format meets the basic requirements for the xml feed on Yandex. Real estate: correct spelling of numbers, units of measurement, 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 gzip file compression and recovery utilities. This will speed up the download process and protect against network failure.

Another useful feature on YouTube that will improve the interaction with your audience is feeds…..

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

Below we will detail how to open your YouTube feed, as well as what benefits your channel will receive. ↓↓↓

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 fresh content from his 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.

By going to the page, you can see the owner's preferences and much more.

So what is a feed on a channel?

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

talking in simple terms, this is your activity feed. Here, the viewer can always see what's new on the channel.

This is relevant, 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: ↓↓↓

  1. The page becomes more attractive;
  2. Users will learn about your preferences;
  3. Confidence in the project is growing.

Simple instruction

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

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

Here you need to uncheck the "I like" section:↓

  1. Do not show information about which videos I liked;
  2. 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 see why this option is needed and so on.

  1. Next, go to the main page of the channel, and go to the "Details" tab.
  2. 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.
  3. In this section, we choose the view of the "Overview" page.
  4. Here we set the necessary checkboxes so that the page displays “Like” marks, comments, and more.
  5. Now you click on the "Save" button and you can proceed to the next step.
  6. To check, you can put a few likes, watch interesting videos, leave comments and subscribe.

If everything is configured correctly, then appropriate 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, any field from the feed can be added to the header, and creatives can now be viewed before saving. In addition, the format includes new types of feeds, including the Yandex universal feed. Thanks to him, almost any business can launch smart banners.

Let's see how to create a campaign with smart banners using the Yandex Universal Feed.

What is a feed in 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. Based on it, the system generates an ad in accordance with user requests. The offer data set in the feed determines what information will be shown in the ad to the user.

You can add the entire range of goods or services of the advertiser to the feed, or separate category to be promoted.

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

Standard settings


Add a feed

You can create a feed during the campaign setup process or on the Manage Feeds page.

There are several types of feeds in Yandex.Direct that are suitable for different directions business:

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

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

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

Also, the system can automatically remove unsuitable UTM tags from links in the feed, if you enable the corresponding option when loading.

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

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

If validation is successful, the status of the feed will be updated to "Download Successful". Then you can select it from the list and add it to the campaign.

Setting up the "Other business" feed

With the Other Business feed type, you can upload any of the following:

  • Yandex universal feed;
  • AdWords "Special" feed;
  • AdWords "Travel" feed.

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

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

  • ID - unique identificator goods or services;
  • URL - link to landing page;
  • Image — link to the image for the banner.
  • It is also recommended to add additional elements that will make the 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 Yandex.Metrica;
  • Old price — price without discount 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 that will transfer data to the analytics system. To do this, select "Add parameters to links".

And one more option: you can enable substitution of the title from the feed in the banner text by activating the setting “Insert text from the feed as the title”. Be sure to specify the feed element that should be pulled into the ad, for example Title.

Create a creative

A smart banner is created using the creative builder.

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

The new "Preview" function allows you to see if the elements of the feed are correctly pulled into the ad. To do this, select the required feed from the list of downloaded feeds.

The Ad Builder allows you to add your own background image, organization logo, call to action button and change their color.

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

There can be many products in a feed, and offers can scroll in a carousel or mosaic.

Once the creative is saved, it must be added to the banner group for the campaign. A maximum of 50 banners can be in one group.

Set up filters

After creating the banner, you need to set the settings for the ad group. Required condition for smart banners — 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:

  • were interested in similar products online;
  • viewed products on my website;
  • both groups.

A smart banner can display all or some of the products in the feed. To limit their number, write down the conditions for selecting goods.

You can set up to ten conditions for smart banners and combine them with operators " AND " . There can be several ranges in one condition, combined by the operator " OR " . The range selects products that fall within the specified range.

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

If you chose the "Optimize the number of clicks" or "Optimize the number of conversions" strategy when creating a campaign, you will have to limit the CPC.

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

Finally

Smart Banners - effective method advertising in networks, which helps to tell or remind the audience about the offer that interests them. Using a feed partially automates the creation of campaigns and allows you to make changes to them in bulk. This helps professionals save time and control the ad groups in their account.

 

It might be useful to read: