How to Compare Google Ad Spend to ConnectBooks

Before you start, choose the date range you want to compare.

For July 2026 and later, ConnectBooks includes both:

Unitemized spend means ads that are not connected to one specific product.

For dates before July 2026, ConnectBooks includes Shopping/Product ads only. If you are checking dates before July 2026, use Option 2 below.
​

Use this option when your date range is July 2026 or later and you want to confirm that the total spend matches.

Open the report in ConnectBooks.

Select the correct shopify store and date range.

Find the Ads Spend total.
​

Open Google Ads.

Go to Insights & Reports → Reports Editor.

By generate report, put in "total ad spend by type", and the date range you want

Make sure the report is shown as a table.

Compare the Total Cost in Google Ads to the Google Ads Spend total in ConnectBooks.

For July 2026 and later, these totals should match.

Use this option when you are checking dates before July 2026, or when you want to compare the spend per item.

This comparison only applies to Shopping/Product ads.

Open the report in ConnectBooks.

Select the correct store and date range.

Click Customize.

Set Display Items By to Item ID (ASIN or GTIN).

Open Google Ads.

Go to Insights & Reports → Reports Editor.

Create a product-level report for the same date range.

Include these columns:

In the Google Ads report, filter by Ad Group Type.

Select the Shopping ad types only.

Match the rows in both reports using Item ID.

Then compare the Cost in Google Ads to the Shopping/Product ad spend in ConnectBooks.

The Shopping/Product ad spend should match between both reports.