Excel Templates for Bulk Uploading Ads

You can use an Excel file (XLSX) to quickly upload ads in bulk. For image and native ads, include the XLSX file in a ZIP file along with your creatives. The information in the spreadsheet automatically populates the ads' property info. If you do not include an Excel, you have to enter each ad's details manually. For ad tags from ad servers other than Sizmek or Google Campaign Manager, you can use our Excel template instead of uploading each tag individually.

Blank template files are available for download in the Bulk Upload Image Ads, Bulk Upload Native Ads, and Bulk Upload Ad Tags windows.

General Formatting Details

  • The name of the Excel file is arbitrary.
  • The number of rows must match the number of creatives in the ZIP (one row per ad).
  • Image file names must match the names of your creative files exactly, including extensions (e.g. banner_ad_200x600.jpg, banner_ad_200x600.png).
  • You can include standard Basis DSP macros in the destination URLs and impression tracking URLs.

Headers for Image Ads

  • Ad Name
  • Image Filename
  • Destination Click URL
  • Impression Tracking URL

BulkUploadAd_Excel.png

Headers for Native Ads

  • Ad Name
  • Image Filename
  • Logo/Icon Filename
  • Brand Name
  • Headline
  • Body
  • Destination Click URL
  • Impression Tracking URL

BulkNativeAd_Excel.png

Note: If you have multiple impression tracking URLs, include additional headers as required: Impression Tracking URL 2, Impression Tracking URL 3, Impression Tracking URL Script 1, Impression Tracking URL Script 2, Impression Tracking URL Script 3.

Headers for Ad Tags

  • Name
  • Dimensions
  • Tag Code

BulkAdTag_exceltemplate.png

Additional Formatting Details for Ad Tag Files

  • Dimensions must use the following format: WIDTHxHEIGHT (in pixels)
  • The listed dimensions must be dimensions that Basis DSP supports. See Ad Specifications for more information.
  • An empty cell in a row that otherwise contains data will cause the upload to fail. Make sure to include all required information.
Was this article helpful?
0 out of 0 found this helpful