How I Turn Raw Marketing Data Into Insights in Minutes Using Coefficient
Turn messy, disconnected spreadsheets into real-time dashboards and insights — without formulas, code, or manual reporting.
I used to spend way too much time in spreadsheets. Between pulling reports, fixing broken formulas, and cleaning up fields that should’ve been standardized months ago, it could have been a full-time job. And by the time everything finally looked right, it was already outdated.
I’m a big proponent of marketing leaders being data literate, but often that meant they spent a lot of time in spreadsheets.
But this week’s episode is about fixing that.
Because Coefficient does for data and spreadsheets what Gamma and Loveable do for design.
This week’s stack:
1 video: Turn messy marketing data into clean, automated dashboards
1 prompt: Create scroll-stopping infographics with AI
1 tool: Run any tool directly from your terminal with AI
3 resources: Personal AI systems, real-world workflows, pricing strategy
3 jobs: High-paying growth roles at AI-native companies
Let’s go!
Workflow Walkthrough: Turn Messy Marketing Data Into Real Insights (Fast)
If you’re still exporting CSVs, cleaning columns, and rebuilding dashboards every week… this one’s for you.
I walk through how I’m using Coefficient to turn scattered marketing data into clean, automated, insight-ready dashboards.
Instead of writing formulas and doing pivot tables, you’re asking questions and giving commands in plain English.
Here’s what you’ll learn:
How to connect HubSpot, GA, ads, and more into one live data source
How to clean and structure messy data using natural language
How to generate formulas, pivots, and analysis with AI
How to build dashboards and reports in minutes (not hours)
How to automate snapshots, alerts, and weekly reporting
Now, your spreadsheets become a live, AI-powered system.
Prompt of the Week: Turn Raw Ideas Into Scroll-Stopping Infographics
Unless you have a full time designer, visuals can be tough. But now with AI, you don’t need a designer or hours in Figma – you just need a clear structure and the right prompt.
Lately, I’ve been using Nano Banana 2 to turn notes and my rough ideas into clean infographics.
And yes, it’s with a prompt, just tell it exactly what to say, who it’s for, and how it should look.
Here’s a prompt you can steal:
Create a clean, modern infographic designed for B2B SaaS marketers.
Topic: [INSERT TOPIC]
Goal: Teach this concept quickly and clearly in a way that is visually engaging and easy to scan.
Structure:
- A strong, benefit-driven headline at the top
- 3–5 key sections or steps, each with a short bold title and 1–2 concise supporting lines
- Use simple icons or visual cues to represent each section
- Include a clear flow (top-to-bottom or left-to-right)
Style:
- Minimalist and modern (inspired by SaaS dashboards)
- Plenty of white space
- Clean typography (no clutter)
- Subtle color palette (1–2 primary colors max)
- Designed for LinkedIn or newsletter sharing
Tone:
- Clear, practical, and slightly punchy
- No fluff, no jargon
Optional:
- Add a short “Key Takeaway” or summary at the bottom
Make sure the final output feels like something a high-growth SaaS company would publish.Tool of the Week: Run AI From Your Terminal (No UI Required)
Most AI tools live in tabs, most of which get lost in your endless sea of tabs (if you’re anything like me).
But this one lives where you actually work. OpenCLI brings AI directly into your terminal, so you can generate content, run tasks, and automate workflows without ever leaving the command line.
I think CLIs are the future, even more so than MCPs, which is why I had to share this with you.
Install this in Claude Code, and thank me later :)
Try it: https://github.com/jackwener/opencli
AI Resource Roundup
Personal AI Infrastructure Guide: This is a deep one, but worth the time. It walks through how to set up AI as your personal assistant across your entire digital life, from workflows to memory to automation. If you’re serious about building leverage with AI, this is a blueprint.
Your Team Will Only Build What They Believe AI Can Do (Liza Adams on LinkedIn): A strong mindset piece on how leadership assumptions shape what teams actually build with AI. If you want better outputs, raise the ceiling on what you think is possible.
The Usage-Based Pricing Playbook (Mostly Growth Podcast Episode): A great listen if you’re thinking about monetization and packaging in an AI-first world. Breaks down how usage-based pricing works, when to use it, and how it impacts growth, especially relevant for SaaS marketers.
Hot AI Roles
Growth Operations Lead at David AI
City / Remote: San Francisco, CA (On-site)
Pay Range: $120K–$180K
Marketing Role at OpenAI
City / Remote: San Francisco; New York City (Hybrid)
Pay Range: $239K – $265K
Growth / GTM Role at Overview AI
City / Remote: San Francisco, CO (Hybrid)
Pay Range: Not listed
That’s it for this week, appreciate you being here and reading along.
Next week, I’m going deep on Claude Code and breaking down my favorite skills, connectors, and workflows that are actually useful day-to-day. It’s a good one, so stay tuned.
Until then, keep building.
– Brandon
You keep dropping hits!