← Daily AI recipesBusiness✓ Verified Aug 7, 2026

Get A/B Test Content Insights from a Views Table in 5 Minutes

Upload data for two videos into ChatGPT and turn it into markup, a summary, and recommendations - no formulas or scripts needed

  1. 1.Collect your data in a single table: one row per video and channel. Minimum columns: channel, variant (A or B), views_48h, ctr, retention_avg, conversions. Save the file in CSV or XLSX format.

    If your data is in Google Sheets - menu File → Download → Comma Separated Values (.csv).

    Google Sheets ↗
  2. 2.Open ChatGPT and make sure GPT-4o or GPT-4o mini is selected - these have built-in Data Analysis that can read files.

    The model is selected from the dropdown to the left of the input field. If there is no dropdown - you're on the Free plan; GPT-4o mini is available without a subscription.

    ChatGPT ↗About this tool
  3. 3.Attach the file using the «+» button to the left of the input field, then paste the prompt below. Replace [goal] with a single business goal: for example, «increase watch-through rate» or «lower CPM».

    Do not upload files with viewers' personal data - only aggregated numbers.

    ChatGPT ↗About this tool
    Prompt
    You are a junior growth analyst. I am uploading one file: [file_name]. It contains A/B test results for two videos across two channels, ~2,765 views total over 48 hours. Do the following, in this exact order:

1. Markup: tag each row with a column `winner_flag` = 1 for the better-performing variant per metric (views_48h, ctr, retention_avg, conversions), 0 otherwise.
2. Summary table: one row per variant with mean values and a `delta_pct` vs the other variant for every metric.
3. Insight: in 3 bullets, explain which variant wins and why, referencing the numbers.
4. Recommendation: one concrete next action to reach the goal - [goal].
5. Output the marked-up table as a downloadable CSV so I can re-use it.

Do not invent numbers not present in the file.
    What this prompt doesThe prompt asks the AI to flag the winning variant, build a summary table with percentage differences, give three insights, and one recommendation tied to your business goal. Replace [file_name] with your file name and [goal] - with your goal.
  4. 4.Press the send button. In 30 - 90 seconds ChatGPT will return a text response and a CSV file. Download the file - this is your marked-up table, ready to import back into Google Sheets or your BI tool.

    If the response cuts off - click Continue, and generation will resume.

    ChatGPT ↗About this tool
  5. 5.Import the marked-up CSV back: in Google Sheets - File → Import → Upload, and replace the current sheet. Now you have a winner_flag column - use it in filters and pivot tables for future A/B iterations.

    To automate repetition: save the prompt from step 3 in a Google Doc and just change [goal] and [file_name] for each new test.

    Google Sheets ↗
💰 What it costs to followprices as of 2026-08
  • freeChatGPT Free (GPT-4o mini)File uploads and Data Analysis are available on the free plan with message limits.
  • subscriptionChatGPT PlusA paid subscription at $20 per month removes the limits and unlocks GPT-4o without strict caps - only needed for daily use.
  • freeGoogle SheetsFree for personal Google accounts, with no limitations for the scenario described.
Try it and be the first to check in

Why today

2
videos from creators in 48h
2
source channels
2.8K
total views
Борис опятьtelegramChannel in catalog
Георгий РивераyoutubeChannel in catalog

AI services change fast - interfaces and free limits may differ from what's described.