Andrea Diamond Email & Phone Number

Altadena, Ca, Us

Burbank, Ca, Us

• Responsible for strategic ratings forecasts for all ABC Primetime shows, ABC News specials & Jimmy Kimmel Late Night including annual, long-range plans and in-season forecasts.• Liaised with ABC News, Marketing, Ad Sales and Finance Teams in curating one-sheets for ad-hoc greenlight show requests sharing pertinent content strategy information including scheduling, ratings estimates, show budget, rationale and comparative historical trending that influenced acquisition of new and current programming.• Built audience demographic profiles (P2+, M/W 18-49, P25-54,etc.) for ever-changing broadcast landscape during each forecast for Sales team to utilize on an individual show level for media planning/ buying.• Supported quantitative and qualitative research during up-front season, delivering key analysis of multi-scenario content scheduling, ensuring that all scheduling assumptions are strategically sound through solid rationalization.• Met weekly with senior executives of the business including Data Science, Finance and Ad Sales to discuss C3 ratings stewardship pacing and changes to the estimates, assisting Exec. Director of Research to lead a dialogue around programming content strategy and potential plans to drive viewer growth.• Project Management of tracking and analyzing all ABC primetime shows, Disney+ Movies, Jimmy Kimmel Late night and competitive landscape performance while ensuring accuracy to the data.• Evaluated methodology changes by Nielsen (i.e. Big Data/Panel) to alert key stakeholders to potential trend changes.• Distributed ABC weekly viewership Pacing Reports to senior executives of Disney.• Manipulated large excel data sets into Tableau, extracting actionable insights and creating appealing presentations.• Trained junior analyst•

El Segundo, California, Us

• Provided daily, monthly, quarterly and YOY insights & analytics to support Mattel’s top brands and competitors on YouTube & Social (Facebook, Twitter & IG)• Maintained & analyzed KPI’s across 10 Tableau dashboards for strategy teams (KPI’s include: Impressions – organic & paid views, p/e ratio, clicks, subscribers/followers, top videos, Nielsen DAR, Tubular ratings).• Presented analytics to all levels of seniority & leads training on analytical software.• Partnered with digital strategists, data science, channel leads, media agencies, executive leadership & consumer insights teams to deliver thoughtful analyses that will drive strategic product, content, and marketing decisions.•

• Analyzed national and local and national ratings and external data sources in order to develop actionable insights and compelling stories for Fox Sports studio shows, competitive landscape and proprietary sports aired on all Fox Sports Networks for internal and external stakeholders. Clients included: Bundesliga, College Basketball & Football, Golf, MLB, NASCAR, NFL, Red Bull Sports, Super Bowl LIV, 2018 Men’s World Cup, 2019 Women’s World Cup, WWE• Partnered with Scheduling, Marketing/Strategy and Acquisitions to advise on key business initiatives, including frequent schedule changes to optimize ratings, informing Acquisitions in the purchase of appropriate content for networks and renewals of current programming, five-year strategic plan and developing ROI measures for Marketing.• Ran various reports for internal departments in order to track audience including but not limited to segmentation, audience consumption & duplication, length of tune, reach & frequency. • Built, maintained and disseminated daily & monthly dashboards that identified key metrics. • Assisted with all phases of research design including questionnaires for focus group, pulling historical data and audience profiles. • Strong demonstrated ability with Advanced Excel (pivot tables & macros), Adobe Analytics, Arianna, Facebook Insights, Google Analytics, Google Ads, Nielsen NPower, NNTV, MyEVnts & Digital Ad Ratings, Nielsen Social, STAR Media, SQL, Tableau, Tubular and YouTube Analytics

Burbank, California, Us

• Supported qualitative and quantitative research for linear and digital/OTT programming.• Provided support for pilot testing, focus groups for on-going series, and other qualitative research in relation to the ABC brand and ABC Primetime shows (scripted and unscripted)•Used Nielsen software to pull data for ABC primetime programs and track competitive programming.•Created weekly grids for cable, network and premium programming.• Researched digital multi-platform’s (ABC Watch App, ABC.com, AOL analytics, Facebook Insights, Hulu Analytics , YouTube Analytics) performance of ABC Primetime Series• Updated Video on Demand programming schedule, monthly MVPD daily orders

Washington, District Of Columbia, Us

• Completed secondary research (Qualitative and Quantitative) • Proofed banner books (crosstabs), top lines, reports, memos and presentations • Drafted surveys, monitored cultural trends and marketplace• Assisted Senior Strategist with creative media strategies, booking and transcribing focus groups• Conducted Ad-hoc as necessary• Advanced Excel, SPSS, Survey Monkey

Washington, Dc, Us

Completed secondary research (Qualitative and Quantitative) Drafted data plans, Edited focus group transcripts, Assisted with In-Depth-InterviewsCreated report shells, populated topline and final reports with crosstab dataProofed final client deliverable's and created external and internal PPT's.

Washington, Dc, Us

Assisted with media outreach and research related to health policy and commercial accounts Blogged for health policy accounts Event planning for North American and global accountsCompiled media lists and media monitoring

Chicago, Il, Us

Conducted research for domestic and international public affairs, foreign governments and commercial accountsCompiled media lists and distributes media kitsDrafted press releases and media monitoring reportsContributed to advertising strategies for media pitchesLiaised with local print media journalists

Chicago, Illinois, Us

• Recruited, trained, and managed teams of volunteers to increase voter turnout• Assisted with the opening of 3 offices in and around Des Moines• Developed relationships with local politicians to promote coordinated activity• Hired and managed deputy campaign staff, interns• Produced & marketed youth based events w/ celebrity guests & bands

Promoted sales & profits (5M gross/year)Provided innovative marking and branding strategiesSupplied & marketed event coordination through hotel events management staffTrained, recruited, hired employees; Administered payroll, addressed HR inquiries·

International Business, Public Communications

International Business/ Global Marketing - Study Abroad

Associate'S Degree

Sql, Data Science, Consumer Market Research

Education record

Education record