Robert Mercier Email & Phone Number

San Francisco, Ca, Us

NBCU• Consulted, researched and created reports on behalf of the 10-NBCU networks for targeting, measuring, analyzing, describing and prospecting viewers. • Worked with the Comms Director to streamline internal processes.• Teamed with strategists to guide the NBCU client in the development of television plans and evaluation of the television execution. Target• Create data harvesting processes to assist with client data reporting.• Meet with vendors to evaluate data value to clients.

New York, Ny, Us

ABC News• Run and report daily, weekly, monthly and quarterly Nielsen viewership data on ABC News programs and its competitive set.• Provide ratings analysis on ABC News programs and its competitors.• Manage reports to reflect trends and answer specific questions for broadcast news stakeholders. • Maintain departmental databases.• Create ad-hoc reports and respond to requests as needed.• Analyzed and presented Tableau findings to the Vice President and Director of Research.Media Village• Developed and stewarded in-market surveys of advertising professionals.• Analyzed and obtained insights for use in the Myers Report a market-leading primary research periodical.• Assisted the marketing team in industry thought leadership and conceptualizing the future of media and helped in various presentations and conferences to that end.

• Analyzed ratings, demographic and psychographic information for our clients’ and their competitors’ TV programs. • Compiled trending information for broadcast, cable and syndication markets for use in TV planning and buying.• Created competitive spending reports for the online and video gaming categories and maintain libraries of information in the categories for Tangible Executives.• Formed demographic and psychographic profiles of consumers for targeting.• Provided viewer insight, consultation and recommendations for a network TV program on a weekly basis and forecasting after the season. • Worked on ratings forecasting projects TV clients. • Created ad hoc reports as needed in a timely and professional manner.• Led custom research project.• Create and analyze survey data for primary research projects.• Worked with account team to develop and execute new business opportunities within CPG and gaming categories.• Advised on contractual negotiations for client scope of work.• Foster relationships with media research vendors for use in Tangible Media research initiatives.• Collaborate with internal teams to create new business presentations.Clients: Marvel Entertainment, Marvel Television, Saban Entertainment. Tools: Nielsen: NPower, Marketbreaks, Kantar: Stradegy, Market Advisor, ComScore, SQAD, Survey Monkey.

• Analyzed advertising category data to find opportunities for the Scripps Networks sales teams in the fast-moving national marketplace. • Tracked the performance of original and repeat airings of programs and individual Scripps networks to find strategic insights and tactical applications for the properties. • Performed competitive analyses on Scripps programs and networks to uncover strengths, weaknesses, opportunities and threats. • Created both trending and static reports detailing the daily, weekly, monthly, quarterly and yearly delivery and ratings for Live + Same Day and C3.• Created PowerPoint slides detailing quarterly and yearly KPI metrics to help sales teams position Scripps in the marketplace. • Identified program highlights for programming on FOOD Network, Cooking Channel, Travel Channel and GAC.• Assisted with the quarterly projection estimates that were used for rate cards in the media marketplace.• Reported on the continuous ratings, reach, time spent viewing (TSV) metrics for network programming.• Created yearly industry trending decks to help executives keep abreast of the current trends in the marketplace.• Assisted in creating research books/materials for cataloging information. • Collaborated with and integrated findings for internal proprietary research into sales literature. • Formulated key marketing objectives and performance indicators across a range of Scripps properties.Tools: Nielsen: NPower, Marketbreaks, Ad* Views, Fusion, MyEVNTS, Star Media: Star Trak, Multitrak ACM/Multitrak, MRI, Simmons: One View, MME, Mintel, Beta, Kantar Stradegy, Market View, Rentrak TV Essentials.

• As a startup, worked with various corporations, agencies and marketers to uncover new ways of measuring media and consumer usage levels via single-source data.• Datamined various streams of information to create reports for clients, partners and investors.• Troubleshooted proprietary system and validated the media metrics of a revolutionary media measurement system • Created ratings standards and baselines to insure accuracy and quality.• Consulted internal teams on media math and implementation of new metrics for our SaaS platform.• Assisted in the creation and implementation of internal product roadmap.• Initiated new ideas for implementation of data usage. • Helped in quality assurance.• Recommended planning and buying strategies based on data analytics.• Teamed with partners to oversee custom analytic projects.• Created various quality checks and safeguards to ensure the integrity of the data and the database. • Garnered insights from data to add value to brands, agencies and internal executives’ decks for sales and industry presentations decks.Clients: MARS, P&G, PepsiCo, CBS, MediaVest, Comcast Spotlight, Charter Communications (now Spectrum Cable)Tools: TRAanalytics, Kantar Stradegy, Nielsen Galaxy, TiVo Stopwatch, IRI

New York, New York, Us

• Oversaw and stewarded the planning and buying of media for an array of clients in the US and internationally.• Gathered market intelligence for media spending and strategic initiatives.• Managed, reconciled and estimated billing. • Supervised a junior team member daily work flow.• Coordinated the cross-media strategy across Horizon’s planning and buying teams. • Fostered client relations and stewarded their campaigns.• Identified consumer targets and mined insights. • Performed competitive analysis for various clients in different categories.• Compiled media posts to ensure proper client value• Facilitated client request and found answers to client questions along with organizing meetings with various business partners.• Recapped and evaluated brand campaigns including ROI analysis.• Planned media for a new business. Clients: Franklin Templeton Investments, Pokerstars, HAAS Avocadoes, Nature’s Cure, Avocadoes from Mexico, Clementines from Spain. Tools: Kantar: Stradegy, Nielsen: Galaxy, Strata

Us

• Worked with clients to meet advertising and media goals. • Managed creative team to adhere to client strategies and spec and coordinated cross-team workflows.• Helped create primary research surveys and focus group topics.• Managed monthly media plans that included TV, radio, newspaper, magazine, internet, direct mail and out-of-home offerings.• Oversaw the introduction of digital media into the agency offerings.• Looked out for new and inventive media vehicles to spotlight our client’s brand. • Reviewed contacts for signage at big-four sports league (MLB, NFL, NBA, NHL) stadiums. • Stewarded in-game branding for use at sporting events.• Maintained quality control for the look and presentation of in-game dynamic signage.• Researched potential sponsorship for Major League Soccer.• Managed hospitality for clients in luxury suites in all four major sports leagues.• Reconciled monthly accounting journals and budgets.Clients: Delta Dental, Briarcliffe College, Millford HotelTools: Strata

• Managed our creative team to fulfill our clients’ creative executions in an impactful, targeted and timely manner. • Worked on campaigns with high profile celebrities to enhance our client’s brand equity.• Stewarded integrated marketing communication with POP, print and promotional campaigns.• Maintained steps in a 35-step work-flow process and managed, guided and directed creatives, merchandising, permanent and print and team members through this process and the corresponding schedules.• Reconciled monthly accounting journals and budgets.• Organized paperwork for far-ranging duties including legal, invoices, approvals and schedule dates.• Led cross-functional team meetings.• Coordinated overseas convention set up. • Kept abreast of cultural and media trends for our client.Clients: Coors, Remy Martin, Magic Johnson Foundation Tools: SBMS, Scarborough

Us

• Oversaw the branding and marketing of a college newspaper• Accomplished the feat of turning around a fledgling newspaper.• Created a $50,000 profit from a $100,000 deficit the year before in the middle of a recession.• Diversified and expanded newspaper distribution network.• Coordinated campus, local and national advertising into cohesive business units.• Started functional departments within the newspaper’s business operations and sales incentive structure.• Led the newspaper into a competitive Denver newspaper market and targeted corresponding advertisers along the way.• Directed a staff of five.• Worked with editorial staff to coordinate marketing and editorial objectives. • Compiled databases for direct marketing campaign and maintained database. • Developed, conducted and compiled surveys to find information on readership.• Reconciled quarterly and yearly budgets.Tools: Quickbooks, SAS

• Solved business problem for a distributor of the DaimlerChrysler Corporation.• Competed against national and Ivy League business schools in the case-study competition. • Presented findings to executives of DaimlerChrysler and various Fortune-500 companies.