Media Analyst
CurrentClient: Pearson• Utilized Excel formulas and pivot tables to analyze large data sets, effectively formatting spreadsheets for presentation and review and facilitating data-driven decision-making and strategic planning.• Provided weekly report insights, resulting in improved efficiency and successful campaign outcomes.• Contributed to the successful execution of multiple campaigns across various platforms, including Google, Meta, Trade Desk, TikTok, YouTube, and LinkedIn.•… Show more Client: Pearson• Utilized Excel formulas and pivot tables to analyze large data sets, effectively formatting spreadsheets for presentation and review and facilitating data-driven decision-making and strategic planning.• Provided weekly report insights, resulting in improved efficiency and successful campaign outcomes.• Contributed to the successful execution of multiple campaigns across various platforms, including Google, Meta, Trade Desk, TikTok, YouTube, and LinkedIn.• Managed accurate budget pacing, resulting in over 99.5% pacing on the client's campaign budget for five consecutive months, optimizing resource allocation.•Analyzed weekly KPIs using Excel formulas and pivot tables in accordance with the budget pacing, monitoring effectiveness to ensure efficient use of the budget.•Maximized campaign success through cross-functional collaboration with creative and strategy teams.•Prepared monthly authorization for the media department budget with 100% accuracy, ensuring efficient financial planning and allocation. Show less
