Upload a bulksheet or corrected error file
You can upload bulksheet files, corrected landing page validation error files, and other corrected error files from your device or network for supported ad networks. Any custom columns in the file are deleted when you upload the file.
-
In the main menu, click Search > Campaigns > Bulksheets.
-
In the toolbar above the data table, click Upload Bulksheet.
-
Enter or select information in the Upload Bulksheet settings.
-
Click Apply.
When the task begins, the file is listed in the Bulksheets view. When the file is complete, an email notification is sent with a link to the file. Depending on the amount of data compiled, the email notification may take several minutes or more. If the file generation fails, however, then an error file is listed on the Bulksheets view, and an email notification is sent with a link to the error file.
Upload settings for bulksheets and corrected error files bulksheet-upload-settings
Bulksheet files can be up to 2.5 GB (about 2.5 million rows) and must have one of the following file extensions: .tsv (for tab-separated values), .txt (for Unicode-compliant ASCII text), .csv (for comma-separated values), or .zip (for compressed ZIP format, which unzips to a TSV file). The file name can’t include the following characters: `# % & *
When or if to post the file to the specified ad network:
- Post to ad network now (the default): Begins posting the data immediately.
- Post to ad network on [specified date] [specified time]: Begins posting the data on the specified date and time; the default is tomorrow at 02:00 (2 a.m.). To change the date, enter a date in the format DD/MM/YYYY or D/M/YYYY or click to open the calendar and select a date. To change the time, enter the time in the format HH/MM or H/M or select a time (in 15-minute intervals) from the list.
- Preview only: To upload the file to Search, Social, & Commerce without posting the data to the ad network; you can still post the file later. When the bulksheet file is more than 10 MB but smaller than 2 GB, the file is in ZIP format; you don’t need to unzip the file to post it.
If you select Yes, then the URLs are generated according to the parameters in the Tracking Methods section of the relevant account settings or campaign settings. By default, if tracking URLs exist, they aren’t regenerated unless new ones are needed (such as if the keyword match type, the ad text, or the tracking parameters for the relevant accounts have changed).
If you select No, then you can still generate tracking URLs later by manually posting the uploaded file.
Note: If the advertiser uses Adobe Advertising conversion tracking and the base URL has changed, you must generate new tracking URLs unless the account is configured to automatically generate and upload tracking URLs.
Note: Any budget changes resulting from the posted data for campaigns in non-optimized portfolios occur when the file is posted. Changes appear in the campaign management views the next day.