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

Updated August 18, 2021 04:15

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.

(A) Search Creative Template

For Search ad creative specifications, you can refer to this article.
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
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)

For Display ad creative specifications, you can refer to this article.
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
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: If no date is keyed in, it will imply "start immediately" If the value keyed in is a number, it will imply the Epoch UNIX timestamp (in milliseconds) If the value keyed in is a string, it will imply the ISO 8601 format (eg: 1970-01-01T00:00:00Z) Similar to the start date field, the end time of Display creative refers to: If no date is keyed in, it will imply "indefinite" If the value keyed in is a number, it will imply the Epoch UNIX timestamp (in milliseconds) If the value keyed in is a string, it will imply the ISO 8601 format (eg: 1970-01-01T00:00:00Z)
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 n^thcarousel 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 n^thcarousel item [N] Refers to carousel ad values that range from 1-10
CAROUSEL_CHILD_ATTACHMENT _[N]_TEXT	The text of n^thcarousel item [N] Refers to carousel ad values that range from 1-10
CAROUSEL_CHILD_ATTACHMENT _[N]_HEADLINE	The headline of n^thcarousel item [N] Refers to carousel ad values that range from 1-10
CAROUSEL_CHILD_ATTACHMENT _[N]_DESCRIPTION	The description of n^thcarousel 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 n^thcarousel 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 n^thcarousel 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 n^thcarousel 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 n^thcarousel 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 n^thcarousel item [N] Refers to carousel ad values that range from 1-10