Every client's Shopify, HubSpot and ad numbers, in a deck
Connect a client's Shopify, HubSpot and ad accounts to Quiriz directly, or point it at the Google Sheet or Excel file a connector tool already fills. Either way it refreshes daily, and you ask for the answer, the table or the whole PowerPoint deck.
The monthly client report is the same work every month: export, paste, rebuild the charts, write the commentary. A connection or a connector tool takes care of the export. Quiriz takes care of the rest, with the same metric definitions for every client and every month.
How it works
There are two routes into Quiriz, and you can mix them within one client. Connect directly where Quiriz has a connector: Shopify, HubSpot, Google Ads, Meta Ads, Google Analytics 4, Search Console, Klaviyo, Stripe, QuickBooks, Harvest, PostHog and Bing Webmaster Tools. Each connection is read-only, refreshed daily and included on paid plans, and someone with access to the client's account signs in once to approve it. Each connection reads one account, store, property or site, so a client with two ad accounts needs two connections. Use a spreadsheet for any source without a connector, or when a client will not grant sign-in access. A connector tool writes the data to a Google Sheet or Excel workbook, and Quiriz reads that. The steps below are for the spreadsheet route.
- A connector tool writes the client's data to a spreadsheet. A Google Sheet or an Excel workbook on OneDrive, one per client, one tab per source, refreshed every morning.
- Quiriz reads each tab as a dataset. You connect the file once.
- Quiriz refreshes the datasets daily. It picks up whatever the connector wrote overnight.
- You ask. A number, a table and chart in Excel or Sheets, a PowerPoint or Google Slides deck, or a Word report. ROAS, win rate and net sales mean the same thing in every one, because you define them once in Company Context.
What connecting your sources adds
Once a client's sources are connected, Quiriz can answer across them, joined on a shared date, a mapping you supply, or a name you keep consistent. Connections belong to the workspace they are made in, so a client kept in its own workspace gets its own set. The questions below are the kind a client report keeps asking and a single export cannot answer.
- An e-commerce client, store against ads. "What was net sales per dollar of Google Ads and Meta Ads spend each month, and what did a new customer cost?" Connectors: Shopify, Google Ads, Meta Ads. The join is on date, and the result is a store-level blended view, not attribution. In a spreadsheet it is three exports cut to the same dates, rebuilt every month.
- An e-commerce client, email against the whole store. "What share of net sales did Klaviyo attribute to email and SMS each month?" Connectors: Shopify and Klaviyo. The join is on date. Klaviyo revenue is Klaviyo's own attribution, so it is a share of what Klaviyo saw and not an amount that comes off Shopify net sales.
- A lead-gen client, pipeline against spend. "Which lead sources produced the most closed-won revenue last quarter, and what was spent on Google Ads and Meta Ads in the same months?" Connectors: HubSpot, Google Ads, Meta Ads. HubSpot records a source category on each deal, so the join is by month and category. Matching single campaigns needs campaign names that agree between HubSpot and the ad platform. The CRM and the ad accounts are usually exported on different days, at different grains.
- An SEO client, organic across engines and on site. "How did organic clicks from Google and Bing move against organic sessions in Google Analytics each month?" Connectors: Search Console, Bing Webmaster Tools, Google Analytics 4. The join is by month, and Bing's query data is weekly while Google's is monthly, so queries compare by month only after rolling the weeks up. Three tools, three date conventions.
- Your own agency, client profitability. "Which clients had the best margin last quarter, and how much of their work is still unbilled?" Connectors: Harvest and QuickBooks. Harvest answers margin and unbilled by client on its own. Adding QuickBooks for overdue receivables by client needs a shared key, meaning the client names in Harvest must match the customer names in QuickBooks.
- A source without a connector. "Show LinkedIn, Google and Meta cost per conversion in one table." Connectors: Google Ads and Meta Ads, plus LinkedIn through a Google Sheet. The Sheets route lands the LinkedIn data as its own dataset, and it joins the connected data on date, provided the file keeps a date column and a platform label. Setting this up is the one manual step.
Cross-source figures are not pre-defined metrics. Each answer states whether it came from a stored definition or was answered freehand, and a figure you report every month is worth defining once in Company Context.
Connector tools that write to Google Sheets or Excel
Use these for sources Quiriz does not connect to directly, or when a client will not grant sign-in access. Each of these covers Shopify, HubSpot, Google Ads and Meta Ads and refreshes a spreadsheet on a schedule. Prices are the lowest plan that includes scheduled refresh.
| Tool | Starting price | What it includes | Google Sheets | Excel on OneDrive | Free plan or trial |
|---|---|---|---|---|---|
| API Connector | $15/mo ($12 annually) | 2,500 requests a month. You set up the API requests yourself. | Daily | No | Free plan (no schedule) |
| Adveronix | $29/mo | 5 ad accounts, 5 saved reports. No-code setup. | Daily or hourly | No | 2-week trial |
| Porter Metrics | $15/mo for 1 account | $40 for 4 accounts, $8 per account for 5–12, $100 for 13–20 | Daily | No | 14-day trial |
| Catchr | $24/mo | 3 platforms, 10 accounts | Daily | No | 14-day trial |
| Windsor.ai | $23/mo ($19 annually) | 3 sources. All four sources from $118/mo ($99 annually), 75 accounts | Daily, even on Free | Manual refresh only | Free plan (1 source, 1 account), 30-day trial |
| Dataslayer | €20/mo billed annually | 3 sources, 3 accounts each. 7 sources and 50 accounts at €99/mo | Daily | Scheduled | Free plan (1 source, manual refresh) |
| Supermetrics | $55/mo ($44 annually) | 3 sources, 3 accounts per source, 1 user | Check the plan | Scheduled | 14-day trial |
| Skyvia | Free, then $79/mo billed annually | Free plan runs once a day, up to 10,000 records a month | Daily | Adds rows only | Free plan |
List prices in USD (Dataslayer in EUR), checked October 2026. Vendors change plans often, so confirm on their pricing page before you buy. "Scheduled" in the Excel column means the tool refreshes a workbook saved in OneDrive or SharePoint without anyone opening it.
Not a fit for this setup: automation tools that add one row per event, such as a new order, cannot pull an ad report into a spreadsheet. Tools that deliver only to a data warehouse need that warehouse first.
Which one to pick: API Connector is cheapest if you can set up API requests, Adveronix if you would rather click through a form. Porter Metrics suits one to three clients, Windsor.ai past about ten. For Excel, Dataslayer or Supermetrics refresh a workbook on OneDrive; to start free, Skyvia refreshes a Google Sheet once a day.
Setting up the spreadsheet route
Four settings matter most: one file per client with one tab per source, a fixed start date, Replace rather than Append, and columns that stay stable. The full steps are below.
Set up the connector
Set up the connector
The steps differ a little by tool, but these settings are what make the data come out right in Quiriz:
- One file per client, one tab per source. For example, a "Northwind" Sheet or workbook with tabs for Shopify orders, HubSpot deals, Google Ads and Meta Ads. For Excel, save the workbook in OneDrive.
- Pick a fixed start date, such as January 1, 2024, rather than "last 30 days". Quiriz replaces the dataset on every refresh, so the file should hold the full history you want to ask about.
- Choose Replace (sometimes called overwrite), not Append. Ad platforms restate recent days as conversions come in, and HubSpot deals change stage. Append turns each change into a second row, and totals get counted twice.
- Pull daily rows by campaign for ads, and one row per order or deal for Shopify and HubSpot. Include the IDs (campaign ID, order ID, deal ID) as well as the names.
- Schedule the refresh for early morning, before the Quiriz refresh window you pick below.
- Keep the columns stable. Adding a column later is fine. Renaming or removing one stops the Quiriz refresh until it's restored.
Connect a Google Sheet and turn on its daily refresh
Connect a Google Sheet in Quiriz
- Open Import Data from the side navigation and click Google Drive.
- Give Quiriz view access to the Sheet. Either share it as a Viewer with the address shown under the box (data@quiriz.co), or click Connect Google if that option appears.
- Paste the Sheet's URL and click Load.
- Under Select Sheets, pick the tabs to import, then click Convert.
- Click Upload as Dataset, or Upload All for several tabs. Each tab becomes its own dataset, already linked to the Sheet.
Turn on the daily refresh for a Google Sheet
- Open Manage Data, select the dataset, and click Schedule Data Refresh.
- File Source is already set to Google Sheet, with the Sheet filled in.
- Set Refresh mode to By file ID.
- Set Check frequency to Daily and pick a time window, such as Morning (6am–12pm). Quiriz uses the timezone in My Preferences.
- Click Save Schedule, then Run Now to test it. The result shows under Ingestion History.
Repeat for each tab's dataset. Every report and deck built on these datasets reads the refreshed numbers on its next run.
Connect an Excel workbook on OneDrive
Connect an Excel workbook on OneDrive
- Open Import Data and click OneDrive. If you see Connect Microsoft, click it and sign in with the Microsoft account that holds the workbook.
- In your browser, open the OneDrive folder that holds the workbook and copy the address bar link (it starts with
https://onedrive.live.com/?id=). - Paste it and click Load. Tick the workbook in the file list, then click Import 1 file.
- When the import finishes, click Schedule refresh on the "Set up scheduled refresh for these files?" banner.
- Set the workbook to Refresh the same updated file, choose Daily and a time window, and click Save.
Quiriz checks the workbook at that time each day and refreshes the datasets when the connector has updated it. To change the schedule later, or to run it right away, use Schedule Data Refresh on Manage Data.
Scheduled refresh is included from the Plus plan. On Free, use Run Now from Schedule Data Refresh.
Common problems
- "Format change detected: missing columns". A column was renamed or removed in the file or the connector query. The refresh stopped and kept the existing data. Restore the column, or import the file again as a new dataset.
- Totals are too high. The connector is in Append mode, or the Quiriz refresh mode is set to Append data. Switch both to replace.
- The refresh says there is nothing new. Quiriz only refreshes when the file has changed since the last run. Check that the connector's own schedule ran.
- A connected account asks you to reconnect. Meta sign-ins last about 60 days. Sign in again from the connection and the daily refresh resumes.
- The file is getting large. Google Sheets holds up to 10 million cells per file. Split long histories by year, or drop columns you never ask about.
One report setup, every client
The monthly client report is the same structure for every client and different data for each. Quiriz keeps each client in its own project, with its own datasets, questions, reports and people, so the structure is set up once and run per client.
- The client's KPI tab, in Excel or Google Sheets. The same column of
=QUIRIZquestions in every client's Sheet, such as "ROAS by platform last month" or "net sales against the month before", answered against that client's datasets. - The written summary, in Word or Google Docs. In Word, the figures sit inside your commentary as live Figures, and a refresh with tracked changes on shows the account lead which numbers moved before the client sees them. In Docs, type the question where the chart belongs and press Chart.
- The client deck, in PowerPoint or Google Slides. Build it from a description in the client's project, or fill the agency's own template from
=QUIRIZ.ASK()markers, then Refresh all each month in PowerPoint. Three prompts are below. - The client's channel, in Slack. Install Quiriz once, then bind each client's channel to that client's project with
/quiriz bind. Anyone in the channel can mention Quiriz and get an answer from that client's data only. Slack is included from the Plus plan.
Make a deck: three prompts to try
Open the client's project, tick its datasets, and paste one of these with the client's name and month. Quiriz plans the slides first, so any title or question can be edited before it builds. In PowerPoint each chart and table carries two to four takeaways written from that slide's own figures; Slides closes with an executive summary.
E-commerce client, monthly report
PowerPoint, Consulting style. Tick the client's Shopify, Google Ads and Meta Ads datasets.
"Monthly report for our client [client] for August 2026. Net sales, orders and average order value against July and against August 2025, net sales by category, ad spend and ROAS by platform for August, ROAS by platform by month this year, and the campaigns with the highest and lowest ROAS in August. End with recommendations."
What comes back, about nine slides:
- Agenda and executive summary.
- The headline numbers against last month and last year, as a table.
- Net sales by category: a bar chart.
- Spend and ROAS by platform: a table for the month.
- ROAS by platform by month: a line chart.
- Best and worst campaigns: a table.
- Recommendations, written from those slides.
SaaS client, monthly report
Google Slides. Tick the client's analytics, ad, product analytics and Stripe datasets.
"Monthly report for our client [client] for October 2026. Signups by channel against September, paid spend and cost per signup by platform, October campaigns by cost per signup, organic search clicks by month, and MRR by month this year."
What comes back: signups by channel, a table of spend and cost per signup by platform, campaigns ranked by cost per signup, organic clicks by month, and MRR by month, then the executive summary.
Quarterly business review for a client
PowerPoint, Consulting style. Tick every dataset in the client's project.
"Quarterly business review for our client [client] for 2026 to date against the same period of 2025. Net sales and orders for both periods, net sales by month, refund rate by quarter, Facebook and Google spend and ROAS by quarter, wholesale win rate and won revenue for both periods, and win rate by region. End with recommendations for the fourth quarter."
What comes back: about ten slides, from the year-to-date comparison through sales, refunds, paid media and pipeline, closing with Recommendations for the next quarter written from what those slides found. Drop the pipeline lines for a client without a CRM.
Pricing
You pay for workspaces and the people who build them, not for everyone who asks a question. Connectors are included on paid plans, and scheduled spreadsheet refresh is included from the Plus plan. See pricing →
Your data stays yours, and we do not train on it. Privacy policy →
Related reading
- How to build a client reporting pack
- A Google Ads dashboard from a connected account
- A Meta Ads dashboard from a connected account
- Facebook Ads vs Google Ads ROAS
- A Google Analytics 4 dashboard
- A Search Console dashboard
- Shopify analytics beyond the dashboard
- A HubSpot attribution report
- Harvest project profitability: your own client margins
- Agency client KPI rollup template
- ROAS, CPA and CPC across Google, Meta and LinkedIn
- Win rate, pipeline and bookings from HubSpot
- Margin by product category from Shopify
- All guides →