Description: This article describes creating, formatting, and uploading spot data. Spot files contain all your spots for a given period, which you can then upload to the InnovidXP platform, formatted according to our guidelines to ensure accurate attribution.

Watch our help video for a quick guide on uploading spot files. Remember to follow the formatting guidelines as described in this article before you upload.


Formatting guidelines

How should I format my spot file?
Include all spots within a date range Add placeholder spots for non-TV activity
Include as much detail as possible to maximize the analysis Load files with partial spots when attempting to update a spot
 Ensure spot times are to the nearest minute  

We recommend that you include as much detail as possible in your spot file to maximize your ability to analyze data and optimize your insights.

Ensure spot times are to the nearest minute and as accurate as possible; our attribution relies on accurate spot times to model results. When making the spot file, remember to include all the fields you would like to analyze when uploading; this will ensure you have the correct spot dimensions and metrics necessary to optimize your media plan.

Additional tips

  • The header names do not need to be specific, as we allow you to map fields to InnovidXP default names.
  • Always load a complete set of spots for a date range
  • If there is a mistake in the information within the file, you can correct the file and reupload it; this will overwrite the previous upload as long as the date range is the same

What to include in your spot file

InnovidXP requires a minimum of "date", "time", and "station" fields to produce attribution. However, only uploading those three dimensions would make optimizing very difficult; therefore, we have some recommended fields: "spot length", "cost", and "audience". If you are in a country with multiple time zones and, therefore, multiple feeds, we recommend always including a "feed" field that includes the values single, dual, triple, or quad as is relevant.

All other fields are optional or conditional. Optional fields add depth to your reporting and insights. Conditional fields are used in particular business cases, for example, when a promotional code is included in the creative for a spot. In this case, we want to ensure that clients who enter the code when making a sale receive significantly higher levels of attribution since we can match the code to a spot.

A unique conditional field for some countries, such as the U.S., is the market field. The market field will hold the market area where a local spot has aired. The market must be provided for the local spots since we will only use responses from that market area for attribution.

The following tables list the required, recommended, and optional column formats for spot files:

Required fields

Field Details
Date
Time
These can be separate or contained within one field. The most commonly seen format is to have the date and time separate and in the following formats: YYYY-MM-DD and hh:mm:ss.
Channel This is often referred to as Station and contains the name of the channel the spot airs on.

 

Recommended fields

Field Details
Spot length The length of the spot in seconds; this must contain only numbers.
Cost The value of each individual spot.
Audience The overall audience impacts or impressions that are given to a spot. This must be numeric and can indicate a thousands value or individual value.
Feed Indicates the feed across time zones of a spot, accepted values are single, dual, triple, quad.

 

Optional fields

Field Details
CPT This is often called CPM or cost per thousand and must be numeric with two decimal places.
Program The name of the program during which the spot was aired.
Genre The genre of a program.
Creative The name or ISCI code of the creative the spot is airing.
Saleshouse
The name of the network or Saleshouse from which the spot was acquired.
Position in Break (PIB) The position within the break that the spot was aired.
Position in Program (PIP) The position within the program that the spot was aired.

 

Example:

Screenshot 2023-11-14 at 09.53.27.png


Manually uploading a spot file

This task describes uploading your spot data to the platform to incorporate it into the attribution data model.

Note: Spot data must be uploaded as formatted log files, either pre- or post-campaign logs. Post-campaign logs are preferable, as this means your responses will be attributed relative to true spot times instead of predicted times.

  1. Select Data > Spots > Upload File:
    If this is the first time you have uploaded spots, the How to Upload tab is displayed, which contains tips on uploading and a video showing you how.

  2. Select the Upload Spot File button to display the New Upload tab.

    Spot Upload tab Description
    New Upload Lets you upload and configure a new spot data file, taking you through the following upload stages: File Selection, Configuration, Column Mapping, and Confirm & Submit.
    In Progress

    Displays spot data uploads that are still being processed in the following categories:

    • Processing Uploads: shows uploads that are complete and includes the progress of the spot data being added to the attribution data model
    • Unsubmitted Uploads: shows uploads that are partially complete but not yet submitted
    Processed Displays spot data uploads that are complete and submitted to the attribution data model.


  3. File Selection: either drag-and-drop or Click to Browse to select a spot data file, then select Upload to upload the file to the platform.

  4. Configuration: use this screen to select the required configuration options for the spot data file:

    Apply Settings
    : if you have previously uploaded a spot data file of the same format, you can select the same configuration from this dropdown. Or you can choose No – Start upload from scratch.

    Datagroup
    : select the data group you want to add the spot data file to or choose Default
    Data groups can give your spot data from different sources a level of separation and security.

    Spot data added to a separate data group will not overwrite existing data within the same date range. Data can only be uploaded to one data group at a time.
    You may use more than one data group if, for example, you are working with several different media agencies or are controlling access to the platform using roles and permissions.

    Audience
    : select the type of audience units in your uploaded spot data file from the dropdown, either Individually (1=1) or in Thousands (1=1000), to ensure that your audience numbers display correctly throughout the portal. 
    The audience figures provided must give the raw number of impressions (views) on each spot identified in the uploaded file and not, for example, the rating points (target or gross), as these metrics could be more helpful for attribution modeling in InnovidXP. 

    Timezone: select which time zones are supplied for your spot data. This can be a single time zone applied to all spots if, for example, they are broadcast nationally.

    Alternatively, you can configure it for regional/DMA time zones in the same countries. In such cases, ensure that your file contains distinct regional times of the spot data in the relevant marketing regions.

  5. Select Apply to continue.

  6. Column mapping: use this screen to map the data columns in your uploaded spot data file to the appropriate InnovidXP dimensions (see our tips for column mapping below), then select Next. The platform attempts to map the data columns to dimensions automatically, where possible.

    Tips for Column Mapping
    • Map additional data columns by dragging and dropping the labels in the top panel to the appropriate header field for your data file.
    • Dimensions for labels that have red tagging are required and must be mapped.
    • Labels with blue tagging are optional but recommended to enhance your attribution.
    • If a data column is not required, select the checkbox above the header to exclude it.
    • If you have a data column for which no dimension is available, contact the Innovid support team for assistance; if a data column is not mapped, then this data will not be available in the platform.


  7. Confirm and Submit: as a final confirmation step, use the summary information and date range graphic on this screen to check that the data and configuration are as you expect for the uploaded spot data file:

    i) Check the data range graphic to understand the effect of uploading the new file. Blue ranges in the date range graphic indicate existing spot data. Yellow ranges indicate overlapping data, which will be overwritten with data from the new file.
    ii) Your date range of new and existing spot data is very important, as new spot data files can contain overlapping data with previous uploads. This may be intended, for example, if you are uploading data from a previous campaign in higher detail than was originally available.
    iii) If you need to return to a previous step to modify the configuration for the spot data file, select Back to return to an earlier step.

  8. After you have checked the summary information displayed and are satisfied that your data and configuration are correct, you can select Submit File to submit the data for modeling.

Checking your spot upload

Select the Processed tab to view the status of spot uploads for the past 14 days. This page displays a list of Completed Uploads and shows the details for each upload. If there have been any failed uploads, they will be displayed on this page.

Screenshot 2023-11-14 at 10.41.48.png

Was this article helpful?
0 out of 0 found this helpful