Add and manage inventory rules in a manual campaign

Add inventory rules and ad templates from a bulksheet

Add or edit inventory rules

To add or edit inventory rules in a manual campaign from a bulksheet:

  1. Navigate to an AdWords engine account.
    Steps for navigating to an engine account
    1. In the left navigation pane, click All accounts.
      What if the left navigation pane isn't visible?

    2. Click the navigation bar to display navigation options.

    3. In the Agency list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

    4. In the Advertiser list, click on the advertiser that contains the engine account.

    5. In the Account list, click on the engine account.

    6. Click Apply or press the Enter key.

    DoubleClick Search displays the engine account page.

  2. Download a bulksheet that contains existing inventory rules (even if you haven't created any inventory rules, follow these steps to download a bulksheet that contains the columns and campaign and ad group IDs you'll need to create rules):
    1. Click the Inventory rules tab.
      If the Inventory rules tab doesn't appear, add your Merchant Center account to your DS advertiser.
    2. If you're editing existing rules, optionally use a filter to display only the rules you want to edit.
    3. Click the Download button, which appears above the reporting table and make the following selections in the download panel:
      • Scope: Current selection in table
      • Columns: Editable columns (for re-upload)
      • Include types: Inventory rules
      • Filters: Include rows with no impressions
    4. Click Download to start generating a bulksheet.
      When DS finishes generating the bulksheet, a Download now link appears above the reporting table.
    5. Click Download now.
      Your browser downloads the bulksheet to its download directory.
  3. To edit an existing rule, open the downloaded bulksheet and make changes in any of the rule's columns.
  4. To create a new rule, open the downloaded bulksheet and add a row. Then enter information in the inventory rule columns.
  5. Upload the file back into DS.

Inventory rules columns

Row type:

Enter Inventory ad group rule.

Action:

Enter one of the following:

  • create to create a new rule.
  • edit to edit an existing rule
  • pause to pause an existing rule
  • remove to remove an existing rule

Account, Campaign, Ad group:

Enter the names of the engine account, campaign, and ad group that you want to contain the inventory rule.

Inventory account ID:

For any inventory rule, if the advertiser has more than one inventory account (not common), this column is required. To see how many inventory accounts your advertiser has, and find the Inventory account ID:

  1. Navigate to an advertiser.

    Steps for navigating to an advertiser
    1. Click the navigation bar to display navigation options.

    2. In the Agency list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

    3. In the Advertiser list, click on the advertiser.

    4. Click Apply or press the Enter key.

    DoubleClick Search displays the advertiser page, which contains data for all of the advertiser’s engine accounts.

  2. Click the Inventory management link in the left nav, and then click the Inventory accounts tab.
    The table displays the inventory accounts associated with the advertiser.

  3. Above the table, click the Columns button.
    The column selection tool appears.

  4. In the Available columns list, click Names and attributes.

  5. Select ID and click Apply.
    The ID column in the table will display the Inventory account IDs.

Inventory rule

Enter a name for the rule. You'll use the name to identify the rule in bulksheets and in the DS UI.

Inventory rule type

Defines the action of the rule:

  • KEYWORD_STATE: Pauses all keywords or individual keywords when items go out of stock.
  • KEYWORD_URL: Updates the landing page URL per a field in the inventory account.
  • AD_COPY: Uses ad templates to generate new ad copy when product properties change in the inventory account. Be sure to enter the name of one or more ad templates in Inventory rule assigned templates.

Inventory rule keyword level override

Enter On to apply this rule to specific keywords instead of all keywords in the ad group.

Inventory rule assigned templates

Used with an AD_COPY rule. Enter the name of the ad templates you want the ad copy rule to use. Separate each template name with a vertical bar |.

Inventory rule product map

Defines the products from the inventory feed that the rule uses. This column use a powerful-yet-simple language that is similar to Excel’s.

For example, you might want to pause all Android devices when they run out of stock. You would pause all products where BRAND equals Google and CATEGORY contains one of these strings: tablet, mobile phone, or cell phone.

Therefore, the expression to enter in the Inventory rule product map column would be:

AND(BRAND = "Google", CATEGORY CONTAINS("tablet", "mobile phone", "cell phone"))

Best Practice: To better identify problems, start with product mappings that match only a few products.

Here are the available operations for the Product mapping column.

Operation Description
= Equals
<> Does not equal
< Less than
> Greater than
<= Less than or equal to
>= Greater than or equal to
IN

Requires its values to be within parentheses. IN is like the = (equals) operation expanded to support multiple values. IN will apply to any product whose field (e.g., BRAND) is actually within the provided list. Strings go within quotation marks, while numbers don’t. For example:

  • BRAND IN("Nike", "Reebok")
  • PRICE IN(4.2, 87, 5.4)
CONTAINS

