Field guide
What each column in the archive index means. The same fields appear in the CSV and the JSON file.
| Field | Meaning |
|---|---|
url | Permanent link to the record. Never changes. |
slug | The record's identifier in its URL. |
title | Title of the ad, as known. English where available. |
title_bn | Bangla title, when recorded. |
brand | The product brand. |
advertiser | The company that ran the ad (client or parent group). |
agencies | Agencies credited, as "Name (role)", separated by semicolons. Roles: creative, media, digital, pr, production, other. |
year | Year the ad ran. When no source gives the year, this is the year it was published on the old site. |
medium | Print, TVC, Online video, Social, OOH, Radio, Activation, Packaging or Digital display. |
category | Industry category. |
language | bn, en, bn_en or other; empty when not recorded. |
awards | Award results, as "Level, Show Year", separated by semicolons. |
credits | People credited, as "Name (Role)", separated by semicolons. |
credits_incomplete | true when the archive knows the credits are incomplete. |
last_reviewed | Date an editor last reviewed the record (YYYY-MM-DD); empty if not yet reviewed. |
Notes
Text is UTF-8, with Bangla where it was recorded. Multiple values in one field are separated by semicolons. The CSV starts with a byte order mark so spreadsheet apps read Bangla correctly.
Attribution line to use: Data: The Ads of Bangladesh (adsofbd.com), CC BY 4.0.