Multi-Media Lead Generation Coordinator

Responsibilities

• Assist in placing advertisements on national and local TV stations
• Work with media vendors and station reps to confirm traffic, negotiate rates, and request pre-logs and post-logs
• Maintain buy sheets and ensure accurate entry of placement details into Excel tracking systems
• Manually match leads to stations using ZIP codes, phone numbers, area codes, and geographic mapping tools
• Reconcile incoming lead data with expected station performance, flagging discrepancies and performance issues
• Pull and merge lead data from call center platforms into structured tracking sheets
• Format, clean, and de-duplicate large data sets using Excel and conditional logic to ensure accurate reporting
• Track Source Names and ensure TV leads are properly categorized for performance review
• Apply rules for removing duplicates, validating policyholder status, and segmenting local vs. national campaigns
• Coordinate with agents to place direct mail campaigns across the United States

Requirements

• Strong Excel skills (sorting, conditional formatting, formulas, pivot tables)
• Detail-oriented with excellent organizational skills
• Ability to work independently, follow complex step-by-step processes, and meet deadlines
• Comfortable reviewing, comparing, and analyzing numeric data
• Strong written and verbal communication skills

Preferred

• Background in marketing, media buying, data analysis, or insurance lead generation
• Familiarity with TV campaign tracking, lead validation, or advertising platforms (e.g., Facebook, Google, TV logs)
• Experience working with CRMs, call centers, or ad tracking systems

Benefits

• 401(k) matching
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance