How-To: Backfill a datasource

Overview

When you first set up a datasource, or if a data load is missing or incorrect, you may need to backfill it. Backfilling can be done in two ways:

• Uploading a file containing the missing data

• Selecting a date range to backfill using the partner API

Instructions

1. Data Deletion (If Needed)

If data already exists in the datasource for the dates you want to backfill, you must delete that data first.

How to delete data:

• Go to the Audit tab within the datasource.
  

  

• Open the Row Count By Date drop-down.

• Delete the data for the relevant date range.
  

  

  
  

2. Manual Upload

To backfill a manual datasource by uploading a file:

1. Go to the Load Data section.

2. Click Choose File and select your file containing the required date ranges.
   

   

3. Click Upload File.
   

   

4. After the upload completes, click Save.

3. Backfill from Partner API

To backfill a datasource from a partner (e.g., Facebook):

1. In the Load Data section, select custom Start and End dates, or use the preset ranges under the Backfill button.
   

   

2. Click Load Data.

   • A progress bar will appear on the next screen.

   • After processing, a popup will confirm that your job is finished and notify you of any warnings or errors.
     

     

     
     

Related articles