Connect your Google Ads account to import your advertising costs into your Profit & Loss report automatically.
Google Ads is built for Shopify stores.
Step 1: Go to the Integrations page
In the left menu, click Integrations, scroll to the Advertising section, and click Connect next to Google Ads.
Step 2: Authorize with Google
Click Connect Google Ads, sign in to your Google account, and click Allow to give ConnectBooks access.
Step 3: Map your store
You'll see a table with your connected stores. For each Shopify store that runs Google Ads, fill in 3 fields:
Google Ads Customer: the Google Ads account linked to that store.
Mapping Rule: how ConnectBooks matches ad spend to your products.
Using Shopify's own Google integration: select Internal Product ID.
Using a third party feed tool: select the ID that tool uses for your Shopify products. Check your feed tool's settings if you're not sure.
Start Date: the date ConnectBooks starts importing ad spend from. See "Choosing a Start Date" below before you set it.
Leave stores you don't advertise on Google blank.
Click Save.
What ConnectBooks imports
ConnectBooks imports all your Google Ads spend, in 2 forms:
Product ad spend: spend Google ties to a specific product. This comes from Shopping campaigns and from the product part of Performance Max campaigns. It's matched to your products using your Mapping Rule, and comes with the ad sales for each product.
Campaign spend: spend that isn't tied to 1 product. This covers Search, Display, Video, Demand Gen and App campaigns, plus the rest of your Performance Max spend.
Both show in your Profit & Loss report under ad spend.
Google ad spend is for reporting only. It is not sent to QuickBooks.
Which dates include what
ConnectBooks has brought in more types of Google Ads spend over time:
From October 15, 2026: all Google Ads spend, including Performance Max.
July 1 to October 14, 2026: all Google Ads spend except Performance Max.
Before July 2026: Shopping and product ads only.
To check your numbers against Google Ads for any of these periods, see How to Compare Google Ad Spend to ConnectBooks.
Choosing a Start Date
The Start Date decides how much history ConnectBooks brings in, so set it carefully.
ConnectBooks can import up to 15 months of history.
If you leave the Start Date empty, ConnectBooks starts 60 days back.
It won't import spend from before the date ConnectBooks started tracking that store.
Moving the Start Date earlier makes ConnectBooks import from the new date on its next sync, so days that were never imported will come in. Dates that were already imported and are more than about 2 weeks old won't change. Contact support for those.
Frequently asked questions
My Google ad spend isn't showing on my products.
Check the Mapping Rule for your store. Shopify stores start on Internal Product ID. If your feed tool uses another ID, change the Mapping Rule to that ID and click Save. If the Mapping Rule doesn't match the ID your product feed uses, ConnectBooks can't tell which product the spend belongs to.
The spend isn't lost. It's still counted in your total, and shows on the Unitemized line when you view the Profit & Loss report by item. It just won't appear in per product profit.
Once you pick the ID your feed uses, ConnectBooks links recent spend to your products on its next sync. Spend from more than about 2 weeks ago stays on the Unitemized line. Contact support if you need those dates matched again.
ConnectBooks shows little or no Google spend for my earliest dates.
Those dates are probably before your Start Date. ConnectBooks only imports spend from the Start Date onward. Move the Start Date earlier and ConnectBooks will import from the new date on its next sync. See "Choosing a Start Date" above.
Do I connect each store separately?
You connect Google Ads once, then map each Shopify store to its Google Ads account in the table in Step 3. Each store gets its own Mapping Rule and Start Date.
Is Google ad spend sent to QuickBooks?
No. It's used for reporting in ConnectBooks only.
Can I connect Google Ads to a store that isn't on Shopify?
Not yet. Google Ads is built for Shopify stores.
My recent numbers changed after a day or 2.
That's expected. Google keeps adjusting recent spend for a while, for example when it credits back invalid clicks. ConnectBooks checks the last 14 days again on every sync, so it picks up those changes.
How do I check that the numbers match Google Ads?
Follow How to Compare Google Ad Spend to ConnectBooks. It explains which Google report to run for your dates.