This technical case study explores how advertising teams can move beyond static dashboards to conversational analytics. It demonstrates how to integrate structured ad performance metrics with unstructured campaign materials using a multi-tool Retrieval-Augmented Generation (RAG) approach. Built on the Databricks Lakehouse and powered by Mosaic AI, the “Advertising Intelligence Agent” delivers contextual insights, predictive analysis, and natural-language responses. The paper details the system’s architecture, governance, AI tooling, and deployment, illustrating how unified data and intelligent automation drive faster, more strategic marketing decisions.