The Vibe Analytics Guide for CMOs

Discover 10 prompts to surface Marketing insights with Rows. From website traffic reports to analyzing campaign performance and monitoring SEO rankings.

Discover more

Explore more in our YouTube playlist on Marketing use cases.

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: 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 the 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 other events 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.
Workflow tip: Ask to create a bucket column for position and monitor the number of keywords by bin. Add the Page dimension to identify SEO low-hanging fruits, e.g. pages in position 4-10. Compare quarter-over-quarter to spot trends. Check also our Keyword Ranking template

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.

Prompt tip: Make the ranges suitable to highlight SEO low-hanging fruits, like keywords or pages ranking in 1st page (4-10).
Workflow tip: Ask then to plot them on a bar chart and monitor how the distribution changes month-on-month. Ask AI to highlight improvements month-over-month. Boost your Keywords research with our Keywords Research tool.

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'.

Prompt tip: Use content themes or categories relevant to your business. Try monitoring product pages, landing pages, or specific topic clusters.
Workflow tip: Ask to add comparison to last 30 days and keep it monitored month-on-month. Check also our Content Grouping Tool.

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 @LinkedIn Ads tables to summarize the weekly trend of cost-per-conversion.

Prompt tip: Include multiple channels like LinkedIn Ads, TikTok Ads, or Twitter Ads for a complete cross-channel analysis. Be specific on the event you want to compare and - in case of different naming - provide a clear mapping in the prompt.
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: Set up automated alerts to Slack for keyword performance drops. Check also our Google Ads Keywords template.

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: Be specific on the event you want to measure the conversion for.
Workflow tip: Go deeper by asking for device-specific metrics like most common brand, screen resolutions, and OS.

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: Add more social media platforms using @ mentions. Schedule weekly refreshes to have new data every Monday.

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 key dimensions aggregations and charts.
Workflow tip: Ask follow up questions to break tables further down and re-organize the layout for better readability.

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 other manipulation, including executing Python scripts.

🎥 Watch it in action: