Upload custom dimensions using bulksheets

After your custom dimensions tables are defined, you can use a bulksheet to add a new custom dimension or edit an existing custom dimension. The overall process for adding or editing custom dimensions is as follows:

1. Download an editable bulksheet that contains custom dimensions tables.
2. In the downloaded bulksheet, add or edit custom dimensions.
3. Upload the bulksheet.

Download a bulksheet with custom dimension tables

New Search Ads 360 displays the Manager account page, which contains data for all of the client accounts

1. Sign in to your Search Ads 360 experience.
2. Navigate to the required sub-manager account.
3. On the Navigation menu, click Tools and settings icon .
4. Under “Setup” , click Custom dimensions.
5. Click the custom dimensions you want to download.
6. Click the download icon , which appears above the reporting table.
7. Select a file type from the list.

Search Ads 360 generates the report and either downloads the file to your browser's download directory or sends an email, depending on the delivery option you selected.

The downloaded bulksheet contains the following for each custom dimensions table you selected on the Search Ads 360 download page:

• One bulksheet column for each custom dimensions column.
• All of the rows that have already been defined for the custom dimensions tables. If all of the tables you selected are empty, there will be one empty row.

Bulk upload new values for existing custom dimensions

First, download and edit the template file for your custom dimension:

1. Sign in to your Search Ads 360 experience.
2. On the toolbar, click Tools and settings.
3. Under "Setup" click Custom dimensions to open the custom-dimensions table.
4. Click the custom dimension you want to add new values to.
   
   For example, if you have the custom dimension "City", you can add values for more city names.
   
   Or if you've added the secondary dimension "Airport" via the UI, you might want to add values for "Airport" (e.g., LAX, SFO).
5. At the top right of the table, click Download and choose the format for the downloaded file.
   
   For example, if you're adding values to the "City" custom dimension and you choose .xlxs as the download format, you get a file similar to the following:
    

   Row Type	Action	City	Airport	Customer ID
   Custom dimension	Edit	Los Angeles	--	0123456789
   Custom dimension	Edit	San Francisco	--	0123456789
   Custom dimension	Edit	London	--	0123456789
   Custom dimension	Edit	Paris	--	0123456789

6. Edit the downloaded files as necessary.
   
   For example, if you wanted to add values for the "Airport" secondary dimension, your edited file would look something like:
    

   Row Type	Action	City	Airport	Customer ID
   Custom dimension	Edit	Los Angeles	LAX	0123456789
   Custom dimension	Edit	San Francisco	SFO	0123456789
   Custom dimension	Edit	London	LHR	0123456789
   Custom dimension	Edit	Paris	CDG	0123456789

7. If you wanted to add additional cities and airports, your edited file would look something like:
    

   Row Type	Action	City	Airport	Customer ID
   Custom dimension	Edit	Los Angeles	LAX	0123456789
   Custom dimension	Edit	San Francisco	SFO	0123456789
   Custom dimension	Edit	London	LHR	0123456789
   Custom dimension	Edit	Paris	CDG	0123456789
   Custom dimension	Create	Berlin	BER	0123456789
   Custom dimension	Create	Lisbon	LIB	0123456789

When you've finished editing the template file you downloaded, upload it to make the edits to your custom dimension.

1. Sign in to your Search Ads 360 experience.
2. On the toolbar, click Tools and settings.
3. Under "Setup," click Custom dimensions to open the custom-dimensions table.
4. Click the custom dimension you want to upload new values to.
5. In the top-right corner of the table, click More > Upload.
6. For "Select source", select the template file you edited.
7. Select whether you want to apply the changes to Multiple accounts or a Single account. If you choose "Single account", click Select an account, and click the account you want.
8. Click Apply.

Use bulk upload to update multiple campaigns with new custom dimension values

1. Sign in to your Search Ads 360 experience.
2. On the toolbar, click Tools and settings.
3. Under "Setup," click Custom dimensions.
4. Click .
5. Add a name and description for your custom dimension.
6. If you are scoped to a sub-manager account, select an owner account.
7. Click Save and continue.
8. Click campaigns.csv to download your campaigns. Leave the Search Ads UI open to this page.
9. Use a text editor or spreadsheet application to edit the .csv file you downloaded. Enter a dimension value for each campaign that you want to update in your account.
10. Navigate back to Search Ads 360, and click Continue.
11. To upload the edited file, click Choose file.
12. Click Save.

Alternatively, after Step 9, you can upload the file by the following method:

1. Click Bulk actions > Uploads.
2. Click .
3. For "Select source", select the file you downloaded and edited.
4. For "What are you uploading", select Changes to your accounts.
5. Select whether you want to apply the changes to Multiple accounts or a Single account. If you choose Single account, click Select an account, and click the account you want.
6. Click Apply.

Removing custom dimensions not supported

After you add and upload a row to a custom dimensions table, you can’t remove it. Instead, you can detach the custom dimensions from items in Search Ads 360, and the data will no longer be used.