Use a bulksheet to set ad display URL option in pharmaceutical ads

Google Ads pharmaceutical advertisers only

Change the ad display URL setting in multiple Google Ads campaigns by uploading a bulksheet.

You can use a bulksheet to create or edit manually created search campaigns and specify the ad display URL option.

The overall process for uploading a bulksheet is as follows:

Download an editable bulksheet that contains the Google Ads campaigns that you want to update.
In the downloaded bulksheet, edit the applicable columns in the campaign rows.
Upload the bulksheet.

Download an editable bulksheet

Navigate to a sub-manager account or a Google Ads client account.
Click Campaigns.
To identify the campaigns that you want to update in the bulksheet, select the checkboxes next to the campaigns or filter the table.
Click the download icon , which appears above the reporting table. The following default selections are shown in the download panel:
- Scope: Current selection in table or Current scope
- Columns: Editable columns (for re-upload)
- Include types: Campaigns
- Filters: Include rows with no impressions
You can specify or change the selections, but don't change the Editable columns (for re-upload) and Campaigns options.
Click Download.

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.

If you selected to download a report and the report is very large, it may take a while for Search Ads 360 to generate the report. You can still use Search Ads 360 while the report is generating. A status bar indicates the progress of the report generation. When it's complete, a Download link appears in the status bar. Click the link to download the report.

Set the ad display URL option using a bulksheet

In the downloaded bulksheet, edit the applicable columns specify or change a campaign's ad display URL option.

In the downloaded bulksheet, in a campaign row, specify settings in one or both of the following columns:
- Display URL option. Specify Ad Display URL or Website Description
- Website description. Sets the description phrase that appears in your ads if you specify Website Description in the Display URL option column.
Optional: Specify other settings for the campaign.
Upload the bulksheet.

Ad display URL column settings

Column name	Description
Row Type	Enter `campaign`. Specifies the type of item that you're creating or editing.
Action	Enter `add` to create a new manually created search campaign. Enter `edit` to edit a campaign's settings. Enter `remove` to remove a campaign.
Campaign	Enter the name of a campaign.
Display URL option	Specifies the ad display URL setting in a campaign. Enter one of the following options in the column: Ad Display URL Website Description. If you specify this option, you are required to enter one of the 12 pre-defined phrases in the Website description column.
Website description	This column should be blank if Ad Display URL is specified in the Display URL option column. (When editing, enter “remove_value” to remove any website descriptions if the campaign is using “Ad Display URL” as the Display URL option.) If the Display URL option column contains Website Description, enter one of the pre-defined options in this (Website description) column: Prescription treatment website Prescription treatment website (Spanish) Prescription device website Prescription device website (Spanish) Medical device website Medical device website (Spanish) Preventative treatment website Preventative treatment website (Spanish) Prescription contraception website Prescription contraception website (Spanish) Prescription vaccine website Prescription vaccine website (Spanish) Prescription product website Prescription product website (Spanish)

Example

Row Type	Action	Campaign	Display URL option	Website description
campaign	edit	Campaign_AdURL	Ad Display URL
campaign	edit	CampaignPhrase	Website Description	Sitio de tratamientos con receta

Was this helpful?

How can we improve it?