Skip to content

Marketing and ads

Connect Google Ads to DataxLand

The Google Ads connector reads accounts, campaigns, ad groups, ads and daily performance - spend, impressions, clicks, conversions and the conversion value Google reports - through the Google Ads API. DataxLand puts spend next to real net revenue from your website, marketplaces or database, and next to leads in your CRM, so you know which Search, Shopping or Performance Max campaigns really bring profit or customers, not only conversions as Google counts them.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with Google Ads

  • Compare the ROAS Google Ads reports with true ROAS on net revenue from Shopify, WooCommerce or your database.
  • Track cost per lead and customer acquisition cost by combining with HubSpot or Salesforce.
  • Add Google, Facebook and TikTok ad spend into total marketing spend over revenue.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
customerGoogle Ads accounts, currency and time zone.
campaignCampaigns, type, status, daily numbers.
campaign_budgetCampaign budgets.
ad_groupAd groups and daily numbers.
ad_group_adAds within ad groups and daily numbers.
account_performance_reportDaily account performance - spend, impressions, clicks, conversions.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inGoogle Credentials
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2
Technical docsConnector documentation ↗

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Ad-reported vs actual revenue gapAd-platform-reported revenue minus actual net revenue for the same channel and period. Positive means the platform reports more than reality.= ad_conversion_value - Net revenueCurrency
Marketing spendTotal cost of marketing campaigns by spend date.Currency
ImpressionsTotal impressions (or reach) of campaigns by day.Count
ClicksTotal clicks (or engagements that drive traffic) of campaigns by day.Count
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
Cost per lead (CPL)Marketing spend divided by leads created in the period.= Marketing spend / LeadsCurrency
Customer acquisition cost (CAC)Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketingCurrency

Connect Google Ads in 4 steps

  1. 1

    Prepare API access

    Get a developer token in the API Center of your Google Ads manager account, create an OAuth client (client ID, secret) in Google Cloud and generate a refresh token for a user with read access.

  2. 2

    Add the source

    In the workspace choose Add source, find Google Ads in the connector library, enter developer token, client ID, client secret, refresh token and Customer ID, click Test connection.

  3. 3

    Choose streams

    Pick campaigns, ad groups and daily reports; numbers load incrementally by day.

  4. 4

    Review Si's mapping

    Si proposes how spend joins your sales channels and products; you approve and build.

Limits and caveats

  • The Google Ads API needs a developer token approved by Google; it is done once on the manager account and can take a few days.
  • DataxLand does not run the Google sign-in for you; you create the OAuth client and refresh token and paste them into the form.
  • Google restates conversions within the conversion window (14 days by default); the connector re-reads that window on each load.
  • True ROAS needs a sales source; cost per lead and CAC need leads or new customers from a CRM. This is an Airbyte connector (ELv2) run inside DataxLand.

Frequently asked questions

Can I use a manager (MCC) account?

Yes; enter the Customer IDs to read, separated by commas.

Does it change campaigns?

No. DataxLand only reads numbers; it never creates, edits or pauses campaigns.

Is Google's conversion value used as revenue?

No. Google-reported conversion value stays separate (platform ROAS); real revenue comes from your sales source for true ROAS.

Dashboard templates that use this source

Ask Si about your Google Ads data →Google Ads + BigQuery →Google Ads + HubSpot →Google Ads + Shopify →All data sources →

Connect Google Ads and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes