Filename conventions
Filename should describe its contents and the target dataset. Please maintain the same filename convention during data updates, since it helps automating the data processing.
CSV files
Files transferred and shared should be in machine-readable CSV file format to minimize any errors in data ingestion
Encoding = UTF-8
Delimeter = Comma
Decimal seprator = Dot
Quote character = "Double quotes"
Data types
DATE = Dates as YYYY-MM-DD (ISO 8601 standard), for instance 2021-01-24
TIME = Times as hh:mm or hh:mm:ss (extended ISO 8601 format with 24-hour clock), for instance 18:33:00
TEXT = Text string of any length, for instance "Black Friday mega campaign 2022"
INT = Integer number type, for instance 12345
FLOAT = Floating point number type, for instance 123.45
BOOL = True or False (1 or 0 also ok)