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 Search > Campaigns > Bulksheets.
In the toolbar, click Download Bulksheet.
Specify the bulksheet settings:
On the Selections tab, enter or select information in the fields.
(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.”
(Optional) Click the Filters tab, and then indicate criteria for specific campaigns, ad groups, ads/creatives, keywords, placements, and other entities to include in the bulksheet:
Select a parameter (entity name or ID; or any element of an ad, 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.
When the task begins, the window displays a notification but remains open so you can continue to create additional bulksheets if you want. Any specified filters and exclusions that are applicable to any new accounts that you select are retained. When the task begins, the file is listed in the Bulksheets view. 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, however, then an error file is listed in the Bulksheets view and you receive an email notification with a link to the error file.
|Selections||SE Accounts||The accounts, campaigns, or ad groups to which to upload the data:
|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).
|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:
|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:
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:
|Bulksheet Row||Baidu||Google Ads||Microsoft® Advertising||Naver||Yahoo! Display Network||Yahoo! Japan Ads||Yahoo Native||Yandex||Notes|
|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.|
|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||—||—||—||—||—||—||—||—|