Using the spreadsheet template

Step 1: Download the spreadsheet template

• Log in to your account, go to Ads, and click Bulk import third party ads.
• Click on the link to download the spreadsheet template, or use this direct link.

Step 2: Save the details of your 3rd tags in this spreadsheet

• Open the spreadsheet
• There will be four columns:
  • Ad Name
    Write the name of the ads. For example: "BRAND_NEWCAR_SUMMER2024_DISPLAY_VROUW_320x400".
    
    
  • 3rd Party Tag
    A 3rd party tag or 'ad placement tag' is a snippet of Javascript or HTML code which is generated from a 3rd party ad server. As these tags are being served from another platform, macros should be added. This way information can be provided to the 3rd party which is available only in Ad Manager. Most importantly though, Ad Manager needs it in order to measure clicks correctly.
    
    Ad Manager supports a few HTML tag formats: <SCRIPT>, <IMG> and <INS>
    
    

    Macro	Description
    ${CLICK_URL}	Enables Ad Manager to measure clicks.
    ${CLICK_URL_ENC}	Also used to measure clicks. Only use when instructed to do so.
    ${CACHEBUSTER}	Macro will be replaced by a random number to prevent discrepancies caused by caching.
    ${GDPR}	Will be replaced by a 1 (when traffic is from a GDPR region) or a 0.
    ${GDPR_CONSENT_XXXX}	Contains the IAB TCF consent string where XXXX should be changed to the vendor ID of the vendor receiving the consent information. As an example, the ID of Google (for GCM 360 tags) is 755.
    ${ADDTL_CONSENT}	Will be replaced by the user-consented Google Ad Tech Provider (ATP) IDs.

    
    Example of a tag
    

    <ins class='dcmads' style='display:inline-block;width:300px;height:250px'
      data-dcm-placement='N7480.1664088DOUBLECLICK.NETTEST/B8299600.114131924'
      data-dcm-rendering-mode='script'
      data-dcm-https-only
      data-dcm-api-frameworks='[APIFRAMEWORKS]'
      data-dcm-omid-partner='[OMIDPARTNER]'
      data-dcm-gdpr-applies='gdpr=${GDPR}'
      data-dcm-gdpr-consent='gdpr_consent=${GDPR_CONSENT_755}'
      data-dcm-addtl-consent='addtl_consent=${ADDTL_CONSENT}'
      data-dcm-ltd='false'
      data-dcm-resettable-device-id=''
      data-dcm-app-id=''
      data-dcm-click-tracker='${CLICK_URL}'>
      <script src='https://www.googletagservices.com/dcm/dcmads.js'></script>
    </ins>

    
    
  • Dimensions
    Enter the size of the in the "###x###" format. For example 300x250.
    
    
  • Trackers (optional)
    Enter a third party tracking pixel using HTML code or a URL linking to an image. 
    So you can add a URL to your tracking pixel: https://link_to_my_tracker.com?id=123
    Or use HTML code to link to your image tracker or JavaScript tag.

    <img src="https://link_to_my_tracker.com?id=123" width=1 height=1 />

See here a list of supported vendors.