Lena Viktoria Frenzel

**** ******** *****, *** ****, CA 95121 714-***-**** aczxd6@r.postjobfree.com linkedin.com/in/lenafrenzel lenafrenzel.weebly.com Summary

Excellent spreadsheet modeling and presentation skills Outstanding problem solving and analytical skills California State University Fullerton, USA Fullerton, CA Master of Arts in Mass Communications: Research and Theory (GPA 4.0) Expected graduation: August 2017 Master Thesis: Building a General Linear Model for Facebook Engagement Technical University Freiberg, Germany Freiberg, Germany Bachelor of Science in Business Administration (2nd best business student out of 150, ECT-Rank A) October 2014 Google, Inc. via Omega Solutions, Inc. & eTeam [Temporary Assignments] San Jose & Palo Alto, CA

Measured, tracked, and improved data quality management KPI’s to reach a achieve a 95% customer satisfaction rating, to streamlining processes to make them offshorable Digital Process Specialist January 2017 – March 2017

Retrieved SQL data from multi-billion-dollar ad campaigns across Facebook, Google, and third party ad providers

Cleaned, modified, analyzed and presented DoubleClick data in Tableau to internal and external stakeholders to help troubleshoot data discrepancies

YouTube Inventory Analyst March 2017 – Current

Analyze YouTube content for ad targeting, addressing concerns of advertisers seeing their ads alongside sensitive topics Traffik Online (Award-winning full-service advertising agency) [Temporary Assignment] Irvine, CA Marketing Intern promoted to Marketing Analyst promoted to Marketing Analytics Manager May 2016 – October 2016

In charge of a $4 million budget for the agency’s biggest client

Executed sophisticated quantitative analyses and advanced modeling which increased cross-channel leads by 46 % while reducing the cost per lead by 73% through identification of low converting marketing assets (email lists, Facebook and Google ads, marketing channels, and ineffective calls-to-action)

Analyzed research data and synthesized raw information into insights and recommendations for Facebook, Instagram and Google PPC, remarket, prospect email, and direct mail campaigns

Communicated findings of A/B tests, analyses, and optimization efforts to the senior leadership and creative team

Developed strategies based on synthesized insights, presented recommendations using dashboards and reports Nike, Inc. Berlin, Germany

Converse Marketing Intern February 2015 – June 2015

$3.15 million marketing campaign “Made by You”: Exclusive contact person for five global marketing agencies to create marketing material and Facebook & Instagram content, coordination of brand focus groups

$4.5 million product launch campaign “Chuck II”: Press releases and press events for product launch and trade shows Lovoo (Online Dating App & Competitor of Tinder) Dresden, Germany Marketing Analytics Intern April 2014 – August 2014

Researched and analyzed key business drivers, competitive environment, opportunities, trends, and performance of operating metrics in a daily, weekly, and monthly report assessing the utilization of the $12 million marketing budget

Reported on Facebook, Google PPC ads, and app downloads, directly addressing the CEO, CMO, and COO APP, Inc. (Supplier of i. a. Lamborghini, Boeing, NASA) Santa Ana, CA Marketing Intern promoted to Marketing Coordinator March 2013 – September 2013

Organized meetings with marketing agencies, point of contact between media requests and internal stakeholders YouTube Creator and Partner (Channel: Lucid Layla) San Jose, CA

Lifetime achievements: Over 800 subscribers and 667,000 views April 2007- Current Cert i f icates

YouTube Certified - Content Strategy -

Exclusive Brand Partner Program, 2017-2018

Google AdWords Display, 2017-2018

Google AdWords Search, 2017-2018

Bus iness Ski l ls

Quantitative and qualitative research

Marketing strategy and optimization

Project management

Online advertising

Quant i tat ive Research Ski l ls

Descriptive statistics, data visualization, hypothesis testing, sampling, survey design, execution and analysis, focus groups, content analysis, quasi-experiments, regression analysis, (M)ANOVA, t-testing, chi-square, General Linear Modeling

Data Anal ys is Tools

SPSS, Tableau, Microsoft Excel (vlookup, pivot tables, graphs, formulas), SQL IT Ski l ls

Microsoft Word, Excel, PowerPoint, Outlook, Adobe Photoshop, Adobe Premiere Pro, Adobe InDesign

Facebook Ads Manager, Facebook Insights, Facebook Power Editor, YouTube Insights, Google Analytics, Google AdWords, DoubleClick, diverse BI tools

Languages

German (Native), English (Fluent), French (Professional Working Proficiency)

Contact this candidate