wsj-filenaming/README.md

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_v1
• 000001 - PMKT-ENGRT-WSJ-BIC-26-01_Email_v1
• 000002 - 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

1. Clone the repository
2. Create config.php:

   <?php
   $GEMINI_API_KEY = 'your_google_gemini_api_key_here';
   $CURRENT_USER = 'default_user';
   ?>
   

3. Ensure write permissions:

   touch data.json && chmod 666 data.json
   touch activity.log && chmod 666 activity.log
   mkdir -p campaigns && chmod 777 campaigns
   

4. 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.