Programmatic Media Coordinator

DEPT®•San Diego, CA

7d•Remote

About The Position

As an Account Coordinator, Programmatic, your primary function will be to provide vital production support for your account team. Day-to-day responsibilities include but are not limited to running and formatting performance reports, creative trafficking and tagging, building and uploading campaigns, QA support for campaign builds and optimizations and participating in and taking notes during internal syncs, client meetings, and presentations. Account Coordinator, Programmatic will become responsible for an enterprise level account and will learn DEPT®’s best practices for Programmatic Buying while gaining the foundational skills necessary to progress into more advanced roles that will expand on the breadth and depth of knowledge. While DEPT® is a remote-first company, this role requires candidates to be located in either Central, Mountain or Pacific time zones.

Requirements

0 - 6 months of programmatic marketing experience
Strong analytical and reporting skills and knowledge of Microsoft Excel / Google Sheets
Strong time-management skills and the ability to prioritize to deliver multiple tasks on time
Strong written and verbal communication skills
Candidates must be located in either Central, Mountain or Pacific time zones
Proficiency in Excel/Sheets: Demonstrate proficiency in using essential spreadsheet functions and formulas including, but not limited to: sorting, filters, xlookup, concatenate, pivot tables, text to columns, conditional formatting
Demonstrate an understanding of how to take advantage of these functions and formulas when performing tasks (ex: ad customization uses concatenation and length formulas) with limited oversight needed
Accuracy is critical, and Account Coordinators will need to QA their work to ensure accurate data is being relayed to the rest of the team and clients
Proficiency in Programmatic: Ability to pull reports at various levels along with the desired columns/metrics and understand the data/results
Creative trafficking and tagging
Leverage The Trade Desk, Walmart, TTD, Criteo and Roundel DSPs or another DSP to pull and schedule reports for analysis; identifying trends and developing client reporting summaries
Understand relevant media metrics, how to calculate them, and articulate their relationship to each other
Possess a high level understanding of the different optimization levers to pull to surpass benchmark KPI’

Nice To Haves

Energetic and creative marketing enthusiast; eager to roll up your sleeves and be hands on, learn, and grow in the marketing space
Entrepreneurial spirited and a self-starter; able to work both independently and in a team environment
A desire to stay current with the latest marketing trends

Responsibilities

Running and formatting performance reports
Creative trafficking and tagging
Building and uploading campaigns
QA support for campaign builds and optimizations
Participating in and taking notes during internal syncs, client meetings, and presentations
Pull reports at various levels along with the desired columns/metrics and understand the data/results
Update, monitor, and communicate daily budget pacing and high level performance, including flagging variations or anomalies
Leverage Pacvue or other automation tools to create efficiencies and set up live alerts
Organize large volumes of data for insights and strategic storytelling in Excel and/or Google Sheets
Develop suggestions on activation strategy around campaign builds, overall themes, hierarchy, audiences, parameters, and ads
Create and edit campaigns and audiences in DSPs with oversight and mentorship
Implement scheduled and ad hoc tasks delegated by direct manager and/or colleagues
Follow mandatory QA process to completion
Grow a thorough understanding of programmatic, constantly embodying a “forever student” mentality
Participate in programmatic trainings by asking questions, contributing ideas, and leaning into relationship with agency partners