Using TeamAI to Analyze Revenue Data for SEO Optimizations and Content Ideas

Posted by: Melissa Shoff Date Posted: July 29, 2025
Back to Case Studies

Issue

Our CRM integration features a lot of additional fields of data that we can use to slice and dice things. This includes the client’s product/service which we sync back as the RCFX deal itemname.

Now that we have the data, the question became, “how can we use to for SEO optimization and content ideas?”

Solution

We set up a custom Looker report for Centrak where we capture all the RevenueCloudFX deals data along with the additional field that aren’t filterable in the AnalyticsFX reports including the product/service which is synced as the RCFX itemname (ss).

We pulled an export where the created date was within 6/1/2024-6/30/2025 for all deal data. We then navigated to TeamAI and uploaded this spreadsheet along with special prompting and an ongoing conversation to help the AI better understand what data was in the spreadsheet along with what the goals of our SEO work included. 

Achievement

Using the export from the custom Looker report along with TeamAI, we were able to identify our underperforming products/services based on revenue data and ask it to crawl the site to recommend new and additional content ideas for each underperforming area (ss1, ss2, ss3, ss4).

We then paired this data with Google Trend and Search Console data to identify possible title tag and meta descriptions that would entice a potential customer to click through from the SERPs for these campaigns. We asked for a few different options to do some A/B testing (ss)!

We also used this conversation with TeamAI as a baseline for CTA optimizations (ss)!

Snippet/Screenshot/Link