Local Law 83 - City Agency Advertising Spend

n56u-3hzvCity Government14 columns

MOECM functions as financial oversight for all City of New York media placement spend, providing guidance on marketing efficiency and strategy, as well as, monitoring alignment with the budgetary goals set out in LL83, where each city agency should seek to spend at least 50 percent of applicable media placement budgets with ECM outlets. MOECM is required to report annually on specific city agencies' full advertising spend across all media categories, including ethnic and community (ECM), mainstream, out-of-home, social media, etc. This dataset as well as the dashboards found in this portal reflects the media placement spend of city agencies that had marketing campaigns and their individual alignment with LL83’s goals. MOECM works closely with media placement vendors and city agencies to gather accurate media placement spend data through reports, effectively tracking each paid advertisement placed on behalf of the City of New York. This data is collected, analyzed, and publicly posted to promote transparency regarding media placement budget allocation. For more information, please visit the MOECM website https://www.nyc.gov/site/ethnicmedia/index.page).

View on NYC Open Data

Quality

A91.0 / 100

From a 500-row sample across 14 columns.

completeness100/ 25% weight

consistency93/ 20% weight

accuracy86/ 20% weight

timeliness75/ 15% weight

usability95/ 20% weight

Related datasets

Local Law 83 – FY 2020-2022 Historical Ethnic and Community Media Agency Ad Spend by Agency0.37
joins onfiscal_year
Citywide Marketing Directory0.35
NYC Zoning Tax Lot Database0.30
2020 Census Tracts0.29
DSNY Monthly Tonnage Data0.28
Tax Lien Sale Lists0.28
NYC Historical Vital Records: Index to Digitized Death Certificates0.27

Sample rows

fiscal_year	media_placement_vendor_name	city_agency	ad_campaign_name	campaign_purpose	media_outlet_name_city_agency_submission_	media_outlet_name_standardized_	media_type_agency_submission_	media_type_standardized_	language	run_start_date	run_end_date
FY 2025	Malone Creative Group	FDNY	Lithium Ion Battery Safety	Education	1010 WINS	1010 WINS	Radio	Radio	English	7/29/2024

Columns

14 queryable · 14 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`fiscal_year`	categorical	Fiscal year spans from July 1st until June 30th.	0%	`FY 2023FY 2024FY 2025`of 3
`media_placement_vendor_name`	text	The name of the advertising placement vendor/organization through which the advertisement was placed.	0%	`Infosoft Group Inc. dba …OpAD MediaMiller`
`city_agency`	text	Acronym of the city agency or office placing advertisements.	0%	`DOHMHDOIDOT`
`ad_campaign_name`	text	The name of the ad campaign e.g. "Senior Citizen Rent Increase Exemption advertising"	0%

Query this from your own app

GET /api/datasets/n56u-3hzv
GET /api/datasets/n56u-3hzv/quality
GET /api/datasets/n56u-3hzv/related
GET /api/columns?dataset=n56u-3hzv