Marketing Stack
Tanmay Debnath
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.
Like this project
Posted Jul 11, 2024
Integrated marketing stack: SQL extracts Google Analytics, FB Business Manager data into Salesforce for Python processing, visualized with Power BI
