📊 Google Ads Performance Analyzer

A Python-based analytics dashboard that simulates Google Ads campaign data, stores it in PostgreSQL, and visualizes performance insights via Streamlit.

🛠️ Tech Stack

• Python — Data generation, analysis, API
• PostgreSQL — Campaign data storage and SQL querying
• Streamlit + Plotly — Interactive dashboard
• Flask — REST API endpoints

📁 Project Structure

google-ads-analyzer/
├── db/
│   ├── schema.sql        # Table definitions
│   └── queries.sql       # SQL analysis queries
├── data/
│   └── mock_data.py      # Mock data generator
├── api/
│   └── app.py            # Flask REST API
├── dashboard/
│   └── streamlit_app.py  # Streamlit dashboard
├── requirements.txt
└── README.md

🚀 How to Run

1. Setup PostgreSQL

CREATE DATABASE google_ads_analyzer;

2. Install dependencies

pip install -r requirements.txt

3. Generate mock data

python data/mock_data.py

4. Run the dashboard

streamlit run dashboard/streamlit_app.py

5. Run the API

python api/app.py

🔌 API Endpoints

Endpoint	Description
GET /api/campaigns	Returns all campaigns
GET /api/metrics?campaign_id=1	Returns metrics for a specific campaign

📊 Dashboard Sections

• Campaign CTR Analysis — Compare click-through rates across campaigns
• Daily Spend Trend — 30-day spend visualization
• Cost per Conversion — Identify underperforming campaigns
• Conversion Rate — Distribution across all campaigns

📌 Note

This project uses simulated data designed to mirror real Google Ads campaign metrics. Built as part of Google PSE role preparation.