How Do I Bulk Upload Ad Creatives via FTP into XPO?

Article author
The Editor
  • Updated

File Transfer Protocol (FTP)   is a widely used network protocol for transferring files between computers. 

When you want to bulk upload many files and records to XPO, using FTP, there is no restriction on the number of files that you can upload whereas there is a maximum 10,000 records limit that you can bulk upload using CSV file if you were using XPO dashboard. (NOTE: 1 record/row is used to represent 1 ad).

 

Instructions to bulk upload creatives:

Pre-Requisites

    1. From the Menu: Account > Manage Account, you'll be directed to the admin console.
    2. On the admin console from the menu: Configuration > Partner Settings.
    3. Scroll to the general settings page, under XPO Services  >  FTP Setup option, click on Send Account Credentials
    4. An email with the credentials (host, port, username, and password) will be sent to the specified Partner Admin's email id.
    5. Once you have received the credentials, use any FTP software (such as FileZilla ) to verify and process your uploads. The credentials are used across all your Accounts under this Partner.
    6.  If you're using FileZilla, once you download it, select the File then Site Manager, and finally key in the credentials given to you from step 1.
    7. Click Connect.

    8. Once the connection is successful, you will be at the root (/) directory with a list of folders.
    9. This is where you can add/remove multiple creatives on the FTP via the respective creative template requirements (explained in detail later). Select the folder for your creative channel, i.e. Search Creative, Display Creative, and/or Facebook Creative.  

    10. Once your files are uploaded, they will be queued for processing and an email will be sent to your account when all the records are fully processed.
    11. You will now be able to view your creatives under the account creative dashboard and link them to your Search/Display/Facebook campaigns.

     

  1. (A) Search Creative Template

    Template Column Name Description 

    PARTNER_INTERNAL_ID

    ACCOUNT_ID

    ACCOUNT_NAME

    • The partner internal ID, is used by Knorex for internal mapping to the Account ID
    • Knorex Account ID
    • Knorex Account Name
    • One of the above columns must have a valid value

    CUSTOMER_ID
    • Mandatory field
    • The customer ID of AdWords Account


    CAMPAIGN_NAME

    AD_GROUP_NAME

     

    • This is used for linking the Search Ad/Extension after being created

    AD/EXTENSION_NAME

    AD_TYPE

    • These two are mandatory fields
    • Ad/Extension type. Supported values:
      • EXPANDED TEXT AD
      • RESPONSIVE SEARCH AD
      • SITELINK EXTENSION
      • CALL EXTENSION
      • CALLOUT EXTENSION
      • APP EXTENSION
      • STRUCTURED SNIPPET EXTENSION
      • PRICE EXTENSION


    FINAL_URL

    FINAL_URL_SUFFIX

    MOBILE_FINAL_URL

    PATH_1

    PATH_2

    TRACKING_TEMPLATE

    CUSTOM_PARAMETER

    • Key in these fields according to your creative ad type requirements


    HEADLINE_[N]

    HEADLINE_[N]_POSITION (Responsive Search Ads)

    • Depending on your ad type and the maximum number of characters, fill in your headlines and the corresponding positions
    • [N] Refers to expanded text ad values that range from 1-3
    • [N] Refers to responsive Search ad values that range from 1-15 with position values 1-15

    DESCRIPTION_[N]

    DESCRIPTION_[N]_POSITION (Responsive Search Ads)

    • Depending on your ad type and its maximum number of characters, fill in your descriptions and the corresponding positions
    • [N] Refers to expanded text ad values that range from 1-2
    • [N] Refers to responsive Search ad values that range from 1-4 with description position values 1-4
    • [N] Refers to sitelink extension creative values that range from 1-2


    SITELINK_TEXT

    CALLOUT_TEXT

    • For your sitelink and/or callout extension ads, key in the respective fields


    MOBILE_OS (operating system)

    PACKAGE_NAME

    APP_LINK_TEXT

     

    • For your app extensions, the supported mobile OS is Android or iOS
    • Key in the app package name and app link text


    PHONE_NUMBER

    COUNTRY_CODE

    USE_CALL_FORWARDING

    IS_CALL_ONLY

     

    • For your call extensions, key in the phone number and country code
    • Supported values for call forwarding and call only options is; yes or no

     

    DEVICE_PREFERENCE

    START_DATE

    END_DATE

    SCHEDULING

     

    • Supported values for device preferences are; all or mobile
    • Start and end date format; MM/DD/YYYY
    • Scheduling format; full-text day-of-week, 2-digit hour:2-digit minute, followed by AM/PM)
      Multiple scheduling are separated by ''; '', for example, Monday, 09:00 AM - 05:00 PM; Tuesday, 09:00 AM - 05:00 PM

    LOCALE

    STRUCTURED_SNIPPIT_ HEADER

    STRUCTURED_SNIPPIT_VALUES

    • For your structured snippet extensions, the supported locale (language) codes/values are; ar, bg, ca, cs, da, de, el, en-GB, es, es-419, et, fi, fil, fr, hi, hr, hu, id, it, iw, ja, ko, lt, lv, ms, nl, no, pl, pt-BR, pt-PT, ro, ru, sk, sl, sr, sv, th, tr, uk, vi, zh-CN, zh-HK, zh-TW
    • Key in your field for the header
    • Structured Snippet Values (values are separated by “;”, for example, “Mens;Womens;Kids“)

         

     


    PRICE_EXTENSION_TYPE

    PRICE_QUALIFIER

    CURRENCY

    LANGUAGE

    ITEM_[N]_HEADER

    ITEM_[N]_PRICE

    ITEM_[N]_PRICE_UNIT

    ITEM_[N]_DESCRIPTION

    ITEM_[N]_FINAL_URL

    ITEM_[N]_FINAL_MOBILE_URL

     

    • For price extension types, supported values are; BRANDS, EVENTS, LOCATIONS, NEIGHBORHOODS, PRODUCT_CATEGORIES, PRODUCT_TIERS, SERVICES, SERVICE_CATEGORIES, SERVICE_TIERS
    • Supported values of price qualifier are; NONE, FROM, UP_TO, AVERAGE

    • Supported currency values are; ARS, AUD, BOB, BRL, CAD, CHF, CLP, COP, EUR, GBP, HKD, INR, JPY, MXN, NZD, PEN, PHP, PLN, RUB, SEK, SGD, USD, VEF, ZAR
    • Key in the remaining fields for your price extension 
    • [N] Refers to price extension values that range from 1-5

     

    (B) Display Creative Template (Image & HTML5)

    Template Column Name Description 

     

    PARTNER_INTERNAL_ID

    ACCOUNT_ID

    ACCOUNT_NAME

     

    • The partner internal ID, is used by Knorex for internal mapping to the Account ID
    • Knorex Account ID
    • Knorex Account Name
    • One of the above columns must have a valid value 

     

    CAMPAIGN_NAME

    AD_GROUP_NAME

     

    • This is used for linking the Display ad creative after being created

     

    AD_NAME

    AD_TYPE

     

    • These two are mandatory fields
    • The name of the Display creative 
    • Supported ad types include:

      • IMAGE
      • HTML5

    SIZE

    • Mandatory field
    • Refers to the size of the Display creative, in the format of width x height (eg. 300x250) (NOTE: x is small case)
    OPTIMIZED_FOR
    • Mandatory field
    • Refers to the platform that the Display creative is optimized for. Supported formats include:

      • DESKTOP
      • MOBILE

    DESTINATION_URL

    • Mandatory field
    • Refers to the landing page URL of the Display creative

    START_DATE

    END_DATE

    • Schedule your creatives
    • The start date field of the Display creative refers to:

    • Similar to the start date field, the end time of Display creative refers to:

     

    IMAGE_FTP_PATH

    • For your Display Image type creatives, the Image FTP Path field refers to where the FTP server can retrieve the image file from
    • If this column is left blank, Knorex will read the path from the column IMAGE URL (in case the creatives are stored somewhere else)

    IMAGE_URL

     

    • Refers to the URL from where Knorex can retrieve the image creatives

    HTML5_FTP_PATH
    • For your Display HTML5 type creatives, the HTML5 FTP Path field refers to where the FTP server can retrieve the file from
    • If this column is left blank, Knorex will read the path from the column HTML5 URL (in case the files are stored somewhere else)

    HTML5_URL

     

    • Refers to the URL from where Knorex can retrieve HTML5 .zip file

     

    (C) Display Creative Template (Feeds/Curator)

    Coming soon.

    (D) Facebook Creative Template

    • For Facebook ad creative specifications, you can refer to this article.
    • The supported formats include; Single Image, Carousel, and Video.
    • The below details must be keyed into the template for the FTP upload.
    Template Column Name Description 

     

    PARTNER_INTERNAL_ID

    ACCOUNT_ID

    ACCOUNT_NAME

     

    • The partner internal ID, is used by Knorex for internal mapping to the Account ID
    • Knorex Account ID
    • Knorex Account Name
    • One of the above columns must have a valid value 

    FACEBOOK_ACCOUNT_ID

    • This refers to your Facebook Account ID and is a mandatory field

     

    CAMPAIGN_NAME

    AD_GROUP_NAME

     

    • This is used for linking the Facebook ad creative after being created

     

    AD_NAME

    AD_TYPE

     

    • These two are mandatory fields
    • The name of the Facebook creative 
    • Supported ad types include:

      • CAROUSEL_AD

      • SINGLE_IMAGE_AD

      • VIDEO_AD

     

    PAGE_ID

    INSTAGRAM_ACCOUNT_ID

     

    • The ID of the Facebook page used for the creative
    • The ID of the Instagram account used for the creative. If this column is left blank, an Instagram Account ID, if available, will be automatically used

     

    DESTINATION_URL

    DISPLAYED_DESTINATION_URL

     

    • Refers to the landing page URL of the Facebook creative and the one displayed on the creative


    TEXT

     

    • The text for your single image, carousel, and/or video ad creative

     

    HEADLINE

    DESCRIPTION

     

    • The headline and description for your single image and/or video ad creative

    CALL_TO_ACTION

     

    The call to action(s) supported for a single image, carousel, and/or video Facebook ad creatives include:

    • APPLY_NOW
    • BOOK_TRAVEL
    • BUY_NOW
    • CONTACT_US
    • DOWNLOAD
    • GET_OFFER
    • GET_QUOTE
    • GET_SHOWTIMES
    • INSTALL_APP
    • INSTALL_MOBILE_APP
    • LEARN_MORE
    • LISTEN_MUSIC
    • LISTEN_NOW
    • NO_BUTTON
    • OPEN_LINK
    • ORDER_NOW
    • PLAY_GAME
    • SHOP_NOW
    • SIGN_UP
    • SUBSCRIBE
    • USE_APP
    • USE_MOBILE_APP
    • WATCH_MORE

     

    URL_TAGS

     

    • The values of your URL tag fields for single image, carousel, and/or video Facebook ad creatives
    • This is the string for query parameters at the end of the URL. For example, medium=web&campaign=Knorex&source=ftp

     

    IMAGE_FTP_PATH

    VIDEO_FTP_PATH

     

    • For your Facebook single image type creatives, the Image FTP Path field refers to where the FTP server can retrieve the image file from
    • For your Facebook video type creatives, the video FTP Path field refers to where the FTP server can retrieve the video file from

    IMAGE_URL

    VIDEO_URL

     

    • Refers to the URL from where Knorex can retrieve the single image creatives or video creatives respectively

    CAROUSEL_BEST_PERFORMING
    _CARD_FIRST

     

    • The field for the flag if the Carousel ad shows the best performing card first

    • Supported values: yes, no 

    CAROUSEL_END_WITH_PROFILE
    _CARD 

     

    • The field for the flag if the Carousel ad ends with a profile card

    • Supported values: yes, no

     

    CAROUSEL_CHILD_ATTACHMENT
    _[N]_TYPE

     

    • The type of nth carousel item
    • [N] Refers to carousel ad values that range from 1-10
    • Child attachment refers to the information for each carousel slide

     

    CAROUSEL_CHILD_ATTACHMENT
    _[N]_LINK

     

    • The destination URL of nth carousel item
    • [N] Refers to carousel ad values that range from 1-10

     

    CAROUSEL_CHILD_ATTACHMENT
    _[N]_TEXT

     

    • The text of nth carousel item
    • [N] Refers to carousel ad values that range from 1-10

     

    CAROUSEL_CHILD_ATTACHMENT
    _[N]_HEADLINE

     

    • The headline of nth carousel item
    • [N] Refers to carousel ad values that range from 1-10

     

    CAROUSEL_CHILD_ATTACHMENT
    _[N]_DESCRIPTION

     

    • The description of nth carousel item
    • [N] Refers to carousel ad values that range from 1-10

     

    CAROUSEL_CHILD_ATTACHMENT
    _[N]_IMAGE_FTP_PATH

     

    • The Image FTP Path field refers to where the FTP server can retrieve the image file of the nth carousel item
    • [N] Refers to carousel ad values that range from 1-10

     

    CAROUSEL_CHILD_ATTACHMENT
    _[N]_IMAGE_URL

     

    • Refers to the URL to retrieve the image creative of the nth carousel item
    • [N] Refers to carousel ad values that range from 1-10

     

    CAROUSEL_CHILD_ATTACHMENT
    _[N]_VIDEO_FTP_PATH

     

    • The Video FTP Path field refers to where the FTP server can retrieve the video file of the nth carousel item
    • [N] Refers to carousel ad values that range from 1-10

     

    CAROUSEL_CHILD_ATTACHMENT
    _[N]_VIDEO_URL

     

    • Refers to the URL to retrieve the video creative of the nth carousel item
    • [N] Refers to carousel ad values that range from 1-10

     

    CAROUSEL_CHILD_ATTACHMENT
    _[N]_THUMBNAIL_URL

     

    • Refers to the URL to retrieve the image that will be used as a video thumbnail for the nth carousel item 
    • [N] Refers to carousel ad values that range from 1-10

     

     

    (E) Facebook Creative Template (Feeds/Curator)

    Coming soon.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.

Can't find what you are looking for?

Submit a request