Home / Connectors
Connectors

Quiriz connectors: every dataset and metric definition

16 read-only connectors that refresh daily, and 252 metric definitions written down so every answer uses the same one. Each connector page shows exactly how its metrics are calculated.

All connectorsHow definitions workCross-source metricsYour ownGood pairsFiles and folders

All connectors

Store and payments

ShopifyBeta

9 datasets · 28 metrics

Bring in orders, line items, refunds, a sales ledger that matches Shopify reports, products and customers, plus variant cost history and contribution margin inputs.

WooCommerceBeta

6 datasets · 10 metrics

Bring in orders, net sales, refunds, products and stock, and new versus returning customers.

StripeBeta

7 datasets · 20 metrics

Bring in payments, refunds, fees and payouts that match the Stripe Balance report, plus subscriptions and MRR by month.

KlaviyoBeta

4 datasets · 13 metrics

Bring in email and SMS revenue by day, campaign and flow results, and list growth.

Advertising

Google AdsBeta

7 datasets · 30 metrics

Bring in campaign, ad group and keyword performance, plus search terms, impression share, quality score parts and device performance.

Meta AdsBeta

7 datasets · 20 metrics

Bring in Facebook and Instagram campaign, ad set and ad performance, plus video hook and hold rate, reach and frequency, creative, and age, gender and placement breakdowns.

Microsoft AdvertisingBeta

3 datasets · 9 metrics

Bring in Microsoft (Bing) campaign, ad group and ad performance.

Web and product analytics

Google AnalyticsBeta

3 datasets · 8 metrics

Bring in GA4 sessions, users, key events and revenue by day, channel and landing page.

Google Search ConsoleBeta

3 datasets · 5 metrics

Bring in Google search clicks, impressions and positions by day, query and page.

Bing Webmaster ToolsBeta

4 datasets · 7 metrics

Bring in Bing search clicks, impressions, queries, pages and crawl stats. and keeps up to 25 months of history.

PostHogBeta

7 datasets · 19 metrics

Bring in PostHog traffic, signups, activation, retention and feature usage by day, channel and page.

Sales and CRM

HubSpotBeta

8 datasets · 24 metrics

Bring in deals, contacts, companies, stage history, a daily pipeline snapshot, support tickets, marketing emails and campaigns.

SalesforceBeta

7 datasets · 17 metrics

Bring in leads, opportunities, stage history, accounts and campaigns. Needs Salesforce Enterprise edition or above; your Salesforce admin installs the Quiriz package once.

Finance and time

QuickBooksBeta

5 datasets · 12 metrics

Bring in the profit and loss and balance sheet by month, the general ledger, and open invoices and bills. Matches QuickBooks reports.

HarvestBeta

6 datasets · 14 metrics

Bring in hours, billable and unbilled amounts, utilization, invoices, project budgets and expenses.

Engineering

GitHubBeta

3 datasets · 16 metrics

Bring in pull requests, reviews and default-branch commits for each developer: PRs merged, time to merge and to first review, reviews given, work type, areas of the code, and how much was AI-assisted.

How definitions work

A number is only as consistent as its definition. When you connect a tool, Quiriz imports its data as datasets and adds a definition for each common metric to Company Context: which dataset it reads, the column it totals, any filter, and the date that decides which period a row belongs to.

Cross-source metrics

Some questions need two connectors: what a new customer costs needs spend from the ad platform and new customers from the store. Quiriz adds these metrics for you once both sides are connected.

MetricHow it is calculatedNeedsNotes
Meta Ads nCACMeta Ads spend ÷ New customersShopify + Meta AdsMeta Ads spend per new customer: Meta Ads spend divided by New customers in the same period.
Meta Ads aMERNew customer net sales ÷ Meta Ads spendShopify + Meta AdsFirst-order net sales per Meta Ads dollar: New customer net sales divided by Meta Ads spend in the same period.
Google Ads nCACGoogle Ads spend ÷ New customersShopify + Google AdsGoogle Ads spend per new customer: Google Ads spend divided by New customers in the same period.
Google Ads aMERNew customer net sales ÷ Google Ads spendShopify + Google AdsFirst-order net sales per Google Ads dollar: New customer net sales divided by Google Ads spend in the same period.
Microsoft Ads nCACMicrosoft Ads spend ÷ New customersShopify + Microsoft AdvertisingMicrosoft Ads spend per new customer: Microsoft Ads spend divided by New customers in the same period.
Microsoft Ads aMERNew customer net sales ÷ Microsoft Ads spendShopify + Microsoft AdvertisingFirst-order net sales per Microsoft Ads dollar: New customer net sales divided by Microsoft Ads spend in the same period.
Contribution margin before ads (actual fees)Net sales − Cost of goods sold − Shipping and fulfillment cost − Payment processing feesShopifyNet sales minus cost of goods sold, shipping and fulfillment (assumption) and the Shopify Payments fees actually charged. Fees of other gateways are not included.
Break-even MER (actual fees)Net sales ÷ Contribution margin before ads (actual fees)ShopifyNet sales per ad dollar at which ad spend uses up the whole contribution margin before ads (actual fees). Above it ads add profit, below it they lose money.
Blended nCAC(Meta Ads spend + Google Ads spend) ÷ New customersShopify + Meta Ads + Google AdsMeta Ads and Google Ads spend per new customer.
Blended aMERNew customer net sales ÷ (Meta Ads spend + Google Ads spend)Shopify + Meta Ads + Google AdsFirst-order net sales per paid ad dollar across Meta Ads and Google Ads.
Blended MERNet sales ÷ (Meta Ads spend + Google Ads spend)Shopify + Meta Ads + Google AdsMarketing efficiency ratio: Shopify net sales per paid ad dollar across Meta Ads and Google Ads, in the same period. Net sales are Shopify's own, not what the platforms report.

Your own cross-source metrics

An admin can define a metric from metrics on different datasets, in Company Context, the same way as any other definition. Quiriz totals each part over the same period and does the arithmetic. Some examples, using the metric names the connectors add:

ExampleFormulaNeeds
Pipeline per ad dollarClosed-won revenue ÷ (Google Ads spend + Meta Ads spend)HubSpot + Google Ads + Meta Ads
Books against the storeRevenue − Net salesQuickBooks + Shopify
Revenue per tracked hourRevenue ÷ Harvest hoursQuickBooks + Harvest
Signups per search clickPostHog signups ÷ Search Console clicksPostHog + Google Search Console

Breaking it down needs a shared dimension. By default a cross-source metric answers for a period or a trend over time. To break it down by something else, such as channel or client, an admin maps a Dimension in Company Context: one column in each dataset that means the same thing, for example the UTM source on store orders and the platform on ad spend. The values have to match across the two columns, and Quiriz checks that they overlap when the Dimension is saved. A metric can be broken down by a Dimension only when every dataset it uses has that Dimension mapped.

Connections that work well together

Files and folders

For a tool without a connector, the data can still come in:

Datasets from files have no definitions added automatically. An admin defines their metrics in Company Context, and they then work in cross-source metrics like any connector’s.

Connect a tool, ask in plain words

Try the questions on sample data with no signup, then connect your own tools read-only.

Try Quiriz free →

Frequently asked questions

Which tools does Quiriz connect to?
HubSpot, Google Ads, Google Search Console, Google Analytics, Meta Ads, Shopify, QuickBooks, Stripe, PostHog, Bing Webmaster Tools, Klaviyo, Harvest, WooCommerce, GitHub, Salesforce, Microsoft Advertising. Anything else can come in through a Google Sheet or a Google Drive or OneDrive folder that Quiriz syncs on a schedule, or a file upload.
Are the connectors read-only?
Yes. Quiriz reads the data and never changes anything in the source system. Connectors refresh once a day and are included in paid plans.
What is a cross-source metric?
A metric whose parts come from different connectors, such as ad spend from Meta and new customers from Shopify. Quiriz adds the common ones automatically, and an admin can define more in Company Context.
Can I change a metric definition?
Yes. Every definition a connector adds lives in Company Context, where an admin can edit it. A refresh never overwrites a definition someone has changed.