Blog

Guides for agent-driven marketing data

Practical, terminal-first walkthroughs: connect Search Console, GA4, Meta Ads and Google Ads to Claude Code, ask real questions in SQL, and pin the answers as live dashboards.

Claude Code × marketing data

Claude Code for marketing: give your agent a real data backend

Connect every marketing source once, then ask cross-channel questions from your terminal — and pin the answers live.

Jul 17, 2026 · 9 min

Claude Code marketing skills: what they are and which to install

How skills teach your agent marketing workflows — and what a data-backend skill unlocks.

Jul 17, 2026

Connect Google Search Console to Claude and Claude Code: three ways

Google publishes no Search Console MCP server. Community MCP servers, vendor connectors, or synced SQL with the site totals that keep anonymized traffic.

Updated Sep 26, 2026 · 10 min

Claude Code analytics: turn your agent into a data analyst

Two altitudes of data, trust metadata, and the queries that make an agent's analysis dependable.

Jul 17, 2026

Claude Code dashboard: pin your agent's analysis to a live URL

From one-off answers to a public, read-only dashboard that refreshes itself.

Jul 17, 2026

Claude Code × Google Ads: analyze campaign spend from the CLI

Spend rankings, zero-conversion burners, and cross-platform ROAS without leaving the terminal.

Jul 17, 2026

Connect Google Analytics 4 to Claude (Code): three ways, and what each one is for

Google's read-only GA4 MCP server, vendor connectors, or a synced SQL backend — what each reads, what it can change, and what it costs.

Jul 20, 2026 · updated Sep 26 · 10 min

CSV analysis with Claude Code: from export to live dashboard

When pandas in the shell is enough, when it breaks, and how to load exports into definitions that last.

Jul 20, 2026 · 8 min

Chat with your data — without handing it to another model

Your agent as the conversation layer, a deterministic SQL engine underneath. $0 extra inference.

Jul 17, 2026

Claude Code MCP: when you need a server — and when a CLI beats it

What MCP is for, why CLI-native agents often don't need it, and where it genuinely wins.

Jul 17, 2026

How to use Claude for data analysis — without re-uploading every time

Where claude.ai file uploads hit their ceiling, and how a standing connection changes the workflow.

Jul 24, 2026 · 8 min

Claude BI: business intelligence where the agent is the interface

No chart builder, no BI seat — what the pattern looks like when it's real, and where classic BI still wins.

Aug 17, 2026 · 8 min
Reporting, without the grind

A client reporting tool your AI agent drives

One live link per client — connected to their sources, refreshed automatically, no monthly rebuild.

Jul 17, 2026

Agency reporting tool: live dashboards without per-seat fees

Agent-driven reporting scales by workspace, not by seat — the economics finally work.

Jul 17, 2026

Meta ads reporting without the spreadsheet grind

Skip the export-pivot loop: query Meta Ads live, compare against Google on one definition of ROAS.

Jul 17, 2026

Marketing report templates you can pin as live dashboards

Three copy-paste templates where the "template" is a set of SQL widgets — pinned once, live forever.

Jul 17, 2026

SEO dashboard: build one your agent maintains, in one command

The five questions a good SEO dashboard answers — and the SQL widgets that answer them, live.

Jul 17, 2026

Marketing dashboard: one live URL for every channel, no BI seat required

Unified definitions across Meta and Google, maintained by your agent instead of rotting in a BI tool.

Jul 17, 2026

A Google Search Console API alternative, for people who just want the data

Skip the OAuth, pagination and storage layers every GSC client ends up building — go straight to SQL.

Jul 24, 2026 · 9 min

PPC reporting tool: one live dashboard across Google Ads and Meta

What PPC reporting really has to solve, why cross-platform numbers disagree, and how to fix it on ingest.

Jul 27, 2026 · 9 min

Automated marketing reports: build it once, never rebuild it

Automate the whole chain — including the freshness gate that stops reports arriving on time and wrong.

Jul 27, 2026 · 9 min

Looker Studio alternatives: what to use when the rebuild stops being worth it

The connector tax, the spinner, the blend that lies — and which alternative actually fixes each one.

Aug 3, 2026 · 9 min

Marketing KPI dashboard: define the metrics once, then stop rebuilding

The seven KPIs worth a slot, one shared definition across four platforms, and a live URL that refreshes itself.

Aug 10, 2026 · 9 min

No Looker Studio connector for your source? The alternative path

Why the picker is really three catalogues, the four ways out, and the one that removes the per-source tax instead of relocating it.

Aug 31, 2026 · 8 min

Connect Google Search Console to Looker Studio — and what to do when it hits the wall

The real setup steps, the table-type choice that decides what you can ask, and the four walls every Search Console dashboard runs into.

Sep 14, 2026 · 9 min

How to connect Facebook Ads to Looker Studio — every route, and what each one costs

No native connector exists. The four routes that do, the honest price of the free ones, and the attribution window all of them get wrong.

Sep 14, 2026 · 9 min

Google Search Console to Power BI: every route in, and what each one costs

No native connector exists. The four workarounds that do, which ones survive a scheduled refresh, and the sharing bill nobody quotes you.

Sep 21, 2026 · 9 min

Google Ads to Power BI: the four routes in, and the one that survives a refresh schedule

API access, BigQuery transfers, and the three costs nobody prices: restating conversions, account currency and timezone, and a licence per viewer.

Sep 21, 2026 · 9 min

GA4 to Power BI: every route, what each one costs, and what each one gets wrong

