Uploading Advertising Creatives with an Excel File

  • Updated

When you reach Step 5: Creatives of the Campaign Builder in self-serve Advertising as documented in Upload Display Creative, you can upload creatives and landing page URLs for the campaign.

Tip: Uploading creatives and landing page information with Excel (or CSV) documents is the safest, most reliable way to associate creatives with your Demandbase campaigns.

Demandbase understands that most of our Advertising campaign managers receive creatives and landing pages URLs in the form of a spreadsheet. By importing a properly configured spreadsheet, you don’t run the risk of introducing errors by copying and pasting landing page URLs incorrectly.

The creative upload wizard in the Campaign Builder is designed to parse most spreadsheets supplied by ad agencies or other third parties. The parser uses fuzzy matching to find column titles like Creative Name, Click URL or Landing Page, and (optionally) Tracking Pixel. The column titles don’t even need to populate row 1 of the spreadsheet because we’ve learned that many agencies include title and purchase order information in the top few rows.

You can upload your own Excel files or use a Demandbase template for the spreadsheet. Both routes, with variations based on creative file host location, are documented below.

 

USING YOUR SPREADSHEET WITH THE UPLOAD WIZARD

If you already have ad assets in spreadsheets, drag and drop them when prompted in Step 5 of the Campaign Builder. The upload wizard scans your spreadsheet to identify whether certain elements in the form of spreadsheet columns are in your submission. What exactly the wizard looks for depends on where your creatives are located.

UPLOADING AD FILES FOR DEMANDBASE-HOSTED CREATIVES

If Demandbase will host your creatives, make sure to upload the Excel spreadsheet and all creative files. Drag and drop the files into the upload field all at once. After you click Upload, the parser will cross-reference the Excel file against the creatives, and make sure there’s data for all of them. If the parser identifies more or fewer creatives than are listed in the spreadsheet, it will show you an error with an explanation.

The upload wizard scans your submission for the following columns when you plan to have your creatives hosted by Demandbase: 

  • Creative Name: This is the file name of the creative that you’re uploading. Make sure the extension (for example, .png) is included in the file name. (These terms will also work for this column: File Name, Placement Name, and Ad Name.)
  • Landing Page: The URL, including any UTM parameters, that the user is taken to when they click on this creative. (These terms will also work for this column: Click URL and UTM.)
  • Impression Tag (optional): If you’re using an impression tag, include it in this column. (Impression Tracker is also a permissible label for this column.)
  • Click Tracker (optional): If you’re using a click tracker, include it in this column. (Alternatively, you can have a column labeled Click and another one labeled Tag.)
  • DVTag (optional): If you’re using a DVTag, include it in this column. (The term JavaScript will also work for this column.)

UPLOADING AN EXCEL FILE FOR ADS HOSTED OUTSIDE OF DEMANDBASE

If your creatives are hosted outside of Demandbase, drag only the Excel file into the upload field when prompted. The creative upload wizard will associate the URLs with the landing pages and trackers provided in the spreadsheet.

The upload wizard scans your submission for the following columns when creatives will be hosted on a non-Demandbase server:

  • URL: This is the URL where the creative is located.
  • Creative Name: This is the file name of the creative that you’re uploading. This column will determine the name displayed in the product for this creative. (These terms will also work for this column: Name, Placement Name, and Ad Name.) 
  • Landing Page: The URL, including any UTM parameters, that the user is taken to when they click on this creative. (These terms will also work for this column: Click URL and UTM.)
  • Impression Tag (optional): If you’re using an impression tag, include it in this column. (Impression Tracker is also a permissible label for this column.)
  • Click Tracker (optional): If you’re using a click tracker, include it in this column. (Alternatively, you can have a column labeled Click and another one labeled Tag.)
  • DVTag (optional): If you’re using a DVTag, include it in this column. (The term JavaScript will also work for this column.)

USING A DEMANDBASE TEMPLATE TO UPLOAD CREATIVES

If you don’t already have a spreadsheet containing your creatives information, you can use one of the template files attached to the end of this article. The template file name indicates for which hosting environment the file is suitable. Using a spreadsheet to upload is more reliable than manual entry of the asset information in the upload wizard because:

  • You can double-check your work before uploading. 
  • You will have a copy of what you uploaded to troubleshoot.
  • You don’t risk the chance of accidentally closing the modal in the middle of copy and pasting in all the landing pages.

Dynamically Personalized Creatives

If you have Advertising Campaign Strategist (ACS) support with your Demandbase implementation, an ACS can partner with you to build creatives for personalized, dynamic ads.

If your company has self-serve Advertising, after you review and approve the creative for a personalized ad, coordinate with your Customer Success Manager (CSM) as to how the creative should be submitted to Demandbase for launch. You can submit the creative for launch in Step 5 of the Campaign Builder by filling out and uploading the Creatives Hosted by Third Party.xlsx file at the end of this article. Or our CSM might decide that it’s more feasible for Demandbase to upload the ad assets for you.

 

Was this article helpful?

0 out of 1 found this helpful