Bank Ad Intelligence is a fully automated competitive intelligence platform for banking advertisements. It collects public ads, extracts text with AI OCR, classifies them into product categories, and publishes live Tableau Cloud dashboards, complemented by Slack alerts.
The project was inspired by a real-world problem: many bank marketing teams still monitor competitors manually — spreadsheets, screenshots, folders of images. This leads to slow and delayed insights. I wanted to build a solution that turns this messy process into a clean, automated pipeline.
🚀 How I built it
The solution consists of several components working together:
SerpAPI → collects public ads from Google Ads Transparency Center Python pipeline → orchestrates the full workflow OpenAI OCR → extracts visible text from ad images AI text classification → maps ads to product categories Tableau Hyper API → generates the .hyper data source Tableau Server Client API → publishes to Tableau Cloud Slack Webhooks → sends automatic alerts with key insights
The final result is an interactive Tableau dashboard where users can explore ad activity by bank, time period, and product theme.
📚 What I learned
During the project I learned:
how to automate Tableau Cloud publishing workflows how to work with the Hyper API and build data sources programmatically how OCR behaves with marketing creatives and noisy backgrounds how to design dashboards optimized for competitive analysis how to connect analytics with actionable alerts through Slack
🧩 Challenges I faced
Some of the challenges included:
cleaning noisy OCR output from busy ad images correctly classifying short marketing texts into product categories handling API limits and ensuring stable data collection building a reusable and scalable pipeline architecture designing simple but informative visualizations for business users
🏁 Result
The result is an enterprise-style automated workflow:
no manual data collection always-fresh Tableau dashboards instant Slack notifications scalable to new markets and industries It transforms public ad data into actionable competitive insights.
Log in or sign up for Devpost to join the conversation.