Power BI reads GA4 natively, but Data API quotas, licences and thresholds bite. The native connector, BigQuery export, partner connectors and CSV, priced side by side.

Sep 26, 2026 · 14 min

Connect Google Search Console to Tableau: four routes, what each costs, and what each loses

Tableau has no Search Console connector. BigQuery bulk export, partner connectors, your own API script and the manual export — and what each one leaves out.

Sep 26, 2026 · 14 min

Power BI data sources for marketing: which have a native connector, and the route in for the rest

Power BI connects natively to GA4, Sheets and CSV — not Search Console, Google Ads, Meta, LinkedIn, TikTok, Microsoft Ads or Shopify. The route in for each.

Sep 26, 2026 · 13 min

Meta Ads (Facebook Ads) to Power BI: every route, what each costs, and where each breaks

No Facebook or Meta Ads connector ships with Power BI. Partner connectors, the Marketing API, BigQuery transfers and exports, priced.

Sep 26, 2026 · 18 min

GA4 to Tableau: every route, what each one costs, and what each one gets wrong

Tableau's own GA4 connector is extract-only and being deprecated. The connector, BigQuery export, partners and CSV, with the costs nobody quotes.

Sep 26, 2026 · 17 min

What is conversion value? How Google Ads and Meta calculate it, and why it is not your revenue

The value an ad platform credits to its own ads. How each platform sets it, and four reasons it runs higher than the revenue you banked.

Sep 30, 2026 · 6 min

Facebook Ads vs Google Ads: what each does best, and how to compare them without the platforms’ arithmetic

Demand capture against demand creation, why their ROAS cannot be compared as reported, and the comparison that works.

Sep 30, 2026 · 5 min

Power BI pricing in 2026: Free, Pro, Premium Per User and Fabric — and what sharing a report really costs

Pro at $14, PPU at $24, Fabric from $262.80 — and the rule that every viewer needs a licence below F64.

Sep 30, 2026 · 6 min

Tableau pricing in 2026: Creator, Explorer and Viewer licences, the editions, and what a team actually pays

$75, $42 and $15 on Standard, $115, $70 and $35 on Enterprise, billed annually — with three worked team budgets.

Sep 30, 2026 · 6 min

Power BI alternatives for marketing teams, matched to the reason you are leaving

No Mac app, a licence for every reader, no ad connectors — Looker Studio, Tableau, Databox, Metabase and TableBI against each.

Sep 30, 2026 · 7 min

Tableau alternatives for marketing teams: what two builders and ten readers cost elsewhere

$300 a month on Tableau Standard, $168 in Power BI, $0 in Looker Studio — and the ad-connector cost the seat price hides.

Sep 30, 2026 · 6 min

CPM vs CPC: paying per impression or per click is a bet on your click-through rate

CPC = CPM ÷ (1,000 × CTR), the break-even CTR, and where Google and Meta let you buy each.

Sep 30, 2026 · 5 min

Power BI for Mac: there is no Mac app — here are the four ways Mac users build reports

The browser, Parallels with Windows 11 for Arm, Windows 365, or a Windows PC — what each runs and costs.

Sep 30, 2026 · 5 min

Why Search Console clicks don't match GA4 sessions

Every documented cause, which way it pushes the gap, and a like-for-like weekly comparison.

Oct 1, 2026 · 8 min

How to export more than 1,000 rows from Google Search Console

The API at 25,000 rows a request, Looker Studio, bulk export to BigQuery and a synced copy — limits and costs.

Sep 30, 2026 · 6 min

Facebook Ads (Meta Ads) to Tableau: every route, what each costs, and the refresh setting that keeps it right

Tableau has no Meta connector. CData, Coupler.io, Windsor.ai, the BigQuery transfer and Ads Manager exports, priced — and why the extract must re-read 28 days.

Sep 30, 2026 · 13 min

Google Ads to Tableau: every route that still works, and what each one costs

Tableau's Google Ads connector died with the AdWords API in 2022. The BigQuery transfer, Sheets, partner connectors and exports that work now.

Sep 30, 2026 · 12 min

GA4 quota exceeded in Looker Studio (and Power BI): why it happens and four fixes

What each quota error means, which limit it hit, and four fixes: lighter reports, Extract Data, BigQuery export, a synced copy.

Sep 26, 2026 · 13 min

Looker vs Looker Studio (now Data Studio): what's different, and what the 2026 rename changed

Looker is governed BI priced by quote; Looker Studio, renamed Data Studio in April 2026, is free with a $9 Pro tier. Side by side.

Sep 26, 2026 · 11 min

Connect Meta Ads to Claude: the official Ads MCP, vendor connectors, or a synced backend

Meta's ads MCP server edits campaigns; vendor connectors do too; a synced backend only reads. What each one is for.

Sep 26, 2026 · 10 min

Cross-channel attribution: what's knowable, and what to do about the rest

Your platforms collectively claim more conversions than you had. The four approaches, their real limits, and the honest stack below enterprise scale.

Sep 7, 2026 · 10 min

Blended ROAS: one honest number across Google Ads, Meta and GA4

Why platform ROAS double-counts, how to compute the blended figure in one query, and how to use it without over-reading it.

Aug 17, 2026 · 9 min

Marketing automation reporting: getting lifecycle data out of its silo

Your automation platform reports its own funnel perfectly and knows nothing about acquisition cost. The join that fixes that — and its honest limits.

Aug 31, 2026 · 8 min
Data infrastructure
Try it

Give your Claude Code a data backend in five minutes.

npm i -g @tablebi/cli && tablebi install