ÃÛ¶¹ÊÓƵ

Tab

Parameter

Description

Selections

SE Accounts

The accounts, campaigns, or ad groups to which to upload the data:

• To select an account and all of its campaigns and ad groups, select the check box next to the account name, and then click >> to move it to the Selected Filters column.
• To select individual campaigns or ad groups, click next to the account to expand it, (if necessary) click next the campaign to expand it, select the check box next to the campaign or ad group name, and then click >> to move it to the Selected Filters column. For example, to get data only for Campaign 1 in Account 1, expand Account 1, select the check box next to Campaign 1, and then move it to the Selected Filters column.

Notes:

• A single bulksheet may apply to multiple accounts within multiple ad networks. Ad network-specific columns are labeled in bulksheets with the ad network name (such as "Mobile Carriers (Google Ads)").
• To see what type of component any item is, hold your cursor over it.
• For campaigns, the first letter of the ad network name is in parentheses after the account name (such as "Acme Realty (G)" for a Google Ads account).
• By default, only active and enabled accounts and their active components are listed. To view paused and deleted components, click next to Show and select **All.

Generate Tracking URLs

(Optional) Includes tracking templates and landing page suffixes (for applicable ad networks) in accounts with tracking templates, or destination URLs with embedded tracking codes in accounts with destination URLs, for keywords, ads, placements, sitelinks, and Google Ads product groups in the bulksheet. By default, this option is selected.

When this option is selected, the URLs are generated according to the parameters in the Campaign Tracking section of the account settings or campaign settings. By default, if tracking URLs already exist, they aren’t regenerated unless new ones are needed (such as if the keyword match type, the ad text, or the account’s tracking parameters have changed).

Notes:

• If the advertiser uses ÃÛ¶¹ÊÓƵ Advertising conversion tracking and the relevant account isn’t configured to automatically generate and upload tracking URLs, then you must generate new tracking URLs when the base URLs have changed.
• If you don’t select this option, you can still generate tracking URLs later when you upload or post the file.

Perform Pre-sync

(Optional) Instructs Search, Social, & Commerce to synchronize its files with the specified campaigns to ensure that all data is the same. By default, this option isn’t selected.
Note: Search, Social, & Commerce automatically synchronizes with the ad network once a day, whenever it detects a new campaign on the ad network, and every time you change campaign data from within Search, Social, & Commerce. Select this option if you think that recent changes to campaign or account data were made directly in the ad network or using the ad network’s desktop editor. Bulksheet creation takes longer when you select this option.

Bulksheet Name

The name of the new bulksheet, and the file type. By default, the file is created in tab-separated values format and is named one of the following:

• (for all accounts for the ad network) <search_engine name>_<creation date in the format MMDDYYYY>.tsv
• (for single accounts) <account name>_<search_engine name>_<creation date in the format MMDDYYYY>.tsv
• (for multiple accounts) MultipleAccounts_<search_engine name>_<creation date in the format MMDDYYYY>.tsv.

