Andy Yan

Background

About Andy Yan

With over 8 years of experience in data analysis, marketing, and e-commerce, I am a marketing operations analyst at Google, where I help businesses achieve their goals by developing and implementing data-driven strategies. I led a project that evaluated the internal exception request process for ad sellers, resulting in significant resource savings and operational efficiency. I also expertly crafted quarterly and annual sales reports using SQL and Sheets, delivering data-driven recommendations that reduced non-compliance rates. Additionally, I volunteered as a data analyst for a social enterprise, where I conducted return analysis, customer behavior analysis, and return prediction using Python and Tableau, devising targeted solutions that boosted repurchase rates and extended customer lifetime value. I am skillful in data manipulation, visualization, and hypothesis testing, as well as in marketing automation platforms, such as Facebook Ads Manager and Google Analytics. I am passionate about using data intelligence to optimize marketing campaigns, improve customer satisfaction, and drive revenue growth. I am always eager to learn new tools and techniques to enhance my skills and deliver value to my clients and stakeholders.