Thassyo Pereira
CEO and co-founder of Kondado. Writes about how teams connect data to AI (Claude, ChatGPT via MCP), dashboards, spreadsheets and ETL — from connector design to modern data stacks in production.
Articles by Thassyo
How to Connect GA4 to Looker Studio Without Sampling
Connect GA4 to Looker Studio with Google's native data source and understand its sampling, "(other)" row, and quota limits. See how Kondado replicates GA4 to a source Looker Studio reads without sampling and blends it with Meta Ads, Google Ads, and your ERP in a single report.
How to connect GA4 to Power BI
Step-by-step guide to connect Google Analytics 4 to Power BI without code using Kondado.
How to Connect Your Data Sources to Looker Studio
How to connect your data sources to Looker Studio with no code: Kondado replicates your marketing, sales, and e-commerce data automatically. Free 14-day trial.
How to Build a Pipedrive Report in Looker Studio
How to build a Pipedrive report in Looker Studio with no code: Kondado replicates your sales pipeline automatically. Free 14-day trial.
How to Build a Pipedrive Report in Power BI
How to build a Pipedrive report in Power BI with no code: Kondado replicates your sales pipeline automatically. Free 14-day trial.
How to Build a HubSpot Report in Looker Studio
How to build a HubSpot report in Looker Studio with no code: Kondado replicates your CRM and marketing data automatically. Free 14-day trial.
How to Build a HubSpot Report in Power BI
How to build a HubSpot report in Power BI with no code: Kondado replicates your CRM and marketing data automatically. Free 14-day trial.
How to Read Via Kondado Data in Google Sheets (IMPORTDATA)
Guide to read Via Kondado data directly in Google Sheets using the IMPORTDATA function. Import integrated data with automatic refresh.
Tableau Via Kondado Connection
Connect Tableau to your Via Kondado destination through the PostgreSQL connector (kdb.kondado.io). Step-by-step setup with screenshots.
Metabase Via Kondado Connection
Connect Metabase to your Via Kondado destination through the PostgreSQL endpoint (kdb.kondado.io). Step-by-step setup with screenshots.
Query Builder
Learn how to use Query Builder to query data in Via Kondado without writing SQL. Includes manual mode and AI assistant.
Analyze YouTube in ChatGPT and Claude with Kondado MCP
Connect YouTube to ChatGPT and Claude with the Kondado MCP and analyze views, subscribers and watch time in plain language, with no code.
Analyze Facebook in ChatGPT and Claude with Kondado MCP
Connect Facebook to ChatGPT and Claude with the Kondado MCP and analyze posts, organic reach and followers in plain language. No code, no spreadsheets.
Pipedrive in ChatGPT via Kondado MCP: AI sales analytics
Pipedrive MCP: connect Pipedrive to ChatGPT and Claude with Kondado and ask about your sales pipeline in plain English, from forecast to bottlenecks and lost deals.
HubSpot in ChatGPT and Claude with Kondado MCP
Connect HubSpot to Kondado and ask ChatGPT and Claude about your pipeline, lead sources and service. The Kondado MCP reads the data in Via Kondado and answers in plain language.
TikTok Ads + ChatGPT: 13 analyses you run in natural language using Kondado's MCP
Connect your TikTok Ads data to ChatGPT and Claude through Kondado's MCP: ROAS, funnel, video retention, creatives and UTM analyzed without code.
Mercado Libre in ChatGPT and Claude: how AI analyzes your sales, invoices and Ads via Kondado's MCP
Connect your Mercado Libre data to ChatGPT and Claude through Kondado's MCP: sales, invoices, Mercado Pago and Ads analyzed without code.
Real ROAS Cross-Platform: How to Ask ChatGPT to Compare GA4, Google Ads, and Meta Ads via MCP
How to ask ChatGPT to calculate real ROAS by crossing GA4, Google Ads, and Meta Ads via the Kondado MCP in one session, with a campaign_name join and natural-English answers.
How to analyze RD Station Marketing data in ChatGPT with Kondado MCP
Connect ChatGPT and Claude to Via Kondado via MCP and analyze the 18 RD Station Marketing tables in KSQL with natural language questions.
How to Track ChatGPT, Claude, and Perplexity Traffic in GA4 and Cross-Reference with Sales
Identify ChatGPT, Claude, and Perplexity visitors in GA4 with a Custom Channel Group and cross-reference with ERP orders via Kondado MCP.
How to Connect Mercado Libre with Power BI, Looker Studio, and Spreadsheets
Complete guide for Mercado Libre sellers to integrate data with Power BI, Looker Studio, and spreadsheets using Kondado.
How to analyze Instagram data in ChatGPT and Claude via Kondado MCP
Learn to connect Instagram to ChatGPT via Kondado's MCP: 7 canonical tables, practical prompts, and proactive Meta API quirks documentation — no CSV exports needed.
Why bounceRate in GA4 Is Not 0.94 (And How to Ask ChatGPT for the Right Number via Kondado MCP)
Why bounceRate in GA4 is not 0.94: the API returns percentage (0-100), not decimal (0-1). Learn how the Kondado MCP avoids this trap and delivers the right interpretation.
GA4 + ChatGPT: 10 traffic and e-commerce analyses Kondado MCP answers without you opening BigQuery
Connect GA4 to ChatGPT via Kondado MCP. 10 traffic and e-commerce analyses you ask in natural language and get ready answers. 14-day free trial.
Google Ads + ChatGPT: 40 Questions That Change How You Manage Paid Media
Connect your Google Ads data to Claude and ChatGPT through Kondado MCP. 40 practical questions to manage campaigns, audiences, keywords, and ROAS in seconds.
The Kondado MCP: Connect Your Business Data to ChatGPT, Claude, Codex & Claude Code
Kondado MCP provides a single endpoint that connects ChatGPT, Claude, Codex, and Claude Code to your business data via OAuth 2.1. Query 100+ data sources in natural language.
Google Ads Already Has AI — So Why Connect to ChatGPT?
Google Ads AI handles the auction. Kondado's MCP cross-references Google Ads, Meta, GA4 and your ERP to decide where to invest the next dollar.
How to Connect Kondado to ChatGPT (Developer Mode Step-by-Step, Works on Free)
Step-by-step tutorial to connect Kondado to ChatGPT via MCP server, enable Developer Mode, and query your data in natural language. Works on any plan, including Free.
Build vs Buy: Why Companies Stop Building Internal ETL Pipelines
Compare cost, maintenance and time-to-report between building an in-house ETL pipeline and using the Kondado data platform. 5-question decision framework for CTOs and operations leaders.
How to Connect Kondado to Claude (Web, Desktop, Claude Code)
Complete tutorial to connect Kondado to Claude via MCP in three modalities: Web, Desktop, and Claude Code. Technical guide for developers and early adopters.
How ChatGPT Detects Creative Fatigue in Your Meta Ads — and What SQL It Runs Under the Hood
Creative fatigue silently destroys Meta Ads performance. Learn how ChatGPT connected via Kondado's MCP detects tired creatives in seconds, without writing SQL.
10 Meta Ads Analyses ChatGPT (or Claude) Answers When You Connect Kondado's MCP
Discover 10 practical Meta Ads analyses that ChatGPT or Claude answer via Kondado's MCP - real CPL, cross-channel attribution, creative fatigue detection, and more.
Your First Pipeline: Step-by-Step Guide
The real Kondado onboarding flow: from the Welcome page to your pipelines running. Step-by-step guide with screenshots.
How Much of My Shopify Revenue Came from Meta Ads? Cross-Channel Attribution in One ChatGPT Query (via Kondado MCP)
Reconcile Meta Ads, Shopify, and GA4 in a single LLM session via Kondado MCP. Solve the #1 e-commerce pain: cross-channel attribution with real data.
Marketing Data Warehouse: How Agencies Build It in 2026
A marketing data warehouse consolidates Meta Ads, Google Ads, TikTok Ads, and CRM data into BigQuery so Looker Studio reports refresh automatically. See the reference stack, build vs buy trade-offs, and realistic monthly costs for agencies in 2026.
ChatGPT
How to connect ChatGPT (Web, Desktop) and Codex (OpenAI's CLI) to Via Kondado via MCP — step by step, automatic OAuth flow, and tips.
Claude
How to connect Claude (Web, Desktop, and Code) to Via Kondado via MCP — step-by-step with screenshots, automatic OAuth flow, and troubleshooting tips.
Correct Column Typing in Power BI/Excel with the Via Kondado Schema API
Learn how to use Power Query with the Via Kondado schema endpoint so every column lands with the correct type in Power BI or Excel — no more relying on sampling-based inference.
How to Connect Supabase as a Destination in Kondado
Step-by-step guide to configure Supabase as a PostgreSQL destination in Kondado, including IPv4 setup, Session Pooler, and credentials.
How to Use Power Query in Excel with Via Kondado
Guide to connect Via Kondado to Excel Desktop using Power Query. Import integrated data directly into your spreadsheets with automatic refresh.
Kondado Plan vs Via Kondado — Which Limit Was Reached?
Understand the difference between Kondado Plan alerts (records/pipelines) and Via Kondado limits (accesses/cells) — and how to tell which one triggered your alert.
Mercado Libre Report Power BI
Complete guide to the Mercado Libre Report in Power BI by Kondado
BigQuery: How to Enable Billing (Error 403)
How to fix the 403 Billing error when using BigQuery as a destination in Kondado. Step-by-step guide to enable billing on your Google Cloud project.
Via Kondado: KSQL Reference
KSQL is Kondado's JSON-based query language for Via Kondado. This reference covers the complete syntax including filters, aggregations, JOINs, transformations, and more.
RD Station CRM Looker Studio Report
Connect your RD Station CRM data to Looker Studio for comprehensive sales analytics including deals, tasks, and sales performance metrics.
RD Station CRM Power BI Report
Connect your RD Station CRM data to Power BI for comprehensive sales analytics including deals, tasks, and sales performance metrics.
Mercado Libre Report Looker Studio
Complete guide to the Mercado Livre Report on Looker Studio by Kondado
Common Connector Questions Guide
A comprehensive guide covering the most common questions and troubleshooting tips for Kondado's main connectors including Facebook, Google Ads, Google Analytics, Instagram, LinkedIn, and RD Station.
How to Add a Kondado Table to Looker Studio
This step-by-step guide explains how to add Kondado data to Looker Studio for pipelines using the Via Kondado destination. Learn how to obtain the table URL from Kondado and configure it as a data source in Looker Studio.
Temporary Power BI adjustment for uninterrupted report access
Learn how to apply a temporary adjustment in Power BI Desktop to continue viewing reports normally without the corporate authentication requirement.
Pipelines
How to run, monitor, and duplicate Pipelines using the API.
Parent Pipelines
How to list available Pipeline types for a given source using the API.
Parent Collections
How to list available sources and destinations that can be created using the API.
Models
Learn how to check the execution and operational status of a model using its model_id.
Logs
How to retrieve and paginate execution logs for Pipelines and models using the API.
Invitations to Add Sources and Destinations
How to create secure invitations via the API to allow temporary users to add sources or destinations without granting account access.
Getting Started with the Kondado API
Overview of the Kondado API, including base URL, authentication using access tokens, and request rate limits.
Collection guests
Allows you to securely invite someone to configure a data source or destination in your Kondado account, with access limited exclusively to the setup process.
X Ads
X Ads connector documentation
Notifications
Kondado notifications alert users about important events in their environment, such as pipeline failures, report completions, and plan limit warnings. General notifications appear in the alert bell, while focused notifications show only alerts related to the specific pipeline, model, or destination being viewed, helping users quickly identify issues and take action.