VideoAmp collaborated with AWS to develop a prototype of the VideoAmp Natural Language (NL) Analytics Chatbot using Amazon Bedrock for media analytics data analysis.
The AI solution included a natural language to SQL pipeline and an automated testing tool for analytics queries.
VideoAmp, a tech-first measurement company, uses AI to enhance measurement and optimization capabilities for TV, streaming, and digital media.
Their AI journey focuses on providing accurate audience insights, improving measurement, and optimizing ad campaigns in real-time.
VideoAmp is set to launch an AI analytics interface powered by generative AI to offer accessible insights through natural language queries.
The solution aimed to convert natural language questions to SQL, execute queries on performance metrics data, and provide natural language summaries.
Challenges included adapting large language models (LLMs) and developing an automated evaluation pipeline for accurate results.
Amazon Bedrock, with Anthropic’s Claude 3 LLMs, was used for the AI assistant, providing models for SQL generation and data summarization.
The solution connected to a data warehouse and supported various database connections, enhancing analytics capabilities.
The evaluation framework ensured high accuracy, low latency, and cost-effectiveness for user queries, meeting VideoAmp's expectations.