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 |
|---|---|
| customer | Google Ads accounts, currency and time zone. |
| campaign | Campaigns, type, status, daily numbers. |
| campaign_budget | Campaign budgets. |
| ad_group | Ad groups and daily numbers. |
| ad_group_ad | Ads within ad groups and daily numbers. |
| account_performance_report | Daily account performance - spend, impressions, clicks, conversions. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Google Credentials |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
| Technical docs | Connector 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.
| Metric | Definition | Unit |
|---|---|---|
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Platform-reported ROAS | Ad-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spend | Number |
| Blended ROAS | Actual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spend | Number |
| Ad-reported vs actual revenue gap | Ad-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 revenue | Currency |
| Marketing spend | Total cost of marketing campaigns by spend date. | Currency |
| Impressions | Total impressions (or reach) of campaigns by day. | Count |
| Clicks | Total clicks (or engagements that drive traffic) of campaigns by day. | Count |
| Click-through rate (CTR) | Clicks divided by impressions.= Clicks / Impressions | Ratio (%) |
| Cost per lead (CPL) | Marketing spend divided by leads created in the period.= Marketing spend / Leads | Currency |
| Customer acquisition cost (CAC) | Marketing spend divided by new customers (by conversion date).= Marketing spend / New customers from marketing | Currency |
Connect Google Ads in 4 steps
- 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
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
Choose streams
Pick campaigns, ad groups and daily reports; numbers load incrementally by day.
- 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
Connect Google Ads and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes