Dow Jones Job Naming Tool
A web-based tool for generating standardized job names following the Dow Jones naming convention. Features an AI-powered command bar (Google Gemini) and an interactive spreadsheet interface.
Naming Convention
Standard Format:
[OMGID] - [Domain]-[Subteam]-[Brand]-[Initiative]-[YY]-[Sequence]_[AssetName]_v[Version]
Event Format (when Domain = EVNT):
[OMGID] - EVNT-[EventAbbrev]-[YY]-[Sequence]_[AssetName]_v[Version]
Examples:
000000 - PMKT-ACQ-WSJ-BIC-26-01_MetaBanner_v1000001 - PMKT-ENGRT-WSJ-BIC-26-01_Email_v1000002 - EVNT-GFF-26-02_Agenda_v3
Variable Reference
Domain
| Full Name |
Abbreviation |
| Performance Marketing |
PMKT |
| Brand |
BRND |
| Event |
EVNT |
| B2B |
B2B |
Subteam (non-Event domains only)
| Full Name |
Abbreviation |
| Acquisition |
ACQ |
| B2B |
B2B |
| Content Marketing |
CMKT |
| Engagement / Retention |
ENGRT |
| Enterprise |
ENT |
Brand (non-Event domains only)
| Full Name |
Abbreviation |
| Wall Street Journal |
WSJ |
| Wall Street Journal+ |
WSJ+ |
| Barron's |
BAR |
| MarketWatch |
MW |
| Dragonfly |
DF |
| Dow Jones Energy |
DJE |
| Factiva |
FAC |
| Free Expression |
FE |
| Global Risk Insights |
GRI |
| Newswires |
NWS |
| Oxford Analytica |
OA |
| Risk |
RSK |
| Risk Center |
RSKC |
| Risk Journal |
DJRJ |
| Risk & Compliance |
R&C |
| World ECR |
WECR |
Event (EVNT domain only)
| Full Name |
Abbreviation |
| Global Horizons |
GH |
| Risk Journal Summit |
DJRJS |
| World ECR |
WECR |
| Free Expressions Opinion Event |
FEOE |
| Future of Health |
FOH |
| Global Food Forum |
GFF |
| Journal House |
JH |
| TechLive |
TL |
| TechLive Qatar |
TLQ |
| TechLive Cyber |
TLCYB |
| The Future of Everything |
FOE |
| WSJ Invest Live |
WSJIL |
| Board of Directors Council |
BODC |
| CCO Council |
CCOC |
| CEO Council |
CEOC |
| CFO Council |
CFOC |
| CMO Council |
CMOC |
| CPO Council |
CPOC |
| Technology Council |
TECC |
| WSJ Leadership Institute |
WSJLI |
Other Fields
| Field |
Description |
Example |
| OMGID |
6-digit numeric identifier |
000000 |
| Initiative |
Free-text abbreviation |
BIC, DEMO, LAUNCH |
| YY |
2-digit year |
26 |
| Sequence |
2-digit sequence within a group |
01, 02 |
| AssetName |
PascalCase asset description |
MetaBanner, Email, Agenda |
| Version |
Integer version number |
1, 2, 3 |
Features
- AI Command Bar: Create and update jobs using natural language, powered by Google Gemini
- YOLO Mode: Skip clarifying questions for faster execution
- Voice Input: Speech-to-text for hands-free operation
- Live Filename Generation: Filenames auto-update as you edit cells
- Dropdown Validation: Domain, Subteam, Brand, and Event fields use validated dropdowns
- Campaign Save/Load: Save and reload named campaigns
- CSV Export: Export all data to CSV
- Copy Filenames: One-click copy of all generated filenames
Setup
Prerequisites
- PHP 7.4+
- Web server (Apache or PHP built-in server)
Installation
- Clone the repository
- Create
config.php:
<?php
$GEMINI_API_KEY = 'your_google_gemini_api_key_here';
$CURRENT_USER = 'default_user';
?>
- Ensure write permissions:
touch data.json && chmod 666 data.json
touch activity.log && chmod 666 activity.log
mkdir -p campaigns && chmod 777 campaigns
- Start the server:
php -S localhost:8000
File Structure
| File |
Description |
index.php |
Main UI with spreadsheet and command bar |
api.php |
Backend API: AI commands, data CRUD, campaign management |
script.js |
Frontend logic: spreadsheet, filename generation, voice input |
style.css |
Styling |
config.php |
API keys and settings (not in version control) |
sheet_helpers.php |
Sheet CRUD helper functions |
data.json |
Current working data |
campaigns/ |
Saved campaign files |
License
Proprietary - Internal Use Only.
c9379fa89f