Add or edit price extensions in bulk

Price extensions showcase a range of your products or services with your ad. If you use many price extensions, save yourself time by adding and uploading them in bulk.

Before you begin

This article describes how to use a spreadsheet to add price extensions in bulk, and how to use the Edit menu in your Google Ads account to make bulk changes. To learn more about price extensions, start with About price extensions. For instructions on how to add just a few price extensions, go to Use price extensions.

You can also upload price extensions in bulk for other languages. See the translated names and appropriate codes to Add price extensions in bulk (in non-English languages).

How to add price extensions in bulk with a spreadsheet

1. Download the spreadsheet template

  1. Sign in to your Google Ads account.
  2. Click Ads & extensions in the page menu on the left, then click Extensions at the top of the page.
  3. In the top right-hand corner, click the 3-dot icon 3 dot icon
  4. Click Upload.
  5. Click View templates in the new window that appears to select the spreadsheet format that you want to download.

2. Make changes to the spreadsheet

You can add campaign and ad group names where you want to add the extension.

Campaign (required). Enter your campaign name under the “Campaign” field in order to associate your price extensions with this campaign. To associate your price extension with multiple campaigns, create several rows with the same content except for the name of the campaign (do not provide multiple campaign names in one row).

Ad group (optional). Enter your ad group name under the “Ad group” field in order to associate your price extensions with this ad group. Note that a campaign name is required if you choose to associate your price extension with an ad group. The ad group must be part of the campaign you choose. To associate your price extension with multiple ad groups, create several rows with the same content except for the name of the ad group (do not provide multiple ad group names in one row).

Language (required). Make sure that the “Language” column of your spreadsheet is set to a “value”-type column. Enter en for English.

Type (required). Enter one of the following price extension types:

  • Brands
  • Events
  • Locations
  • Neighbourhoods
  • Product categories
  • Product tiers
  • Service categories
  • Service tiers
  • Services

Price qualifier (optional). Leave this option empty if you don’t want to show a price qualifier. Otherwise, enter one of the following

  • From
  • Up to
  • Average

Tracking template (optional). Leave this option empty if you don’t want to show a tracking template. Insert your tracking template URL.

Specific information for each price extension item you want to showcase (required). Enter the following:

  • Item header
  • Item final URL
  • Item description
  • Item price – enter a number with two decimal points + ISO 4217 currency code (for instance, 34.99 USD). If the selected language uses a comma instead of a period to indicate decimal points, use a comma instead (for example, 34,99 EUR).

Final mobile URL (optional).

Item unit (optional). Leave this option empty if you don’t want to show a price unit. Otherwise, enter one of the following:

  • per hour
  • per day
  • per night
  • per week
  • per month
  • per year

For information about further optional columns to specify scheduling and date ranges, see Make changes with bulk uploads. Bear in mind that device preference isn’t available for price extensions.

Note: If you want to add the extension at campaign level, leave the ad group column blank. If you want to add the extension to account level, leave campaign and ad group columns blank.

3. Upload your spreadsheet to apply and save your changes

  1. Sign in to your Google Ads account.
  2. Click Ads & extensions in the page menu on the left, then click Extensions at the top of the page.
  3. In the top right-hand corner, click the 3-dot icon 3 dot icon
  4. Click Upload.
  5. Click View templates in the dialogue box that opens to select the spreadsheet format that you want to download.
  6. Select source from the drop-down menu. Click Preview changes to make sure that the changes in your spreadsheet are accurately reflected in your account.
  7. If the preview of your changes looks good, click Apply.

How to edit price extensions in bulk within your account

  1. Sign in to your Google Ads account.
  2. Click the tools icon in the top right-hand side of your account.
  3. Click Business Data under Setup and click the Price Extension Feed that you want to edit.
  4. Click the columns icon Columns then choose Modify columns.
  5. Expand the Attributes option and tick 'Item ID' (this is required to make an edit).
  6. Click Apply.
  7. Download the report.
  8. Refer to the following steps from the 'Edit your data with a spreadsheet' section in the article about Keep your business data updated.

  9. Add an additional 'Action' column on this report (values under this column should be 'Set' to update and 'Remove' to remove an item).
  10. Remove columns like 'Item status', 'Status', 'Clicks', 'Impr.' and 'Cost' from the spreadsheet.
  11. Upload the spreadsheet after making edits to the extensions that you want by clicking three dots.

Best practices

Bear in mind that some limits do apply to your Google Ads account. If you use a lot of extensions or feeds, follow the best practice of removing or replacing items that no longer apply. Learn more about your Google Ads accounts limits.

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue