Home / Agencies
For marketing and e-commerce agencies

Every client's numbers, one definition, a deck you refresh instead of rebuild

The monthly client report is the same work every month: export from six tools, paste, rebuild the charts, rewrite the commentary, and hope ROAS means the same thing in every client's file. Connect each client's Shopify, HubSpot and ad accounts directly. Quiriz defines each metric once, answers in Excel, Sheets and Slack, and builds a deck per client you refresh next month.

Sign up free → Or ask the sample HubSpot data first. No signup needed.

Agency time goes to assembling reports, not to the work clients pay for. A direct connection takes care of the export. Quiriz takes care of the definitions, the deck and the refresh, for every client.

What you get

How it works

  1. Connect each client's tools. Someone with access to the client's account signs in once and approves read-only access. Each connection reads one account, store, property or site, so a client with two ad accounts needs two connections. A connection belongs to the workspace it is made in, so a client kept in its own workspace gets its own set. If a client will not grant sign-in access, or a source has no connector, use the spreadsheet route.
  2. Quiriz sets up datasets and definitions. Each connection adds its datasets and metric definitions to Company Context, and cross-source metrics appear automatically when both sides are connected. With Shopify and Meta or Google connected you get Meta Ads nCAC, Google Ads aMER and, with both ad platforms, Blended MER.
  3. Ask where your team works. In Excel: =QUIRIZ.ASK("Google Ads ROAS by month this year", "table"). In Google Sheets: =QUIRIZ("Net sales this month against last month", "table"). In Slack, bind each client's channel to that client's project with /quiriz bind, and anyone in the channel can get an answer from that client's data only. Slack is included from the Plus plan.
  4. Deliver a deck per client. Open the client's project in PowerPoint or Google Slides, tick its datasets and describe the deck with the client's name and month. Or fill the agency's own template from =QUIRIZ.ASK() markers and press Build from markers. Word and Docs hold the written summary, with live figures in Word.
  5. Refresh next month. Connected data refreshes daily. In PowerPoint and Slides, Refresh all updates every figure and chart. In Word, refresh with tracked changes on, so the account lead sees which numbers moved before the client does.

What connecting a client's sources answers

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. These are questions a client report keeps asking and a single export cannot answer. The connector pages list every dataset and metric: Shopify, HubSpot, Google Ads, Meta Ads, Microsoft Ads, Google Analytics, Search Console, Klaviyo, QuickBooks and Harvest.

Cross-source figures beyond the automatic ones 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.

Many clients, one login

Each Quiriz company connects one account per tool: one Shopify store, one HubSpot portal. On Free, Plus and Pro a login covers one company, so a client whose tools you connect needs its own company. Inside a company, projects group a client’s datasets, questions and reports, which suits clients whose data comes in by upload or through a Sheet. On the Max plan, one admin login can also switch between several client companies, and a Clients portfolio view shows them together. Max also has unlimited add-in keys. Free, Plus and Pro cover one company per login.

One report setup, every client

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. Make a deck (Beta) 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:

  1. Agenda and executive summary.
  2. The headline numbers against last month and last year, as a table.
  3. Net sales by category: a bar chart.
  4. Spend and ROAS by platform: a table for the month.
  5. ROAS by platform by month: a line chart.
  6. Best and worst campaigns: a table.
  7. 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.

The fallback: any other source, through Google Sheets or Excel

Use the spreadsheet route for a source without a connector, such as LinkedIn Ads or TikTok, or when a client will not grant sign-in access. A connector tool writes the client's data to a Google Sheet or an Excel workbook on OneDrive, one file per client and one tab per source, refreshed every morning. Quiriz reads each tab as a dataset and refreshes it daily. It joins the connected data on date.

Connector tools that write to Google Sheets or Excel

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.

ToolStarting priceWhat it includesGoogle SheetsExcel on OneDriveFree plan or trial
API Connector$15/mo ($12 annually)2,500 requests a month. You set up the API requests yourself.DailyNoFree plan (no schedule)
Adveronix$29/mo5 ad accounts, 5 saved reports. No-code setup.Daily or hourlyNo2-week trial
Porter Metrics$15/mo for 1 account$40 for 4 accounts, $8 per account for 5–12, $100 for 13–20DailyNo14-day trial
Catchr$24/mo3 platforms, 10 accountsDailyNo14-day trial
Windsor.ai$23/mo ($19 annually)3 sources. All four sources from $118/mo ($99 annually), 75 accountsDaily, even on FreeManual refresh onlyFree plan (1 source, 1 account), 30-day trial
Dataslayer€20/mo billed annually3 sources, 3 accounts each. 7 sources and 50 accounts at €99/moDailyScheduledFree plan (1 source, manual refresh)
Supermetrics$55/mo ($44 annually)3 sources, 3 accounts per source, 1 userCheck the planScheduled14-day trial
SkyviaFree, then $79/mo billed annuallyFree plan runs once a day, up to 10,000 records a monthDailyAdds rows onlyFree 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:

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. Schedule the refresh for early morning, before the Quiriz refresh window you pick below.
  6. 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

  1. Open Import Data from the side navigation and click Google Drive.
  2. 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.
  3. Paste the Sheet's URL and click Load.
  4. Under Select Sheets, pick the tabs to import, then click Convert.
  5. 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

  1. Open Manage Data, select the dataset, and click Schedule Data Refresh.
  2. File Source is already set to Google Sheet, with the Sheet filled in.
  3. Set Refresh mode to By file ID.
  4. Set Check frequency to Daily and pick a time window, such as Morning (6am–12pm). Quiriz uses the timezone in My Preferences.
  5. 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

  1. Open Import Data and click OneDrive. If you see Connect Microsoft, click it and sign in with the Microsoft account that holds the workbook.
  2. 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=).
  3. Paste it and click Load. Tick the workbook in the file list, then click Import 1 file.
  4. When the import finishes, click Schedule refresh on the "Set up scheduled refresh for these files?" banner.
  5. 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

Sign up free → Connect one client's accounts and check the numbers against last month's report.

Pricing

Free is $0 (5 files). Plus is $12 a month ($120 a year), Pro $30 ($300) and Max $60 ($600). Connectors, Slack, scheduled reports and scheduled refresh start at Plus. You pay for the people who build, not for everyone who asks a question. Several client companies under one login, with the Clients portfolio view, is Max only. See pricing →

Your data stays yours, and we do not train on it. Privacy policy →

Related reading

Questions

Should I connect a client's accounts directly or use a connector tool and a spreadsheet?
Connect directly where Quiriz has a connector: Shopify, HubSpot, Google Ads, Meta Ads, Microsoft Ads, Google Analytics 4, Search Console, Klaviyo, QuickBooks and Harvest, plus Stripe, WooCommerce, PostHog, Bing Webmaster Tools, Salesforce (Beta) and GitHub. Connections are read-only, refreshed daily and included on paid plans. Use a connector tool and a spreadsheet for any source without a connector, such as LinkedIn Ads or TikTok, or if a client will not grant sign-in access.
Does Quiriz need access to my clients' ad or store accounts?
Only if you connect directly. Then someone with access to the client's account signs in once and approves read-only access, and Quiriz never writes to the source. If you use a connector tool and a spreadsheet instead, the tool holds those connections and Quiriz only needs view access to the Google Sheet or Excel workbook it writes to.
Can I run the same client deck for every client?
Yes. In Quiriz for PowerPoint or Google Slides, tick that client's datasets and describe the deck with that client's name and month; Make a deck (Beta) plans the slides for you to edit before it builds. Next month, Refresh all updates every figure and chart. To keep one agency template, type =QUIRIZ.ASK() markers on its slides and press Build from markers for each client.
Can I manage several client companies under one login?
Yes, on the Max plan. Max lets one admin login switch between several client companies and adds a Clients portfolio view. On Free, Plus and Pro, one login covers one company, and a company connects one account per tool (one Shopify store, one HubSpot portal), so each further client whose tools you connect needs its own Quiriz company.
Does my whole team need separate subscriptions?
No. People who only ask questions use the admin's keys in the add-ins and the admin's Slack binding, with no per-seat fee. Plus allows 5 add-in keys, Pro 10 and Max unlimited.
Will a metric mean the same thing for every client?
Yes. Connectors add pre-defined metrics, such as Google Ads ROAS or Shopify net sales, with the same formula for every client. An admin can edit a definition, and the daily refresh never overwrites an edited one. The Excel cell, the deck and the Slack answer all read the same definition.
Can Quiriz email the report to my client?
Not from Quiriz. It builds the deck, the Word report or the table in the tools you already use, and you send it to the client the way you do today.
Which connector tool should an agency start with, for sources without a connector?
For the lowest cost, API Connector starts at $15 a month if you are comfortable setting up API requests, and Adveronix starts at $29 a month with no-code setup. For one to three clients, Porter Metrics prices per connected account. Past about ten clients, Windsor.ai pools 75 accounts across sources. Any tool that writes to Google Sheets or an Excel workbook on OneDrive on a daily schedule works with Quiriz.
Can I use Excel instead of Google Sheets?
Yes. Use a connector tool that refreshes an Excel workbook saved in OneDrive on a schedule, such as Dataslayer or Supermetrics. Import the workbook into Quiriz from OneDrive and choose Refresh the same updated file, and Quiriz picks up each day's changes.
Should the connector use Replace or Append mode?
Replace. Ad platforms restate recent days as conversions come in, and a HubSpot deal changes stage after it is first written. In Append mode both become a second row and totals are counted twice. Replace over a fixed start date keeps one current row per record.
How often does Quiriz refresh the data?
Connected sources refresh daily. Spreadsheet and file sources refresh daily, weekly or monthly, in a time window you choose, in your own timezone. Run Now refreshes it on demand. Scheduled refresh is included from the Plus plan.