Advertising Advertising Editor Advertising Intelligence

What can I include in my Merchant Promotion feed file?

Take a look at what the required and optional fields are for your Merchant Promotion feed file.
New to Microsoft Shopping Campaigns? Learn how to get started in this training course.

Your feed file is a text delimited file that contains all the information needed to submit a promotion. For manual uploads, .tsv or .xml file formats are accepted. For FTP uploads (available in the United States only), .tsv, .txt, or .xml file formats are accepted. After you create a feed file, submit it to Microsoft Merchant Center.

Availability: United States, Canada, United Kingdom, Australia, India, France, and Germany on PC and mobile devices.

Here are the required and optional fields you can include in the catalog feed:

Required Fields expando image
Field name Description What you need to know
promotion_id

The unique ID for the promotion.

Example:
50off

Requirements:
Alphanumeric
60-character limit

  • ID must be unique for each promotion.
  • For online promotions that apply to specific products, the promotion_id in the promotions feed must match the promotion_id in the product feed so Microsoft Advertising knows which products apply to the promotion.
  • Spaces or symbols (for example, $ or %) are not allowed.
  • Values must be separated by commas.
product_applicability

Indicates if the promotion is applicable to all products or specific products.

Valid values:
ALL_PRODUCTS
SPECIFIC_PRODUCTS

  • If the promotion is only applicable to specific products, the promotion_id column must be present in the product feeds. This is to ensure that the promotion is mapped to the right products.
  • If the promotion applies to all products, the promotion_id does not need to be added in the products feed.
offer_type

Indicates if there is a code or not.

Valid values:
NO_CODE
GENERIC_CODE

  • This determines if the coupon code is required to redeem the offer.
  • A GENERIC_CODE is a code that is the same for all users.
long_title

The full title of the promotion.

Example:
Extra 50% off shoes

Requirements:
60-character limit

promotion_effective_dates

Date and time that the promotion will be live on Bing.com.

Example:
2016-07-07T01:00:00-08:00/2016-08-07T01:00:00-08:00

Requirements:
Format is Start-Date-Time/End-Date-Time

  • The promotion must be live on your website to be live on Bing.com.
  • Separate the start and end date with a forward slash (/).
  • The start and end date format is: (YYYY-MM-DD), followed by the letter T, then the time of day when the promotion starts, followed by the time zone expression as defined by the ISo 8601 standard. For example:

    If you want your promotion to run from 1:00 p.m. on July 7, 2016, to 1:00 p.m. on August 7, 2016 (Pacific Standard Time), you would submit: 2016_07-07T13:00:00-08:00/2016-08-07T13:00:00-08:00.

    If you want your promotion to run from 1:00 p.m. on July 7, 2016, to 1:00 p.m. on August 7, 2016 (Greenwich Mean Time), you would submit: 2016_07-07T13:00:00-00:00/2016-08-07T13:00:00-00:00.

    If you want your promotion to run from 1:00 p.m. on July 7, 2016, to 1:00 p.m. on August 7, 2016 (Eastern Standard Time), you would submit: 2016_07-07T13:00:00-05:00/2016-08-07T13:00:00-05:00.
redemption_channel

Indicates if the promotion is online.

Valid value:
ONLINE

Optional Fields expando image
Field name Description What you need to know
generic_redemption_code

The text code that customers use online.

Example:
EXTRA50

Requirements:
Alphanumeric
60-character limit

  • This code is provided only when offer_type has a value of GENERIC_CODE.
promotion_display_dates

Date and time that the promotion will be live on Bing.com that falls within the promotion_effective_dates.

Example:
2016-07-07T01:00:00-08:00/2016-08-07T01:00:00-08:00

Requirements:
Format is Start-Date-Time/End-Date-Time

  • This can be used with promotion_effective_date to validate promotions before they are active.
  • Separate the start and end date with a forward slash (/).
  • The start and end date format is: (YYYY-MM-DD), followed by the letter T, then the time of day when the promotion starts, followed by the time zone expression as defined by the ISo 8601 standard. For example:

    If you want your promotion to run from 1:00 p.m. on July 7, 2016, to 1:00 p.m. on August 7, 2016 (Pacific Standard Time), you would submit: 2016_07-07T13:00:00-08:00/2016-08-07T13:00:00-08:00.

    If you want your promotion to run from 1:00 p.m. on July 7, 2016, to 1:00 p.m. on August 7, 2016 (Greenwich Mean Time), you would submit: 2016_07-07T13:00:00-00:00/2016-08-07T13:00:00-00:00.

    If you want your promotion to run from 1:00 p.m. on July 7, 2016, to 1:00 p.m. on August 7, 2016 (Eastern Standard Time), you would submit: 2016_07-07T13:00:00-05:00/2016-08-07T13:00:00-05:00.
minimum_purchase_amount

The minimum amount of purchase for the promotion to be applicable.

Example:
15 USD

Requirements:
Numerical
No symbols (for example, $)

  • Only currencies in the specified country/region are supported.

See more videos...