AdIntel AI 🧠📊

AdIntel AI is a premium growth analytics and AI optimization platform designed to analyze Google Ads performance reports and generate high-impact growth strategies. Powered by Streamlit, Pandas, Plotly, and the Gemini API, the application looks and feels like a modern B2B SaaS dashboard.

🚀 Key Features

1. Intelligent CSV Upload: Auto-detects and processes standard Google Ads CSV export columns (Spend, Conversions, CPA, ROAS, CPC, CTR, Impression Share, Devices, etc.). Includes instant Demo Data loading for frictionless testing.
2. Interactive Visual Dashboard: High-impact Plotly visualizations including:
   • Spend and Conversion trends
   • Campaign Efficiency Matrices (scatter chart of CPC vs. Conversions)
   • Wasted Spend and High-CPA warning lists
   • Device and Impression Share analysis
3. AI Insight Engine (Gemini 2.5):
   • Insight Prioritization: Standardized ranking (🔴 High Impact, 🟡 Medium Impact, 🟢 Optimization Opportunity).
   • Estimated Opportunity Loss: Rule-based & LLM calculations demonstrating where dollars are wasted (e.g. "Campaign X is wasting ~$2,300/month").
   • Top 5 Immediate Actions: High-priority checklist outlining exact immediate steps to stop the bleed and scale wins.
   • Full Executive Strategy: Sounding like a top-tier performances marketing partner.
4. AI AdIntel Chat Assistant: An interactive context-aware chatbot that keeps memory and answers queries directly about your campaign data (e.g. "Which campaigns should I pause?", "Where is my budget wasted?").
5. Bonus Executive PDF Export: Generate a beautifully formatted performance audit PDF on-demand to share with stakeholders or clients.

---

🛠️ Tech Stack

• Frontend: Streamlit
• AI Core: Gemini API via Google Generative AI SDK (gemini-2.5-flash)
• Data Engineering: Pandas
• Visualization: Plotly
• PDF Generation: ReportLab
• Styling: Injected CSS (Vanilla CSS) for a sleek, glassmorphic dark-mode appearance with premium fonts and styling tokens.

---

💻 Local Installation & Setup

1. Prerequisites

• Python 3.9 - 3.11 installed.

2. Clone/Move to Project Directory

Navigate to the project root:

cd adintel-ai

3. Install Dependencies

pip install -r requirements.txt

4. Setup Environment Variables

Copy .env.example to .env and fill in your Gemini API key:

cp .env.example .env

Open .env and add your key:

GEMINI_API_KEY=AIzaSy...

Note: You can also paste your Gemini API key directly into the Streamlit sidebar at runtime if you do not want to set environment variables.

5. Launch the Application

streamlit run app.py

The app will automatically open in your browser at http://localhost:8501.

---

📁 File Structure

adintel-ai/
├── .env.example
├── .gitignore
├── README.md
├── app.py                     # Main Streamlit application
├── requirements.txt           # Python dependencies
├── components/
│   ├── __init__.py
│   ├── chat_interface.py      # AI Chat assistant interface
│   └── dashboard.py           # Dashboard visualizations and metric grids
├── services/
│   ├── __init__.py
│   └── gemini_service.py      # Gemini API integrations and prompting
├── styles/
│   └── main_css.py            # Elegant CSS styling tokens
└── utils/
    ├── __init__.py
    └── data_processor.py      # CSV parser, dummy generator, anomaly detector