data Analysis TO DRIVE Marketing Strategies

Internal DASHBOARD

This is a dashboard for marketing team to performance monitoring, budget managing, and strategy optimization.

CLIENT-FACING DASHBOARD

This is a client-facing dashboard for delivering performance status and proposing marketing strategies.

Keyword/Content Strategies

This is an excel spreadsheet of how Ashley evaluates keyword quality scores based on different metrics and accordingly make recommendation on ad copy, landing page experience, and marketing account strategies.

DAta pipeline For marketing data

Data Quality Assurance

Tracking set-up is crucial for marketing data quality assurance. This example shows how Ashley assists with measurement hierarchy building and conversion tracking.

Database Enviornment

This is an example of SQL query that Ashley uses to aggregate marketing data from multiple-sources and store them in the data warehouse (Big Query, Google Ads Hub) or databases (Salesforce, Snowflake).

Predictive Analysis

These are my project of predictive analysis with Python scikit learn (NumPy, SciPy, and matplotlib) and Pandas libraries. I perform data cleaning and exploratory analysis; build liner predictive models and evaluate model fitting and effectiveness; and perform predictive analysis with linear regression, time series, random forest and KNN modeling.

PYTHON APPLICATION

An insurance quote application based on a linear regression predictive model. This project also utilizes scatter plots and heat maps to visualize the data and interpret the relationships among various subjects. The application has been deployed on Heroku, allowing the public to obtain insurance quotes based on their customized options.

Global Journalism and Digital Safety