(New UI) About managing campaign data using bulksheets
A bulksheet is a file that contains campaign data in a specific format and can be used to quickly create or modify campaign and ad group structure data and text ads. You can generate (download) bulksheets with data for one or more accounts, for specific campaigns and ad groups, or even for specific text ads, placements, and product groups. You can use bulksheets to manage large data sets or to make small changes. Each ad network requires different columns of information.
You can generate bulksheets with as much data as you want — or optionally create them manually and upload them. See “Required and included data in bulksheets” for file format requirements, and “Operations you can perform in bulksheets” for supported operations by ad network.
Once you create a bulksheet, you can identify any broken landing pages that need to be corrected, or additional data to add or edit. You can then edit the file and upload it to Search, Social, & Commerce, optionally scheduling it to be posted to the relevant ad network immediately or later. You can also post an available bulksheet either immediately or later.
All bulksheets, landing page validation error files, and other error files are automatically deleted 30 days after they are created unless you delete them earlier.
Functionality by ad network bulksheet-functionality-by-network
-
Download, upload, and post: Baidu, Google Ads, Microsoft Advertising, and Yandex accounts
-
Download and upload only: Naver accounts
You can upload Naver data for use within Search, Social, & Commerce but can’t post it to the ad network. You can also download your existing (unsynchronized) data.
-
Download data only: Pinterest, Yahoo DSP, Yahoo Native accounts
You can download your existing (unsynchronized) data.
Overview of using bulksheets
The standard steps for using bulksheets with synchronized accounts are as follows:
-
Download data for one or more accounts, campaigns, or ad groups into a bulksheet file. Optionally, you can manually populate an ad network-specific bulksheet and upload the file.
-
Validate the landing pages in the base (final) URLs or destination URLs in the file.
-
When you need to add data or make corrections:
-
Export the file to your desktop and edit it in Microsoft Excel.
-
Manually upload the edited file to Search, Social, & Commerce.
-
-
(For files uploaded manually) Post the file to the ad network either as you upload it or later.
-
(If necessary) Download any new error files, correct the rows, and repost the file.
Managing errors in uploading and posting campaign data
Search, Social, & Commerce uploads and posts as many rows of data as it can from a campaign bulksheet, including the tracking URLs it generates when required.
When errors occur during a bulksheet operation, one of the following two types of error files is generated:
-
EF Errors: When a file or individual rows in the file can’t be uploaded or processed, an error file called
<uploaded file name>_ef_errors.<extension used for the bulksheet>is created. If the problem is with individual rows, then those rows are included, with an explanation of each error so that it can be corrected. -
SE Errors: When a file is posted but the ad network doesn’t accept some or all of the data, an error file called
<uploaded file name>_se_errors.<extension used for the bulksheet>is created. When some but not all rows were accepted, the error file shows the rows that weren’t posted and an explanation of each error so it can be corrected. The error messages are shown in the last three columns of each row.
You can download either type of error file, make corrections directly in the rows, and then reupload and post the file.
Error files are automatically deleted after 30 days unless you delete them earlier.
Information about each file
All downloaded data files, uploaded files, and error files are available from Setup > Bulksheets.
Information for each file includes the current task status and the percent of the task that’s completed, the date it was created, (when applicable) the date it was or will be posted to the specified ad network, the scheduled deletion date, and the login name of the user who initiated the task.