Collin Marchese

In addition to Data Analyst Responsibilities: • Mentor and train all new Data Analysts upon hiring. • Conduct cross-departmental trainings on capabilities and methods of analytics-related programs/topics. (Previous trainings include: Alteryx, Google Analytics, Linear Regression, Indirect Attribution, Qlik Sense) • Head analyst for larger clientele including Veritone Inc. & Veritone One marketing campaigns. • Lead analytics onboarding calls with new advertising clients to determine scope of analytic

Analytics lead to over 40+ direct response advertising campaigns during tenure, managing 14+ campaigns simultaneously, each with unique attribution models. • Work with clients directly to develop and recommend appropriate attribution model based on specific marketing media channels, KPIs, and goals. • Build APIs as well as SQL statements to ingest/join millions of records of data from multiple sources. • Build custom workflows and macros to cleanse and analyze data to track performance of advertising campaigns using ETL tool Alteryx. (Alteryx Core Certified) • Perform analyses such as (Regression, Lift, Customer Profiling, Direct Tracking, Indirect attribution modeling) to provide the client and internal teams actionable insights to improve campaign efficiency & increase response. • Develop and build custom performance reporting dashboards in QLIK Sense for each advertising campaign.

• Coordination and implementation of Local Radio, National Radio, Podcast, YouTube, and Digital advertising campaigns to over-achieve client goals & expectations. • Provide support and recommendations to internal strategy, creative, analytics, and buying teams. • Constant communication with local/national/podcast/YouTube networks.

• Liaison between Nissan North America and Omnicom media buyers in 50+ markets nationwide, contributing to over $200 million in advertising spending annually. • Observe the media landscape and schedule advertising based on client’s budget, target, and instruction. • Advise on approval of programmed schedule changes daily for LA, SF, and Phoenix TV and Radio.

Manage contest winner folders and inventory prizes, Work events for clients and stations, Assist Promotion coordinators, administrative tasks. Promo suite proficient.

Assistant to four university housing coordinators. Responsibilities included doing research, contacting different departments, typing up projects, and creatively developing housing projects. Import and oversee electronic data as well as paper files during large housing projects consisting of over 200 persons.

Assist Marketing coordinators and the director of marketing in development and implementation of strategic marketing strategies for 18+ different music artists. Track artist progress via social media websites as well as Nielsen Soundscan.

Assist Account executives, Administrative tasks. Research possible clients, Use of Arbitron to locate target audiences. Create event recaps, Many powerpoint, excel, and word projects. Write airtime orders.