Skip to content
DuckHouse

For online stores

Orders, ads and traffic,
side by side.

Shopify has your orders, Meta has what the ads cost, Google Analytics has who visited and QuickBooks has the books. Each one shows its own numbers. DuckHouse brings them into one place, so you can see what the ads earned and which customers come back.

Get started How it works

Works with Shopify, Meta Ads, Google Analytics and QuickBooks Online.

Someone packing an order into a cardboard box at a desk, with a laptop behind.

What did we spend on Meta ads each day last week, and how many orders came in?

Read meta_ads.ad_insights_daily, shopify.orders

You spent $1,240 on Meta ads last week and took 186 orders. Thursday, the day the launch post ran, was best: $310 spent, 52 orders. Orders by day:

An example answer. The business and its numbers are made up.

Questions you can answer

The things you’ve always wanted to know.

Each of these comes from data your tools already have. DuckHouse puts it side by side.

“What did each ad campaign cost, against the orders that week?”

Daily Meta spend beside Shopify orders by day.

Meta AdsShopify

“How many customers come back for a second order?”

Shopify customers and the dates of their orders.

Shopify

“How much gets refunded each month, against what sold?”

Shopify refunds beside order totals, month by month.

Shopify

“Which products are bought together?”

The line items on every Shopify order.

Shopify

“Is more traffic turning into more orders, or just more visits?”

Daily visits from Google Analytics beside Shopify orders on the same days.

Google AnalyticsShopify

How it works

Three steps, no data team.

You keep using the tools you have. DuckHouse gathers what they know.

  1. 1. Create a database

    It runs on its own machine with its own storage. There is nothing to install.

  2. 2. Connect your tools

    Sign in or paste a key for each one. DuckHouse only reads from them, brings in your history, then keeps up, as often as every 15 minutes for Shopify.

  3. 3. Ask in plain English

    Connect Claude or ChatGPT to DuckHouse and ask: “What did we spend on Meta ads each day last week, and how many orders came in?” It looks in your data and answers. How to connect an assistant.

What it connects

The tools you already use.

What DuckHouse brings in from each, and how you connect it.

Shopify

Orders and their line items, refunds, customers and products.

Create an app in Shopify’s Dev Dashboard and paste its client ID and secret. New data comes in as often as every 15 minutes.

How to connect Shopify

Meta Ads

Campaigns, ad sets and ads, with spend, reach and clicks by day.

Paste a system user token from Meta’s Business Settings that can read your ads. New data comes in as often as every hour.

How to connect Meta Ads

Google Analytics

Daily visits, pages, events, devices and countries.

Add DuckHouse as a Viewer on your Analytics property. No password to share. New data comes in as often as every hour.

How to connect Google Analytics

QuickBooks Online

Your books: bills, payments and accounts.

Sign in with your Intuit account. New data comes in as often as every hour.

How to connect QuickBooks Online

An example

A small apparel brand

A made-up example, not a customer.

  1. 1

    The founder connects Shopify, Meta Ads and Google Analytics. Orders come in every 15 minutes, ads and traffic every hour.

  2. 2

    After a launch, they ask Claude what the new campaign spent each day and how many orders came in on those days.

  3. 3

    Before the next drop, they ask which customers bought twice in the last year, to email them first.

Hands taping up a parcel wrapped in brown paper.
Photos by Bench Accounting and Compagnons on Unsplash.

What it costs

Pay for the hours it runs.

The smallest database is $0.0117 an hour while it runs. Left on all month with its 10 GB disk, it comes to $10.80. Set it to stop when idle and you pay for the hours it is awake, plus the disk. Data kept in object storage is $0.02 per GB a month.

Every sync wakes the database, so one synced every 15 minutes is awake most of the day. Syncing every hour, or once a day, lets it sleep in between, and you can change that per connection whenever you like.

See full pricing

Questions

Before you start.

Do I need to know SQL?
No. Connect Claude or ChatGPT to DuckHouse and ask in plain English; it writes the query and shows you the answer. If you or your bookkeeper know SQL, the dashboard has a query console too.
Will DuckHouse change anything in my other tools?
No. Connections only read. DuckHouse copies your data into your own database and never writes back to Square, QuickBooks, Shopify, Stripe or anything else.
Who can see my data?
Your database runs on its own machine with its own storage, and only people you invite to your organization can open it. AI assistants reach it only after someone in your organization signs them in, and they can only read unless you allow more.
Can my bookkeeper or manager use it too?
Yes. Invite them to your organization and they can ask questions of the same data.
What if my software isn’t listed?
Most business software can export CSV files. Save them to an SFTP or FTP folder and DuckHouse loads them on a schedule, or keep the data in a Google Sheet. PostgreSQL and MySQL databases connect directly.
What does it cost?
The smallest database is $0.0117 an hour while it runs. Left on all month with its 10 GB disk, it comes to $10.80. Set it to stop when idle and you pay for the hours it is awake, plus the disk. Data kept in object storage is $0.02 per GB a month. There are no contracts or minimums.

Put your numbers in one place.

No contracts and no minimums. Connect the tools you use, and stop the database whenever you like.

Get started Other businesses