How do I connect Stripe to Data Studio with Kondado?

In Kondado, add Stripe as your data source, choose the Stripe pipelines you want to visualize, and select Looker Studio as the destination. Complete the Via Kondado setup and name the data source. Then open Looker Studio to start creating charts from the available fields. This flow is designed for business users who want a straightforward path from payment data to visual reports.

Which Stripe dashboards can I build in Data Studio?

You can build custom dashboards for revenue, subscription health, invoice collections, refunds, disputes, customer growth, and payout tracking. For example, combine Charges with Refunds to review net revenue, or use Subscriptions with Customers to monitor retention and plan mix. Finance teams often create a cash movement view with Payouts and Balance transactions, while marketing teams track customer acquisition by period. Since dashboards are custom in Looker Studio , you choose the charts and filters that match your questions.

How often can Stripe data update in Data Studio?

Kondado lets you set the update frequency when you configure the Stripe data source. You can choose every 5 minutes, every 15 minutes, hourly, daily, or another configurable schedule that suits your reporting rhythm. Looker Studio reports then reflect the latest replicated data after each scheduled update. For weekly finance reviews, daily updates are often enough, while operational teams may prefer more frequent refreshes.

Which KPIs should I track with Stripe data in Data Studio?

Common KPIs include gross and net revenue, refund rate, dispute rate, unpaid invoice value, subscription churn, average order value, and payout timing. You can calculate these from pipelines such as Charges, Invoices, Subscriptions, Refunds, and Disputes, then display them as scorecards, trend lines, and period comparisons in Looker Studio . Add customer-level filters to compare segments, products, or campaigns. These KPIs help teams decide where to improve collections, pricing, and retention.

Can I share Stripe dashboards with my team in Data Studio?

Yes, you can share the Looker Studio reports you build with colleagues, clients, or stakeholders using the sharing options in Looker Studio. You can give view or edit permissions depending on the role, and schedule report delivery for regular reviews. Teams often create separate views for finance, marketing, and operations so each group sees the metrics they need. Keep dashboard definitions clear so everyone reads the same numbers.

Do I need technical skills to visualize Stripe data in Data Studio?

No, the workflow is designed for business users who want to build reports without code. You choose the Stripe pipelines in Kondado, select Looker Studio as the destination, and then use drag-and-drop charts in Looker Studio. Most teams start with a few core metrics, such as revenue, refunds, and subscriptions, and expand from there. This makes it practical for SMBs and agencies to create dashboards for daily decisions.

Kondado: Connect Stripe to Looker Studio (now Data Studio): Dashboards in Minutes

Subscription schedules

Registry of subscription schedules, with id, customer, subscription, status, creation, cancellation, completion and release dates, current phase, billing mode, default settings, end behavior, and live-mode flag.

Early fraud warnings

Record of early fraud warnings, with id, actionable flag, related charge and PaymentIntent, creation timestamp, fraud type, and live/test mode.

Tax rates

Tax rate record with identifier, active status, country, state and jurisdiction, display name, percentage and effective percentage, flat amount and currency, inclusive flag, rate type and tax type, creation timestamp, and live mode.

Subscriptions

Subscription record with identifier, customer, status, collection method, currency, billing cycle and anchor, creation, start, cancellation and end dates, fee amounts and percentages, discounts, thresholds, invoice and trial settings, plus schedule and pending updates.

Subscriptions - Details - Subscription items

Subscription items, with id, associated subscription and price, quantity, billing and trial periods, usage thresholds, and price attributes such as currency, unit amount, recurring interval, and usage type.

Customers

Stripe customer records, with identifier, name/business, email, address, balance and currency, invoice settings, tax data, shipping, discount, cash balance, and creation timestamp.

Customers - Details - Tax IDs

Registry of each customer's tax IDs (CNPJ, CPF, VAT, etc.), with country, type, value, verification status, creation timestamp, and customer, account, and owner references.

Customers - Details - Payment methods

Payment methods linked to customers, with identifiers, billing details, card details (brand, expiry, last four digits, checks), bank accounts, and digital wallets.

