How Do I Bulk Upload Ad Creatives via FTP into XPO

Updated October 08, 2024 20:54

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

When you want to bulk upload several files and records to XPO, using FTP allows for unlimited file uploads. In contrast, using XPO allows for a maximum limit of 10,000 records (1 record = 1 ad) for bulk uploads using a CSV file.

Instructions to bulk upload creatives:

Prerequisites

1. From the Menu: Account > Manage Account, you will be directed to the admin console.
2. From the admin console, go to the menu and select Configuration > Partner Settings.
3. Scroll to the general settings section. Under XPO Services > FTP Setup option, click on Send Account Credentials.
4. An email containing your credentials (host, port, username, and password) will be sent to the specified Partner Admin's email ID.
5. Once you receive the credentials, use any FTP software (such as FileZilla ) to verify and process your uploads. These credentials work across all your Accounts under this Partner.
6. If you are using FileZilla, select the File then Site Manager, and enter the credentials provided in from step 4.
7. Click Connect.
8. Once the connection is successful, you will be directed to the root (/) directory that contains a list of folders.
9. This is where you can add/remove multiple creatives on the FTP, adhering to the respective creative template requirements. Select the appropriate folder for your creative channel, such as Search Creative, Display Creative, or Meta Ads Creative.
10. Once your files are uploaded, they will be placed in a queue for processing. An email notification will then be sent to your account when all records have been fully processed.
11. You will now be able to view your creatives under the account's creative dashboard and link them to your Search/Display/Meta Ads campaigns.

(A) Search Creative Template

For Search ad creative specifications, you can refer to this article.
The below details must be entered 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 At least 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	Both fields are mandatory 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	Enter 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 character limits, 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 character limits, 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, enter the required fields
MOBILE_OS (operating system) PACKAGE_NAME APP_LINK_TEXT	For your app extensions, the supported mobile OS types are Android and iOS Enter the app package name and app link text
PHONE_NUMBER COUNTRY_CODE USE_CALL_FORWARDING IS_CALL_ONLY	For your call extensions, enter the phone number and country code Supported values for call forwarding and call only options: "Yes" or "No"
DEVICE_PREFERENCE START_DATE END_DATE SCHEDULING	Supported values for device preferences: "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 local (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 Enter the header name 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 Enter 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 entered 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 At least 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	Both fields are mandatory Enter 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 entered, it will imply "start immediately" If the value entered is a number, it will imply the Epoch UNIX timestamp (in milliseconds) If the value entered 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 entered, it will imply "indefinite" If the value entered is a number, it will imply the Epoch UNIX timestamp (in milliseconds) If the value entered 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 indicates the location where the FTP server can retrieve the image file If this column is left blank, Knorex will reference the path from the column IMAGE URL (in case the creatives are stored somewhere else)
IMAGE_URL	Refers to the URL where Knorex can retrieve the image creatives
HTML5_FTP_PATH	For your Display HTML5 type creatives, the HTML5 FTP Path field indicates the location where the FTP server can retrieve the file If this column is left blank, Knorex will reference the path from the column HTML5 URL (in case the files are stored somewhere else)
HTML5_URL	Refers to the URL where Knorex can retrieve HTML5 .zip file

(C) Display Creative Template (Feeds/Curator)

Coming soon.

(D) Meta Ads Creative Template

For Meta Ads creative specifications, you can refer to this article.
The supported formats include; Single Image, Carousel, and Video.
The below details must be entered 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 At least one of the above columns must have a valid value
META_ACCOUNT_ID	This refers to your Meta Account ID and is a mandatory field
CAMPAIGN_NAME AD_GROUP_NAME	This is used for linking the Meta Ads creative after being created
AD_NAME AD_TYPE	Both fields are mandatory The name of the Meta Ads 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 Meta Ads 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 Meta Ads 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 Meta Ads 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 Meta Ads single image type creatives, the Image FTP Path field refers to where the FTP server can retrieve the image file from For your Meta Ads 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