You can download, upload, and post bulksheet files for supported ad networks in any of the following formats:
When you create/download a bulksheet, it’s created in the specified file format with all relevant data included in the file. Use the following information to edit data in the file or to create your own bulksheet manually.
The first record (line) of a bulksheet file contains a set of specific column names, collectively known as a header. The column names in the header are in a specified order and correspond to each of the fields in the subsequent data records. The column names required in the header vary by ad network.
Each subsequent record (line) contains data, with fields containing values (or no values) for each column in the header.
Bulksheet files can be up to 2.5 GB, which is about 2.5 million rows.
When you generate a bulksheet for multiple campaigns and the combined data consists of over 500,000 rows, the data is split by campaign into two or more files, named
<bulksheet name>_2.tsv, and so on.
Data fields delimited by tabs and by commas require different formatting.
Data fields in TSV files and TXT files delimited with tabs must be formatted as follows:
The fields in each record are separated by tab characters. To omit a value for a field, use only the tab character.
Fields can’t contain embedded tab characters.
Data fields in CSV files and TXT files delimited with commas must be formatted as follows:
The fields in a record are separated by commas. To omit a value for a field, use only the comma.
Any field may optionally be enclosed within double-quotes (
Fields with embedded commas must be enclosed within double quotes (
Cruises,5000,Caribbean,"Luxurious, spacious cabins",
Fields with embedded double quotes must be enclosed within double quotes (
Cruises,5000,Caribbean,"Customers say ""We wish we could stay forever."",
Fields with leading or trailing spaces must be enclosed within double quotes (
Cruises,5000,Caribbean," Come see what we mean. ",