You can rename the file. The name can’t include the following characters: `# % & *

Rows and Columns

Bulksheet Rows

The entities, and their corresponding statuses, to include in the bulksheet, with one data row per entry. For example, if you include active campaigns, then the bulksheet includes one row per active campaign. Only selected entities with the selected statuses are included. Defaults are pre-selected based on the specified ad network. By default, only active instances of the selected entities are included. For a list of available bulksheet rows, see "Bulksheet rows by ad network."

To add or remove entities, select or clear the check boxes next to the entities, respectively. To add or remove statuses for an entity, click next to the status menu, and then select or clear the check boxes next to the entities, respectively.

Cascading Status Hierarchy

Filters the scope of child entities to those with the specified parent entity statuses, using an AND operation. For example, if you select “Active Campaign,� “Active Adgroup,� and “Active Keyword,� then the bulksheet includes only active keywords in active ad groups in active campaigns.

If you don’t select this option, then the parent status isn’t considered, and the filter uses an OR operation. For example, if you select “Active Campaign,� “Active Adgroup,� and “Active Keyword,� then the bulksheet includes all active campaigns; all active ad groups, regardless of the parent campaign status; and all active keywords, regardless of the parent campaign and ad group status.

Bulksheet Columns

The columns to include in the downloaded bulksheet file:

• AMO ID: (Required if "SE ID" isn’t selected) Includes an ÃÛ¶¹ÊÓƵ-generated unique identifier for each entity/row. Search, Social, & Commerce uses the value to determine the correct identity to edit but doesn’t post it to the ad network. Later, you can edit data for the entity using the AMO ID as the identifier, rather than the entity ID and parent entity IDs.
• SE ID: (Required if "AMO ID" isn’t selected) Includes the ad network’s unique identifier for each included column and its parent entities. Later, if you edit data for any entity using the SE ID as the identifier, then you must also include rows for the parent entities (including their SE ID values).
• Platform: Includes a Platform column at the beginning of each row to indicate the ad platform (such as "Baidu").
• Acct Name: (Required if "AMO ID" isn’t selected) Includes the ad network account name for each entity/row.
• [Columns to include]: To include all, none, or only selected columns relevant to each selected entity in the Bulksheet Rows section. To see the individual columns relevant to an entity, click next to the entity name. By default, all relevant columns are included for each selected entity row. Deselect the check box next to any entity or next to any individual column to exclude it from the bulksheet.

Tip: Make sure that you include adequate columns to identify the item in each row of the bulksheet file. For example, say you include keyword rows per the Bulksheet Rows selector but you exclude all keyword-related columns. The resulting bulksheet includes one row for each keyword instance. However, since no keyword-related columns are included — not even the AMO ID or SE ID — you can’t identify which keyword instance pertains to a specific row, and you can’t use the bulksheet to update data unless you manually add the appropriate ID column and values.

Filters

Criteria for specific campaigns, ad groups, ads/creatives, keywords, and/or placements to include in the bulksheet:

1. Select a parameter (entity name or ID; or any element of a creative, keyword, or placement), select an operator, and then enter the applicable value.
   For example, to return only ads with "shoes" in the headline for a Google Ads account, select Headline, select contains, and then enter shoes in the input field.
2. (To apply additional filters) For each additional filter, click +Add Filter, select AND or OR, select an ad element or keyword and an operator, and then enter the applicable value.

Bulksheet Row

Baidu

Google Ads

Microsoft Advertising

Naver

Pinterest

Yahoo! Display Network

Yahoo! Japan Ads

Yahoo Native

Yandex

Notes

Campaign

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

—

Adgroup

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

—

Creative or Creative (except RSA)

Yes

Yes

Yes

—

—

Yes

Yes

Yes

Yes

(Google Ads) Use for all ad types except for responsive search ads, which are available in the Responsive Search Ad row.

Responsive Search Ad

—

Yes

Yes

—

—

—

—

—

—

—

Keyword

Yes

Yes

Yes

Yes

Yes

—

Yes

Yes

Yes

Use for non-negative keywords only. To see negative keywords created at the campaign or ad group level, use the Campaign Negative Keyword or Adgroup Negative Keyword row when available.

Promoted Pin

—

—

—

—

Yes

—

—

—

—

—

Placement

—

Yes

—

—

—

—

—

—

—

—

Auto Target

—

Yes

Yes

—

—

—

—

—

—

Use for dynamic search targets for an ad group.

Shopping Product Group

—

Yes

Yes

—

—

—

—

—

—

—

Campaign Site Link

—

Yes

Yes

—

—

—

—

Yes

—

—

Campaign Negative Keyword

Yes

Yes

Yes

—

—

—

Yes

Yes

—

Use for negative keywords created at the campaign or ad group level only. To see non-negative keywords, use the Keyword row when available.

Campaign Negative Website

—

Yes

Yes

—

—

—

—

Yes

—

—

Adgroup Site Link

—

Yes

—

—

—

—

—

Yes

—

—

Creative Site Link

—

—

—

—

—

—

—

—

Yes

—

Adgroup Negative Keyword

Yes

Yes

Yes

—

—

—

Yes

Yes

—

—

Adgroup Negative Website

—

Yes

Yes

—

—

—

—

—

—

—

Campaign Location Target

Yes

Yes

Yes

—

—

—

Yes

Yes

—

—

Adgroup Location Target

—

—

Yes

—

—

—

—

Yes

—

—

Campaign Device Target

—

Yes

Yes

—

—

—

—

Yes

—

—

Adgroup Device Target

—

Yes

Yes

—

—

—

—

Yes

—

—

Campaign RLSA Target

—

Yes

Yes

—

—

—

—

—

—

—

Adgroup RLSA Target

—

Yes

Yes

—

—

—

—

—

—

—

Campaign RLSA Negative

—

Yes

—

—

—

—

—

—

—

—

Adgroup RLSA Negative

—

Yes

—

—

—

—

—

—

—

—