Bulk Uploader: Creating Your Spreadsheet

Excel

1. Open a new Excel workbook.
2. Go to the Data tab.
3. In the Get External Data group, select From Text.
4. Locate the CSV file you downloaded and select Get Data.
5. In the Text Import Wizard:
   
   1. Choose Delimited as the original data type, then select Next.
   2. Select Comma as the delimiter and deselect Tab, then select Next.
   3. Prevent Excel from converting your formats: 
      
      1. In Data preview, select the first column.
      2. Scroll to the last column, then select it while holding Shift to highlight all columns.
      3. Under Column data format, choose Text, then select Finish.
6. Select OK to insert the data into cell A1.
7. Save the Excel file as a CSV before uploading it to the Bulk Uploader tool.

Google Sheets

1. Open Google Sheets.
2. Select File > Import, then go to the Upload tab.
3. Upload the CSV file you downloaded.
4. In the import settings:
   
   1. Choose Import location (for example, Insert new sheet).
   2. Select Separator type.
      
      1. If Detect automatically doesn't work, open the CSV in a text editor and confirm the separator. Then select that option.
   3. Set Convert text to numbers, dates and formulas to No.
5. Select Import Data.
6. Make your edits, then download the file again as a CSV before uploading it to the Bulk Uploader tool.

Campaign Key (editing only, required)

This is the encrypted [advertisementId] of the campaign.

• Do not edit or remove this field when updating campaigns.

Potential errors

• Invalid [Campaign Key]
• This campaign cannot be edited

Campaign Name (required for creating)

The name of your campaign must be unique.

Potential errors

• [Campaign Name] cannot be longer than 250 characters
• [Campaign Name] is required
• This [Campaign Name] already exists

Budget Type (creating only)

Controls whether your budget is one-time or monthly.

• Default value: [Lifetime]
• Accepted values:
  
  • [Lifetime] to set a one-time budget for the entire campaign
  • [Monthly] to set a recurring budget that renews every month

Potential errors

• Invalid [Budget Type], please input one of [Lifetime] or [Monthly]
• The [Budget Type] for [Scheduled Interviews] campaigns must be [Lifetime]

Budget Amount (required for creating)

The budget amount must be a whole number. It will set either the one-time budget or the monthly budget, depending on the budget type.

Potential errors

• Invalid [Budget Amount], please input a positive number
• [Budget Amount] is required when creating a campaign
• Enter a valid [Budget Amount]
• The [Budget Amount] must be greater than {0} (currency-dependent limit)

Jobs Query

Targets specific jobs within a campaign.

• Leave empty to sponsor all jobs for the selected source
• The % character is not supported

Potential errors

• [Jobs Query] exceeded maximum query length 65535 characters
• Invalid [Jobs Query] (ensure no invalid characters are used)
• The supplied [Jobs Query] surpasses the 20 jobs limit for [Scheduled Interviews] campaigns

Prorate First Month (creating only, partially required)

Determines whether to prorate the first month's budget.

• Required if [Budget Type] is [Monthly]
• Accepted values: [Yes], [No]

Potential errors

• Invalid [Prorate First Month], please input one of [Yes] or [No]
• [Prorate First Month] is required when [Budget Type] is [Monthly]
• [Prorate First Month] is only valid when [Budget Type] is [Monthly]

Start Date and Time

Controls when the campaign begins.

• Leave empty or use [NOW] to start immediately
• Time is based on Central Standard Time (CST), regardless of your local time zone

Accepted formats

• yyyy-MM-dd
• MM/dd/yyyy
• MM-dd-yyyy
• yyyy-MM-dd hh:mm (to include a start time)

Potential errors

• Invalid [Start Date], please input a valid date or NOW
• [Start Date] cannot be earlier than now
• [Start Date] cannot be later than [End Date]
• [Start Date] cannot be edited after the campaign starts spending

End Date and Time (partially required)

Controls when the campaign stops spending.

• Required if [Budget Type] is [Lifetime]
• Must be later than the start date
• Time is based on Central Standard Time (CST), regardless of your local time zone

Accepted formats

• yyyy-MM-dd
• MM/dd/yyyy
• MM-dd-yyyy
• yyyy-MM-dd hh:mm (to include an end time)

Special value (editing only)

• Use [REMOVE] to clear the end date (if applicable)

Potential errors

• Invalid [End Date], please input a valid date or REMOVE
• [End Date] cannot be earlier than now
• [End Date] is required when [Budget Type] is [Lifetime]
• Cannot set [End Date] to [REMOVE] if no end date exists

Paused

Controls whether the campaign starts active or paused.

• Default value:
  
  • [Yes] for Scheduled Interview campaigns
  • [No] for all others
• Accepted values: [Yes], [No]

Potential errors

• Invalid [Paused], please input one of [Yes] or [No]

Additional Ads Reach (creating only)

Use Additional Ads Reach to turn on the Trusted Media Network (TMN). Indeed and Glassdoor are enabled by default; TMN adds more sites to your reach.

• Default value: [No]
• Accepted values: [Yes], [No]

Potential errors

• Invalid [Additional Ads Reach], please input one of [Yes] or [No]

Tracking Token

A custom tracking string for your campaign.

Special value (editing only)

• Use [REMOVE] to clear the value

Potential errors

• [Tracking Token] exceeded maximum character length 255