Uploading Ad Schedules

• Step 1: Upload your spreadsheet
• Step 2: Map your data
• Step 3: Finalize the import
• Step 4: Revising your schedule
• Tips for a smooth import

Below you will find a step-by-step guide on how to upload and map your ad schedules in Masslytics.
Your ad schedule tells Masslytics when your ads aired, so it can match website traffic to those moments.

Step 1: Upload your spreadsheet

Go to the ad schedule importer:
https://app.masslytics.io/broadcasts/import

Upload your spreadsheet file containing the broadcast moments of your ads on TV, radio or DooH.
Supported file types: .xlsx, .xls, and .csv.

Once uploaded, select the row number that contains the column names.
This helps the system map your data more easily.

Step 2: Map your data

After uploading, the importer will guide you through mapping your spreadsheet data to Masslytics fields.

• Select the Brand you want to import the ad schedule for.
  If your brand is not yet in the list, you will need to create it first and install the pixel.
• Select the Timezone of your ad schedule.
  This ensures that Masslytics correctly adjusts for time differences.
• Optionally: map the Commercial Name column.
  If your spreadsheet does not contain this, you can either:
  • Select None (Masslytics will not track commercials for AB-testing)
  • Or use No column, but… to set a single commercial name for all broadcasts.
• Optionally: map the Channel Name column.
  If your spreadsheet does not contain this, you can either:
  • Select None
  • Or use No column, but… to set a single channel name for all broadcasts.
• Select the Broadcast Time column.
  Time must be in HH:MM or HH:MM:SS format.
• Select the Broadcast Date column.
  Specify the date format order used (to clarify whether 01-03-2025 means March 1 or January 3).
• Optionally: set the Impact Score column.
  You can use reach (GRP, impressions) or price as a measure of impact.
  This helps Masslytics learn which spots are likely to perform better relative to others, and enables comparisons between channels.
• Indicate whether the schedule contains the full campaign period.
  If enabled, Masslytics can compare in-campaign and out-of-campaign periods more effectively.
  If you are unsure, leave this turned off.

Step 3: Finalize the import

Once all fields are mapped, click on the Import button.
Masslytics will process your data and show a message with the number of successfully imported broadcasts.
Verify this number matches your expectations.

Step 4: Revising your schedule

It is possible to upload a preliminary ad schedule even if you expect the schedule to change during the campaign.
Masslytics will show you preliminary results in real time as broadcasts happen.

If you need to revise your schedule during or after the campaign:

1. Create a spreadsheet with only the additional moments that did happen.
2. Upload this spreadsheet through the importer.
3. Go to https://app.masslytics.io/broadcasts and manually delete the broadcast moments that did not happen.
4. Go to your Brand at https://app.masslytics.io/brands, click on the eye icon of the brand, and click the button Recalculate results.
5. After approximately one hour, the revised results will appear in your dashboard.

Alternatively, if your schedule needs a complete reset, you can send a fully corrected schedule to our Support page and we will reset your schedule for you.

Tips for a smooth import

{info} Make sure your spreadsheets are stripped of unnecessary data outside the table (extra rows, headers, side notes, etc.). This helps the importer process your data more effectively.

If you encounter any issues while importing your ad schedules, please contact our support team.
We’re happy to help you get everything set up correctly.