ConnectBooks imports your Google Shopping ads data automatically. Other campaign types — like Search, Display, YouTube, and Performance Max — aren't included, because Google's API doesn't break down spend by individual product for those campaign types. Shopping ads are the exception, and they're also where most e-commerce sellers spend the bulk of their Google ad budget.
To verify that your numbers match, you'll build a report in Google Ads filtered to Shopping ads only. Here's how.
Step 1: Run the ConnectBooks Report
Open the report in ConnectBooks and select the Shopify store you want to analyze. Choose your date range, then click Customize and set "Display Items By" to Item ID (ASIN/GTIN). This is the identifier Google Ads uses per product — matching on Item ID is how you'll line up the two reports side by side.
Note: Confirm we have ad spend data for the full data range you selected.
Step 2: Build the Report in Google Ads
Log into Google Ads and confirm you're in the right merchant center. Then go to:
Insights and Reports → Reports Editor → Create Report.
From here you have two options:
Generate report — type something like "ad spend by item, for last month" in the text box and Google will build the report for you
Create report — click + Create report to build it manually by adding columns yourself in the bottom right
If building manually, add these four columns:
Item ID
Cost (which is ad spend)
Lead Revenue (sales from that SKU's ads)
Revenue (total ad sales)
Set the date range to match ConnectBooks.
Step 3: Filter for Shopping Ads Only
Click Filter in the center of the report. Filter by Ad Group Type and select the following:
Shopping - Product
Shopping - Showcase
Shopping - Smart
Shopping - Comparison Listing
Shopping - Collections
Checking Your Numbers
The totals after filtering should match ConnectBooks. Any spend from non-Shopping campaigns won't appear in ConnectBooks — that's expected, and not a discrepancy.
Once the report is generated, make sure its in a table format.
