Transmitting and processing data

You can transmit information via the API or on the Yandex.Metrica website. More information about transmitting data via the API. Transmitting offline conversions on the site is explained below.

Attention. First enable Recording offline conversions (Settings → Upload data).
  1. On the Settings → Goals page, create a JavaScript event goal. For the goal ID, specify the event to track (for example, order confirmation — “order_confirmed”). You will need this ID when creating a CSV file.

    If you want to analyze offline conversions separately from conversions on the website, enter a more specific description in Name (for instance, “Purchase in office”, “Offline goal”, or “Cash payment”). This will make it easier to find the goal in the list.

  2. Create a CSV file with conversion data, following the recommendations.
    Attention. In the file, specify data that relates to conversions that occurred after enabling Recording offline conversions.
  3. Upload the file to Yandex.Metrica.

    Before uploading a file, wait for the amount of time that usually passes between a user's session on the site and an offline conversion. For example, if your website allows up to 10 days to pay for an order at a pick-up point, don't upload data sooner than 10 days after enabling the extended conversion window. This is necessary because the conversion tracking period increases gradually to 21 days from the moment the option is enabled.

Preparing the CSV file

Specification for the CSV format

Overview of the CSV format

Fields for transmitting data
Field name Required Description Example
ClientID | UserID | yclid Yes ID of the website user or advertising campaign in Yandex.Direct 12345
Target Yes The goal identifier that was set when creating the goal in the web interface order_confirmed
DateTime Yes The time of the conversion (in Unix Time Stamp format) 1481718166
Price No Goal value 1000
Currency No

Three-letter ISO 4217 currency code.

If a different currency is passed, null values will be sent instead of currencies and amounts

RUB

The fields support a hierarchical data structure.

Uploading the file

To upload the prepared file with the data, go to the Settings page (the Upload data tab). In the Upload offline conversions, follow these steps:

  1. Click Upload data.
  2. In the window that opens, select the linking type depending on the type of the ID you want to upload.
  3. Select the file on your computer and add comments to the upload, if necessary.
  4. Click Upload data.

Sample CSV file for uploading data

File upload errors

Sometimes Yandex.Metrica can't match offline conversions to their respective sessions. The most common causes of matching errors are described below:

Reason for error Solution
The goal identifiers specified in the file were not found in Yandex.Metrica Make sure that the file contains the same goal identifiers as shown in Yandex.Metrica. You can check the goal identifier on the Goals tab in the tag settings.
The IDs specified in the file were not found in Yandex.Metrica

Make sure the way to transmit the IDs is set up correctly.

If you are using UserID and the data transfer is configured correctly, try uploading the file later. Most likely, some of the customers with the UserIDs specified in the file haven't visited the website yet, so the system hasn't had a chance to link their UserIDs from your database to their internal СlientIDs in Yandex.Metrica.

Session dates do not fall within the 21-day conversion tracking period.

This means that more than 21 days passed between the date of the user's last session on the website and the time when the file was processed, or the date of the last session preceding the conversion is earlier than the date when the extended tracking period started.

In this case, you won't be able to add offline conversions to Yandex.Metrica. Learn more about the extended conversion tracking period