Download/Create a bulksheet file

Last update: 2023-09-29
  • 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.

  1. In the main menu, click Search > Campaigns > Bulksheets.

  2. In the toolbar, click Download Bulksheet.

  3. Specify the bulksheet settings:

  4. On the Selections tab, enter or select information in the fields.

  5. (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.”

  6. (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:

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

    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.

  7. Click Download.

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.

Bulksheet download settings

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 Down arrow 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 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 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 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.
  • [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 Right arrowhead 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 rows by ad network

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

On this page