Led the initiative to develop Ideal Customer Profile, Industry, and Funnel analyses, optimizing marketing strategies for targeted industries and customer segments, leading to an 85% boost in conversion rates.
Executed a comprehensive standardization of approximately 9,000 job titles using SQL for LinkedIn’s Ad targeting.
Pioneered the development of the first-ever Partner List using Sisense, showcasing users with Partner, Brand, and Business Admin Access, streamlining CRM efforts by 40% and leading to significant cost savings by retiring ActiveCampaign subscription.
Introduced and implemented Bombora for targeted sales outreach.
Designed and implemented a UTM Builder tool to enhance campaign tracking and analysis capabilities.
Leveraged Marketo snippets to standardize and localize email signatures, ensuring consistency and professionalism in communication.
Integrated review platforms into Slack channels to facilitate efficient communication of critical updates and notifications.
Data Analysis of Olist: an E-Commerce Platform in Brazil
Findings and Courses of Action
Found a sudden drop of 128% in processing and delivery turnaround times starting Q3 of 2018. Revisit the delivery process to identify factors affecting longer timeframes and address issues on late deliveries.
Identified sellers with more than 30% bad reviews. Conduct interventions but provide for in-depth assessment since two of the identified sellers are top contributors to revenue in Olist.
Learned that the sudden peak on sales in Nov 2017 was due to the Black Friday Sale F