Customers - Details - Customer balance transactions

Each row is a customer credit balance transaction, with id, customer_id, amount, ending_balance, currency, type, created, description, livemode, and related IDs for checkout_session, credit_note, customer, customer_account, and invoice.

Charges

Stripe charge records with id, amount, captured and refunded amounts, currency, creation date, status, paid/captured/refunded/disputed flags, customer, PaymentIntent, payment method, balance transaction, risk outcome, and billing/shipping details.

Billing credit grants

Registry of billing credit grants issued to customers for consumption-based billing, with id, customer/account, monetary amount and currency, type, category, priority, price scope, effective/expiration/void timestamps, live/test mode, and creation/update timestamps.

Connected accounts (Connect)

Registry of connected accounts (Connect), with identifier, business profile (name, MCC, type, estimated annual and monthly revenue, estimated worker count), support details, and payment capability statuses.

Disputes

Stripe dispute records, with id, disputed amount, currency, related charge and PaymentIntent, reason, status, creation and evidence due dates, plus evidence and eligibility details.

Coupons

Registry of discount coupons, with identifier, name, amount or percentage off, currency, duration and duration in months, redemption limits and count, redemption deadline, validity status, livemode flag, and creation timestamp.

Promotion codes

Registry of promotion codes customers enter to apply a coupon, with identifier, code, active status, customer, expiration, redemption limits and count, promotion type, and minimum-amount and first-transaction restrictions.

Events

Record of Stripe account events, with id, account, API version, context, creation time, livemode, pending webhooks, request details, event type, and the affected object's id and type.

Invoices

Registry of invoices, with identifier, customer, currency, amounts due/paid/remaining, creation and due dates, collection method, billing reason, and automatic tax status.

Invoices - Details - Invoice line items

Each row represents a Stripe invoice line item, with invoice, subscription, and parent identifiers, plus amount, subtotal, currency, quantity/quantity_decimal, period_start/period_end, description, discountable, livemode, parent_type, and pricing details (price, product, pricing_type).

Entitlement features

Registry of features that can be granted to customers by product, with unique identifier, active status, live-mode flag, lookup key, and name.

Setup intents

Each row records a SetupIntent, with id, customer, status, usage, created, payment_method, cancellation_reason, last_setup_error fields, automatic_payment_methods, mandate, latest_attempt, and livemode.

Payment intents

Payment intent records, with id, amount and amount received, currency, status, creation date, customer, payment method, capture and confirmation method, cancellation reason, latest charge, and transfer data.

Invoice items

Record of an invoice item, with id, amount and currency, linked customer and invoice, date, description, quantity, discount and proration flags, period, and pricing/subscription details.

Payment links

Registry of payment links, with identifier, active status, URL, currency, post-purchase behavior, tax, invoice, PaymentIntent, subscription, application fee, transfer amount, and session restriction settings.

Payment links - Details - Line items

Line items of payment links, with payment_link_id, id, quantity, description, currency, discount, subtotal, tax and total amounts, plus price data (id, type, billing scheme, recurring interval and unit amount) and adjustable quantity limits.

Radar value lists

Each row represents a Radar value list, with id, alias, name, item type, creator, creation timestamp, and live mode indicator.

Radar value lists - Details - Items

Item in a Radar value list, with its own and parent list identifiers, value, creation timestamp, creator, and live-mode indicator.

Billing meters

Registration of usage billing meters for consumption-based billing, with id, display_name, event_name, default_aggregation_formula, customer_mapping_type, event_time_window, status, livemode, and creation, update, and deactivation timestamps.

Credit notes

Credit notes issued or voided, with identifier, customer, invoice, status, reason, currency, amounts (subtotal, total, tax, shipping and payment amounts), creation/effective/void dates, and PDF link.

Credit notes - Details - Line items

Each row represents a credit note line item, with credit note and item IDs, amount, description, discount amount, linked invoice line item, livemode flag, quantity, type, and unit amounts.

Quotes

Record of quotes with id, status, customer, invoice and subscription, currency, subtotal/total amounts and computed recurring and upfront totals, discount, shipping and tax details, creation/expiration/status-transition dates, and invoice and subscription settings.

Quotes - Details - Line items

Each row represents a quote line item, with quote_id and id, description, quantity, currency, discount, subtotal, tax, and total amounts, plus price details (id, type, unit amount, recurrence, product) and adjustable quantity limits.

Invoice payments

Payments applied to invoices, with id, related invoice, paid and requested amounts, currency, status, payment type and originating payment references, default flag, livemode, and creation, payment, and cancellation timestamps.

Plans

Registry of recurring price plans, with id, active status, amount and currency, billing scheme, interval and interval count, product, nickname, tiers mode, usage type, trial days, meter, usage transformation, creation timestamp, and live/test mode.

Prices

Registry of product prices (one-time or recurring), with id, active status, currency, unit amount, billing scheme, recurring interval, associated product, and tier and tax settings.

Products

Stripe catalog product record, with identifier, name, description, active status, default price, package dimensions, tax code, unit label, URL, and creation and update timestamps.

Top-ups

Record of each balance top-up, with id, amount and currency, status, creation time, balance transaction, payment method, initiator, failure code/message, expected availability date, description, statement descriptor, source ID, and transfer group.

Refunds

Each row represents a Stripe refund, with id, amount, currency, status, reason, creation date, links to charge, customer, and PaymentIntent, plus balance transaction, destination, failure/pending, and presentment details.

Payouts

Each row is a payout, with id, amount, currency, status, creation and arrival dates, method, destination, balance transaction, failure code/message, and reversal references.

Payouts - Details - Payout transactions

Each row is a balance transaction linked to a payout, with identifier, gross amount, fee, net amount, currency, status, type, reporting category, availability and creation dates, source, and exchange rate.

Radar reviews

Each row represents a Radar review, with its identifier, associated charge and PaymentIntent, open/closed status and reasons, creation timestamp, IP and location data, session details, and live-mode flag.

Current balance

Current Stripe account balance per balance type and currency, with amount, portions from cards, bank accounts, and FPX, production/test mode flag, and read timestamp.

Checkout sessions

Checkout sessions, with unique id, creation and expiration timestamps, currency, subtotal and total amounts, customer, invoice, and PaymentIntent references, plus address, tax, branding, and consent data.

Checkout sessions - Details - Line items

Line items of a checkout session, with session and item identifiers, quantity, description, currency, discount, subtotal, tax and total amounts, plus price details such as product, type, recurrence, tax behavior and unit amount.

Identity verification sessions

Each row represents an identity verification session, with id, client_reference_id, created, status, type, livemode, document/email/phone and matching options, provided details, latest error, redaction_status, related customer/person, verification_flow, and verified outputs (address, date of birth, email, name, ID number, phone, and sex).

Shipping rates

Each row represents a shipping rate, with id, active status, creation time, display name, delivery estimate minimum/maximum unit and value, fixed amount and currency, livemode, tax behavior, tax code, and calculation type.

Application fees

Each row represents a Stripe application fee, with its identifier, account, application, related charge and balance transaction, amount and amount refunded, currency, creation time, fee source, live mode, and full-refund indicator.

Terminal readers

Registry of terminal readers, with id, label, serial number, device type and software version, IP address, location, network status, last seen, livemode, and action details such as type, status, API errors, refund, display, print, and processing configurations.

Terminal locations

Registry of physical locations for Stripe Terminal readers, with id, address (including kana/kanji variants), display name, configuration override, phone, and live-mode flag.

Balance transactions

Each row is a Stripe balance transaction, with id, gross amount, fee, net impact, currency, exchange rate, creation and availability dates, balance type, reporting category, source, status, and transaction type.

Transfers

Stripe transfer record with identifier, amount and reversed amount, balance transaction, creation timestamp, currency, description, destination account, destination payment, live mode, reversal status, source charge, source type, and transfer group.

Transfers - Details - Reversals

Transfer reversals, with id, reversed transfer, amount, currency, creation timestamp, balance transaction, and linked source/destination payment refunds.