Andy Bickerton Email & Phone Number

Washington D.C. Metro Area

- Created a rotational program for desks in the newsroom where analysts consult on digital strategy by providing recommendations on SEO, story pitches, publishing times, and headlines. Successfully increased traffic to Business desk stories by 71% during a six week embed by leveraging best digital practices.- Developed business-critical dashboards in Looker Studio. Led the creation of a new content analytics dashboard for NPR’s newsroom, increasing monthly active dashboard users by 200+. This dashboard now serves as NPR’s central store of insight about editorial performance and drives decision-making on content at every level of the organization.- Optimized a portfolio of analytics tools by consolidating an assortment of 100+ dashboards across five different platforms into 50 streamlined dashboards in Looker Studio. - Streamlined ETL processes in Google BigQuery, standardized dashboard templates in Looker Studio, and identified key business needs to provide the most lean, inexpensive, and actionable suite of analytics tools possible. Cut down monthly query fees by approximately 15% and eliminated two hours of maintenance work per week.- Recommended KPIs and benchmarks that drove strategy. Established the first set of digital KPIs ever used by editorial leadership to evaluate the performance of the newsroom’s digital strategy. - Built the data pipeline for newsroom benchmarks and incorporated them into a suite of reporting that every desk and newsroom manager receives on a weekly and monthly basis.

Greater Boston Area

- Building new editorial analytics products: created a new scoring system to measure the business and mission impact of content using multiple regression modeling in R and editorial feedback. This scored analytical report, which is calculated and consolidated using Visual Basic (VBA), is reviewed weekly by business and editorial leadership.- Design analytical processes that drive product decisions: created a new process for conducting opportunity sizing, developing measurement plans, managing analytics implementation, and reporting results to stakeholders for the Monitor’s product managers and senior leadership. - Lead A|B testing: manage the Monitor’s A/B testing regimen in concert with an external vendor and other analytics staffers. Results include a lift in subscription offer page conversion rate of 25%.- Building analytics reporting: design and develop dashboards and reporting for editorial and marketing, informing decisions on copy, content marketing, and channel optimization.

- Set business goals in coordination with senior managers: set targets for product portfolio by projecting fiscal year expense budgets and calculating quarterly revenue benchmarks. - Product analysis: Worked with senior managers on product performance analysis. Among other contributions, this work lead to the sunset B2B product, saving 5% of total fiscal year expense budget.- Business development: Managed and developed content licensing and syndication business, directly responsible for increasing revenue by 5% in fiscal year 2016.

Boston

- Proficient drummer with 5000+ hours of practice, 4 album releases, 6 working bands, and 250+ live performances.- Career in scoring radio and film documentaries: composed and engineered music for multiple BBC World Service podcasts including “The Resurrection Men”, “The Colony”, and “Pig Pen”.

Greater Boston Area

- Budget planning: led fiscal year budgeting process and long range planning with senior management.- Ad hoc analysis: responsible for providing variance analysis, explaining differences in actual and planned behavior to senior management.- Cost accounting: created a new activity based costing methodology for accurately gathering the costs of international activity across the organization using Microsoft Access (SQL).

Bachelors, Business Administration

Activities and Societies: LOCK Honorary Society, Educational Resource CenterBoston University Collaborative Degree Program B.S.B.A..

Bachelors, International Relations

Activities and Societies: Educational Resource CenterCollege of Arts & Sciences Boston University Collaborative Degree Program B.A..