What are the responsibilities and job description for the Advertising Research Analyst position at Redolent, Inc?
One of our direct client is urgently looking for an Advertising Research Analyst@ New York, NY
Job Title:Advertising Research Analyst
Location: New York, NY
Duration: 3 to 6 Months
Description:
TiVo's Advertising group spans a wide range of media solutions, including enabling entertainment advertisers, agencies, content providers and marketers to reach consumers in “search and discovery mode” - when they are highly receptive to advertising. Our Guide Advertising, Sponsored Discovery, and CTV solutions appear as content choices in interactive program guides, in-app on smart TVs and nestled within the search and recommendations of a consumers' user experience. These ideal placements make TiVo a perfect complement to today's overall TV media buys.
Summary:
The Advertising Research Analyst works closely with the Advertising Director , Analytics & Insights to support the Advertising team by providing advertising campaign insights to clients advertising on TiVo platforms. This position also collaborates with the Advertising Product & Operations teams to develop and report on KPIs, and provide internal reports required for business intelligence and financial reconciliation.
The Research Analyst uses proprietary first party data to analyze post-campaign performance on the product platforms, including CTV programmatic/direct deals and linear display guides. Performance metrics include impression delivery, and ad exposed program tune-in lift for linear, L3/L7 and VOD viewing. New CTV initiatives require digital linear and OTT metrics reporting through ad serving partners as well as Tivo proprietary UIs.
Responsibilities:
Produce monthly and quarterly internal reports including KPI and impression delivery and revenue by platform and partner/advertiser
Provide post-campaign metrics reports for all ad campaigns on Tivo platforms including IPG, recommendations carousel and CTV
Analyze set top box return path data for post-campaign insights including campaign ad exposure and tune-in lift for linear and delayed viewing
Prepare client facing PowerPoint presentations for post campaign insights
Collaborate with Sales, Engineering and Ad Operations teams to develop and improve campaign reporting capabilities
Skills: Requirements:
Experience in digital advertising including targeting and attribution; CTV video advertising would be a plus
Expertise in Excel including:
Functions such as if/and/or; look ups and index/match; sumif/ /countif/; sumproduct; formula errors; array formulas; pivot tables
Data querying from multiple files
VBA
Linear programming (solver, data tables)
Predictive modeling (regressions)
Forecasting (exponential smoothing, seasonality)
Ability to analyze raw data, interpret performance and summarize actionable insights
Familiarity with analytics and ad delivery platforms (Google Ad Manager, Tableau)
Detail oriented and self-motivated
Excellent oral and written communication skills
Team player who can collaborate across functions and business groups