Is in the same format as IN, but only for strings. CONTAINS does a match for multiple values. CONTAINS looks for any product whose field has one of the substrings listed. In the following example, if a product’s category is “Nike Air Jordans”, the fact that “jordan” and “air” are provided means that the product would be selected. For example:

  • CATEGORY CONTAINS("basketball", "jordan", "air")
DOES_NOT_CONTAIN

For example:

  • AND(COLOR DOES_NOT_CONTAIN("App", "Bana", "Can"))
STARTS_WITH

For example:

  • AND(COLOR STARTS_WITH("App", "Bana", "Can"))
HAS_VALUE

For example:

  • AND(COLOR HAS_VALUE())
DOES_NOT_HAVE_VALUE

For example:

  • AND(COLOR DOES_NOT_HAVE_VALUE())
IMPORTANT: Click here to learn about cases that require consistent values for all matched products

The following cases require consistent values for all products that you want a rule to match on.

1. For a "pause keyword" rule, as long as the number of products that can be sold is greater than zero, keywords will be active and ads will show. Once no products are available, DS will pause those keywords. For example, for a "pause keyword" rule that matches on the following products, keywords associated with these products would be paused:

Product name Availability
Wool sweater NOT_AVAILABLE
Cashmere sweater NOT_AVAILABLE
Cotton sweater NOT_AVAILABLE

However, for a "pause keyword" rule that matches on the following products, keywords associated with these products would NOT be paused, because one of them is marked as AVAILABLE:

Product Name Availability
Kenmore Compact Portable Washing Machine NOT_AVAILABLE
Maytag Front Load Steam Washer AVAILABLE
General Electric Stainless Steel Capacity Washer NOT_AVAILABLE

2. Ads that use ad templates will only display correctly if all of the products that govern this ad group have the same value for the field specified in the template. For example, for an "ad copy" rule with template "Buy sweaters for [PRICE]" that matches on the following products, the template would apply to all correctly:

Product Name Price
Wool sweater 39.99
Cashmere sweater 39.99
Cotton sweater 39.99

However, for an "ad copy" rule that matches on the following products, the template would not be able to apply correctly, because one of the prices is 45.00, and not 39.99 like the rest:

Product name Price
Wool sweater 39.99
Cashmere sweater 45.00
Cotton sweater 39.99

Add or edit ad templates

To add or edit ad templates in a manual campaign from a bulksheet:

  1. Navigate to an AdWords engine account.
    Steps for navigating to an engine account
    1. In the left navigation pane, click All accounts.
      What if the left navigation pane isn't visible?

    2. Click the navigation bar to display navigation options.

    3. In the Agency list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

    4. In the Advertiser list, click on the advertiser that contains the engine account.

    5. In the Account list, click on the engine account.

    6. Click Apply or press the Enter key.

    DoubleClick Search displays the engine account page.

  2. Download a bulksheet that contains existing ad templates (even if you haven't created any ad templates, follow these steps to download a bulksheet that contains the columns and engine-account IDs you'll need to create templates):
    1. Click the Ad templates tab.
      If the Ad templates tab doesn't appear, add your Merchant Center account to your DS advertiser.
    2. If you're editing existing templates, optionally use a filter to display only the templates you want to edit.
    3. Click the Download button, which appears above the reporting table and make the following selections in the download panel:
      • Scope: Current selection in table
      • Columns: Editable columns (for re-upload)
      • Include types: Ad templates
      • Filters: Include rows with no impressions
    4. Click Download to start generating a bulksheet.
      When DS finishes generating the bulksheet, a Download now link appears above the reporting table.
    5. Click Download now.
      Your browser downloads the bulksheet to its download directory.
  3. To edit an existing template, open the downloaded bulksheet and make changes in any of the template's columns.
  4. To create a new template, open the downloaded bulksheet and add a row. Then enter information in the ad template columns.
  5. Upload the file back into DS.

Ad template columns

Row type:

Enter Inventory ad template.

Action:

Enter one of the following:

  • create to create a new template.
  • edit to edit an existing template
  • pause to pause an existing template
  • remove to remove an existing template

Account:

Enter the name of the engine account that you want to contain the ad template.

Inventory ad template:

Enter a name for the ad template. You'll use the name to identify the template i bulksheets and in the DS UI.

Inventory ad template ID

DS automatically assigns its own ID to each ad template. If you're creating a new template, leave this column empty. DS overwrites any value in this column with its own ID when it creates a new template.

Inventory ad template title, Inventory ad template line 1, Inventory ad template line 2, Inventory ad template display URL, Inventory ad template ad landing page, Mobile preference

Ad templates have the same properties and requirements as ads in a manual AdWords campaign, including support for text parameters.

You can insert inventory attributes and template functions to update the ad template based on data in your inventory feed.

Was this article helpful?