The Vibe Analytics Guide for CMOs

Build A Website Traffic Report

Ask AI to create a standard GA4 Website Traffic Report — no setup needed.

💡 Example prompt: Create a standard GA4 Website Traffic report.

• Prompt tip: Be specific about the timeframe you need, e.g., "last 30 days" or "this quarter vs last quarter."
• Workflow tip: Connect to Google Analytics 4 using @ mentions. Schedule a weekly refresh to keep your traffic data always up-to-date.

Find Top Performing Source / Medium

Ask the AI Analyst to display which source/medium brought the most signups in the last 30 days. It will automatically connect yo

💡 Example prompt: Which source/medium brought most signups in the last 30 days? How does it compare with previous?

• Prompt tip: Define your key conversion events — signups, purchases, demo requests — to focus the analysis on what matters most.
• Workflow tip: Ask AI to add attribution data and create a funnel analysis showing how different sources convert through your customer journey.

List Top Unbranded Keywords By Traffic

Ask AI to pull the performance of the top 50 unbranded keywords by traffic in the last 90 days.

💡 Example prompt: Get top 50 unbranded keywords from @Google Search Console by traffic. My brand is 'rows', often spelled 'row'.

• Prompt tip: Clearly define your brand terms and common misspellings to ensure accurate filtering. Ask for additional metrics like CTR and average position.
• Workflow tip: Use this data to identify content opportunities and track organic visibility for non-branded searches. Compare quarter-over-quarter to spot trends.

Plot # Of Keywords By Position Range

Ask AI to classify each keyword by position range and plot them on bar chart.

💡 Example prompt: Add a column with position range (1-3, 4-10, 11-20, 20+) to the table @Top Keywords and plot # keywords by range on a bar chart.

• Prompt tip: Customize the position ranges based on your SEO strategy. Add more granular buckets like "1", "2-3", "4-6" for top positions.
• Workflow tip: Use this with Google Search Console data to track keyword distribution trends over time. Ask AI to highlight improvements month-over-month.

Monitor Content Buckets Over Time

Ask AI to pull organic data about specific pages of your website and compare it to previous 30 days.

💡 Example prompt: Get the organic performance of all pages of by blog containing 'chatgpt' and add comparison to last 30 days.

• Prompt tip: Use content themes or categories relevant to your business. Try monitoring product pages, landing pages, or specific topic clusters.
• Workflow tip: Connect to Google Search Console and set up a daily or weekly refresh to track trending content buckets automatically.

Compare Cost Per Lead Across Channels

Ask AI to compare two channels conversion performance and summarize the weekly trend.

💡 Example prompt: Use @Google Ads and @Facebook Ads tables to summarize the weekly trend of cost-per-lead.

• Prompt tip: Include multiple channels like LinkedIn Ads, TikTok Ads, or Twitter Ads for a complete cross-channel analysis.
• Workflow tip: Ask AI to create a chart showing the trend over time and flag weeks where CPL exceeded your target threshold.

Highlight Google Ads Keywords

Ask AI to highlight underperforming keywords from Google Ads.

💡 Example prompt: Pull keywords from @Google Ads and highlight the underperforming ones in the last 90 days.

• Prompt tip: Define what "underperforming" means for your campaigns — low CTR, high CPC, or low conversion rate. Be specific in your criteria.
• Workflow tip: Combine this with a separate analysis of top-performing keywords to identify reallocation opportunities. Set up automated alerts for keyword performance drops.

Check Performance From Mobile

Ask AI to show conversion rate by device.

💡 Example prompt: What's our conversion rate by device? Pick last 3 month data from @Google Analytics 4.

• Prompt tip: Go deeper by asking for device-specific metrics like bounce rate, session duration, or pages per session to understand mobile UX issues.
• Workflow tip: Create a monthly dashboard comparing mobile vs desktop performance across key conversion metrics.

Calculate Blended CPA For Campaigns

Ask AI to display blended CPA across multiple campaigns.

💡 Example prompt: Use data from @Facebook Ads and @Instagram Ads to compute the avg blended CPA across all campaigns.

• Prompt tip: Include all active ad platforms to get a true blended CPA. Specify the time period and campaign types to include or exclude.
• Workflow tip: Combine this with your revenue data to calculate overall ROAS and profitability by channel mix.

Build A Multi-Channel Report

Ask AI to build a comprehensive report of one or multiple ads channel.

💡 Example prompt: Do a report of the performance of my Tiktok and IG channels in the last 3 months.

• Prompt tip: Specify the metrics that matter most to your business: impressions, engagement rate, reach, clicks, conversions, and spend.
• Workflow tip: Connect to multiple social media platforms using @ mentions. Schedule monthly reports that automatically compare period-over-period performance.

Prepare Client-Ready Report

Ask AI to prepare a client-ready report to assess its marketing effort.

💡 Example prompt: Prepare a client-ready performance report using data from @GA4 and @LinkedIn Ads.

• Prompt tip: Specify the format you need — executive summary, detailed metrics, charts, or all of the above. Include client KPIs and benchmarks.
• Workflow tip: Create a template report that AI can populate with fresh data on demand. Add context like goals, insights, and recommendations for stakeholders.

Try It in Rows

All these workflows can be done directly by clicking the AI Analyst bubble in the bottom-right corner inside Rows.

Discover more on our YouTube playlist dedicated to Marketing use cases.

You can also connect integrations and perform any data manipulation, including executing Python scripts.

🎥 Watch it in action: