KeyCRM in Google Data Studio
Orders from every sales channel, payments and expenses, pipeline leads and calls — every night in Google Data Studio as clean tables. For the reports that are hard to get from built-in analytics.
No card required. Cancel any time.
What KeyCRM data you get
Not raw API output — ready tables: client names already joined onto deals, currencies converted, dates in your time zone.
Your CRM custom fields come along too, with proper types: numbers as numbers, dates as dates.
- Clients
-
Client record, owner, creation date, total purchases.
- Deals and orders
-
Pipeline, stage, outcome, owner, amounts and margin — in both currencies.
- Payments
-
Income and expenses: account, category, date, amount.
- Leads
-
Pipeline, stage, source and UTM tags.
- Products and services
-
SKU, price, cost, stock.
- Users
-
For reports broken down by owner.
- Order lines
-
What exactly was sold, how many and for how much.
- Calls
-
Direction, outcome, duration.
What is specific to KeyCRM
- Orders with sales channel, payment status and UTM tags
- Order payments and expenses (delivery, commissions) for true margin
- Pipeline leads with stages, sources and UTM tags
- Order products linked to your catalogue
- Channels in other currencies (PLN, USD, EUR) — amounts also in your reporting currency at the official rate of the order day
- Buyer, order and lead custom fields, typed as in KeyCRM
Reports you can build
- Sales and average order value by channel and campaign
- Net margin after delivery and marketplace commissions
- Repeat purchases and best customers
- Lead conversion by pipeline and source
How to connect KeyCRM
-
1/3
The account owner creates an API key in KeyCRM: Settings → General → API key.
-
2/3
We only read data and stay well within KeyCRM's request limit, so your website and marketplace integrations keep working.
-
3/3
The first sync loads your full history; after that data refreshes every night.
KeyCRM questions
We sell in several countries.
Each order carries its sales channel's currency. Reports get both the original amount and the reporting currency at the official rate of the order day.
Will this interfere with our integrations?
KeyCRM's request limit is shared by all integrations on the account, so we deliberately use only part of it.
Are cancelled orders included?
Yes, orders in every status — so you can measure cancellations and returns.
Other CRMs