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 the chapter on “Required/Included Data in Bulksheets”).
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.
You can optionally upload bulksheet files to a specified FTP account for retrieval and automatic posting. The directory is scanned every hour, and new files are posted to the search network in the order in which they’re received.
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
-
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 Native, and Yahoo! Display Network accounts
You can download your existing (unsynchronized) data.
Overview of using bulksheets
The standard steps in using bulksheets for 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, or upload the file to a specified FTP account for automatic posting.
-
-
(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 bulk sheet, including the tracking URLs it generates when required.
When errors occur during 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 Search > 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.