Over the past few months, we've been sharing insights from our company-wide AI contest, where employees submitted videos showcasing how they use artificial intelligence to enhance their daily work. From creative design solutions to automated email discovery, our team has demonstrated remarkable innovation in applying AI tools. Today, we're excited to share the fifth and final entry in this series, featuring a powerful approach to data analysis that anyone can implement.
Making Data Analysis Accessible to Everyone
Brianne, a Sr. Software Developer and Data Analyst at Horizon2Media, has discovered a game-changing approach to revenue monitoring using Google Sheets and AI. In this example, she focuses on identifying offer campaigns that have decreased in EPC (earnings per click) by more than 5% compared to previous weeks – crucial intelligence for maintaining campaign performance.
Her approach centers on Google Sheets' embedded Gemini AI tool, which has recently been enhanced with improved analytical capabilities.
The process is remarkably straightforward: pull your dataset into Google Sheets, utilize the "Analyze this data" option within Google Sheets, and craft specific prompts that outline your objectives to receive the results you want. Prior to analyzing the data, Brianne emphasizes the importance of comprehensive data collection. Pulling more information than the specific two weeks you’re looking at enables deeper historical analysis when questions arise. "Most times I find that Gemini's initial analysis does not give me what I'm looking for, which is why the next important step is to put together a prompt to explain your data analysis objective and what you want the AI tool to return for you," Brianne explains.
Her secret weapon? Highly specific prompts that can be saved and reused. By creating detailed prompts that specify exact date ranges, calculation formulas, and output formats, she can reproduce weekly performance reviews by simply updating the date ranges given within the prompt.
What makes Brianne’s approach stand out is its accessibility and efficiency. Using Google Sheets paired with Gemini AI, she demonstrates how employees at any skill level can analyze revenue trends and campaign performance without relying on technical support. “With the right dataset and a clearly defined prompt, anyone can dig into the numbers and get the insights they need,” she explains. While she has the expertise to build custom reports as a senior developer, Brianne emphasizes the speed and flexibility AI brings to certain use cases.
By leveraging AI inside a familiar tool like Google Sheets, she highlights how advanced analytics can be democratized across the company, reducing the need for complex coding or time-consuming report generation.
This concludes our AI contest blog series. Check out our previous entries: Blog 1: Removing the Clutter, Elevating the Creativity and Blog 2: From Research to Automation .
