Bulk Pacing

The Quantcast Platform makes custom pacing easy. Two Pacing Spreadsheet formats allow you to edit daily spend targets offline for multiple active ad sets, at the same time. In this article:

Download and Upload the Pacing Spreadsheet

1. On the Campaigns page, click Bulk Actions, then select Download Pacing Spreadsheet.

   

2. Click Done in the modal window, then open the Campaigns Excel file that was downloaded to your computer. Once you have made the desired updates, save the Excel file.

   

3. Return to the Quantcast Platform, click Bulk Actions, then select Upload Pacing Spreadsheet.

   

4. In the Upload Pacing Spreadsheet window, click Select file.

   

5. Locate the Campaign Excel file on your computer, then click Open.

Note: This step may vary depending on your computer.

6. Review your change(s) and click Commit Changes to apply your change(s).

   

   Understanding the Pacing Spreadsheet Template

   

There are 3 key sections in the Pacing Spreadsheet template.

NOTE: In the Vitals section, minor variances between the $ remaining and $ scheduled values can be expected based on the data freshness. It is best practice to not override the last day of your ad set to ensure full delivery of your lifetime budget.

How to Edit the Offline Excel File

Option 1: Pacing Spreadsheet Template

• Open the downloaded Excel file and make sure editing is enabled.

• Make changes to the NEW TARGET column for each Ad Set.

  

Things to note when editing the file:

• Weekend dates are highlighted in blue

• Today’s date is in bold (or the date the spreadsheet was downloaded)

• Future dates are grayed out and will not have a spend value in the ACTUAL column

     3. After you have finished updating, save the Excel file, return to the Quantcast Platform, and Upload.

 Option 2: Flexible Pacing Spreadsheet

1. Build your own spreadsheet including only the Dates (in column A), Ad Set IDs (in row 1), and pacing changes needed. See the image below.

• Include only new budget targets, only for the ad sets and days you mean to change

• You must have ad set IDs across the top, dates down the left. 

• The dates do not have to be consecutive

• A blank cell will clear the target for that ad set on that date

2. Save the Excel file. Return to the Quantcast Platform, click Bulk Actions, then select Upload Pacing Spreadsheet.

3. In the Upload Pacing Spreadsheet window, click Select File.

4. Locate the Campaign Excel file on your computer, then click Open.

Note: This step may vary depending on your computer.

5. Review your change(s) and click Commit Changes to apply your change(s).