Documentation Advertising Advertising Search, Social, & Commerce Guide

(New UI) Download/Create a bulksheet file

Last update: June 19, 2026

Topics:
Search, Social, & Commerce

CREATED FOR:

User

You can create bulksheets using custom settings for one or more accounts on one or more supported ad networks. Bulksheets include data within Search, Social, & Commerce.

For synced campaigns, you can optionally sync with the ad network before downloading the data to ensure that recent data changes on the ad network side are included. For all ad networks, you can optionally generate new click-tracking URLs to include in the file.

In the main menu, click Setup > Bulksheets.
In the toolbar, click Bulk Operations > Download Bulksheet.
Specify the bulksheet settings:
1. On the Selections tab, select the accounts, campaigns, or ad groups to include and configure the bulksheet options.
2. (Optional) Click the Rows and Columns tab, specify the account components and the component statuses for which to include rows in the bulksheet, and then specify the columns to include for each selected component.
  
  For a list of available bulksheet rows, see “Bulksheet rows by ad network.”
3. (Optional) Click the Filters tab, and then specify criteria for the specific campaigns, ad groups, ads/creatives, keywords, placements, and other entities to include in the bulksheet.
Click Download.

When the task begins, the window displays a notification but remains open so you can continue to create additional bulksheets if needed. When the file is created, you receive an email notification with a link to the file; depending on the amount of data being compiled, the notification may take several minutes or more. If the file generation fails, an error file is listed in the Bulksheets view and you receive an email notification with a link to the error file.

Bulksheet settings bulksheet-settings

Selections tab bulksheet-selections-settings

[Account, campaign, and ad group selection]

Expand the network and account hierarchy, and then select the check box next to each account, campaign, or ad group whose data to include in the bulksheet:

To include all campaigns and ad groups for an account, select the check box next to the account name.
To include specific campaigns, expand the account, and then select the check box next to each campaign to include. To include specific ad groups, further expand a campaign and select the check box next to each ad group.

NOTE

A single bulksheet can 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 the type of component an item is, hold your cursor over it.
By default, only active and enabled accounts and their active components are listed.

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).

NOTE

If the advertiser uses Adobe 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 an ad network) <search_engine name>_<creation date in the format MMDDYYYY>.tsv
(For a single account) <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: # % & * | \ : " < > . ? /

Optionally, change the file type. The options include .tsv (for tab-separated values), .txt (unicode) (for Unicode-compliant ASCII text), .csv (for comma-separated values), or .zip (for compressed ZIP format, which unzips to a TSV file).

TIP

For bulksheets that include international characters, use TSV or TXT format.

Rows and Columns tab bulksheet-rows-columns-settings

Bulksheet Rows: The entities, and their corresponding statuses, to include as data rows in the bulksheet, with one row per entry. For example, if you include active campaigns, 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.

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

For a list of available rows by ad network, see “Bulksheet rows by ad network.”

Cascading Status Hierarchy: Filters 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 Adobe-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.
[Entity-specific columns]: To include all, none, or only selected columns relevant to each entity selected in Bulksheet Rows, click next to the entity name to expand it, and then select or clear the check boxes for individual columns. By default, all relevant columns are included for each selected entity row.

TIP

Make sure you include adequate columns to identify the item in each row of the bulksheet file. For example, if you include keyword rows per the Bulksheet Rows selector but exclude all keyword-related columns, the resulting bulksheet includes one row for each keyword instance with no way to identify which keyword instance belongs to a specific row. In this case, you can’t use the bulksheet to update data unless you manually add the appropriate ID column and values.

Filters tab bulksheet-filters-settings

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

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.
(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 rows by ad network bulksheet-rows-by-ad-network

Bulksheet Row

Baidu

Google Ads

LY Ads

Microsoft Advertising

Naver

Yahoo DSP

Yahoo Native

Yandex

Notes

Campaign

Yes

—

Adgroup

Yes

—

Creative or Creative (except RSA)

Yes

—

Yes

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

Responsive Search Ad

—

Yes

—

Yes

—

Keyword

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

—

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

—

Adgroup Negative Website

—

Yes

—

Yes

—

Campaign Location Target

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

—

For details about the required and optional columns for each ad network, see the ad network-specific bulksheet data format articles:

recommendation-more-help

advertising-help-search-social-commerce