Bulksheet Requirements | Community
Skip to main content
sushant_sikka
Level 2
September 1, 2016
Solved

Bulksheet Requirements

  • September 1, 2016
  • 2 replies
  • 3203 views

Hi Team,

What are the file requirements for a bulksheet – Maximum size, acceptable file formats, file name format etc?

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ranjansingh

Hi Sushant,

Bulksheet files for multiple campaigns can contain up to 500,000 data rows. If you are generating data for multiple campaigns and the combined data consists of over 500,000 rows, Media Optimizer will split it by campaign into two or more files, as necessary, named <bulksheet name>_1.tsv, <bulksheet name>_2.tsv, and so on.

There are four acceptable formats {.tsv, .txt(unicode), .csv and .zip) available for a bulksheet.

When the bulksheet file is more than 10 MB but smaller than 2 GB, the file will be in ZIP format; you won't need to unzip the file to post it.

 Bulksheet File to Upload

The bulksheet file to upload; it must include all required fields and be in one of the following formats:  .tsv (tab-separated values), .txt (ASCII text), .csv (comma-separated values), or .zip (compressed TSV file). For bulksheets that will include international characters, upload files in TSV or TXT format.

Specify the file either by entering the full path and file name or by clicking Browse to locate the file on your computer or network.

 

Hope it helps!

Regards,

Ranjan

2 replies

nidhik
Level 4
September 1, 2016

Hi Sushant,

Following formats you can use: CSV, TSV, TXT, ZIP and the file size can be upto 2.5GB

Regards

Nidhi

ranjansingh
Adobe Employee
ranjansinghAdobe EmployeeAccepted solution
Adobe Employee
September 1, 2016

Hi Sushant,

Bulksheet files for multiple campaigns can contain up to 500,000 data rows. If you are generating data for multiple campaigns and the combined data consists of over 500,000 rows, Media Optimizer will split it by campaign into two or more files, as necessary, named <bulksheet name>_1.tsv, <bulksheet name>_2.tsv, and so on.

There are four acceptable formats {.tsv, .txt(unicode), .csv and .zip) available for a bulksheet.

When the bulksheet file is more than 10 MB but smaller than 2 GB, the file will be in ZIP format; you won't need to unzip the file to post it.

 Bulksheet File to Upload

The bulksheet file to upload; it must include all required fields and be in one of the following formats:  .tsv (tab-separated values), .txt (ASCII text), .csv (comma-separated values), or .zip (compressed TSV file). For bulksheets that will include international characters, upload files in TSV or TXT format.

Specify the file either by entering the full path and file name or by clicking Browse to locate the file on your computer or network.

 

Hope it helps!

Regards,

Ranjan