Marketing Stack

Step 1: Data Extraction

- Used SQL for Google Analytics and Facebook Business Manager APIs to collect data on website metrics, advertising performance, and audience engagement.

Step 2: Data Storage

- All extracted data is stored in Salesforce, ensuring a centralized repository for customer data and marketing analytics.

Step 3: Data Processing

- Python scripts utilize OLS models to analyze sales attributions across different marketing channels.

- OLS models help identify optimal marketing spends, assess channel effectiveness, and detect saturation points.

Step 4: Data Visualization

- Processed data and OLS model outputs are visualized in Power BI.

- Power BI creates interactive dashboards and reports showcasing attribution insights, campaign performance trends, and customer behavior analysis.