Google Ads Export Guide

GMSF v1.2 Google Ads 5 min install
🎯
Objective
This script automatically exports your Google Ads campaign data with the granularity needed for GMSF v1.2 carbon analysis in Carbon Intelligence™.
⚙️
Installation
3 steps · 5 minutes
Create the destination Google Sheet
  1. Go to sheets.new
  2. Rename the file: CI_Export_GoogleAds_[ClientName]
  3. Copy the Sheet URL
Install the script
  1. Log in to Google Ads
  2. Go to Tools and Settings → Bulk Actions → Scripts
  3. Click + (New script)
  4. Name the script: Carbon Intelligence Export
  5. Paste the content of carbon-intelligence-google-ads-export.js
  6. Replace COLLER_URL_GOOGLE_SHEET_ICI with your Google Sheet URL
  7. Click Authorize then Run
Schedule execution
  1. After the first successful run, click Create a schedule
  2. Select Weekly (Monday morning recommended)
  3. The script will run automatically every week
📊
What is exported
10 tabs created automatically
TabContentUsage Carbon Intelligence
CI_CampaignsSummary by campaign and weekEmissions overview
CI_DeviceBy device (mobile, desktop, tablet)Energy factor per device
CI_GeoBy country and regionGMSF v1.2 country energy mix
CI_PlacementsBy site and applicationEnergy-intensive placements
CI_CreativeSizeBy creative sizeData transfer weight
CI_AdFormatBy format (Search, Display, Video)Ad format factor
CI_VideoDetailed video dataVideo carbon calculation (duration, quartiles)
CI_MetadataAccount and export informationTraceability and audit
CI_DiagnosticIndividual query testsProblem identification
CI_Export_CSVAll dimensions consolidatedDirect CI platform import
📁
Export CSV
Two options available
Option A — From Google Sheets
  1. Go to the CI_Export_CSV tab
  2. File → Download → CSV (.csv)
Option B — Via the script
  1. Change the function to exportToCSV
  2. Run — a CSV file will be created in your Google Drive
  3. The file link appears in the logs
🔗
Sharing with Carbon Intelligence™
📨
Share the Google Sheet with: support@carbonintelligence.green (accès lecteur)
Or send the exported CSV by email to the same address.
⚠️
Uncovered dimensions
DimensionWhyAlternative
Connection type (WiFi/4G/5G)Not available in Google AdsAvailable via DV360 or TTD
Exchange (SSP)Google Ads = walled gardenAvailable via DV360 or TTD
Buy mode (Open/PMP)Specific to open programmaticAvailable via DV360 or TTD
Creative weight (KB)Not reported by Google AdsGMSF estimation by format type
Active View / ViewabilityBeing sunset by GoogleMetrics removed in v1.2.0
If you use DV360 or another DSP, contact us for a dedicated script.
🔧
Advanced Configuration
Script CONFIG section
// In the script, CONFIG section:

LOOKBACK_DAYS: 90,       // Days of history (default: 90)
MIN_IMPRESSIONS: 1,      // Minimum impression threshold per row
INCLUDE_PAUSED: true     // Include paused campaigns (recommended)
🔍
Diagnostic
Built-in diagnostic function
  1. In Google Ads > Scripts, open the script
  2. In the dropdown next to Run, select diagnose
  3. Click Run
  4. Open the Google Sheet and go to the CI_Diagnostic tab

The diagnostic tests: account access, each query type individually, active/paused campaign count, data availability per type (Device, Geo, Placements, Video...). Each test is color-coded: green (OK), yellow (empty but normal), red (error). If an error occurs, send a screenshot of the CI_Diagnostic tab to support@carbonintelligence.green.

🛠️
Troubleshooting
"Authorization required"
Normal on first run. Click Authorize and accept the permissions.
"Spreadsheet not found"
Check that the Google Sheet URL is correct in CONFIG.SPREADSHEET_URL.
All columns empty
Run the diagnose function (dropdown next to Run > select "diagnose"). Then check the CI_Diagnostic tab in the Google Sheet to identify the exact problem.
Paused campaigns
If your campaigns are paused, the script exports no data by default. In v1.2.0, INCLUDE_PAUSED is true by default. For earlier versions, set INCLUDE_PAUSED: true in the CONFIG section.
Missing data
Check that campaigns have impressions for the period. Adjust LOOKBACK_DAYS if needed.
Timeout
If the account has a lot of data, reduce LOOKBACK_DAYS to 30 days.
Empty tabs
Some tabs (Video, Placements) only fill if the relevant campaign types are active.
💬
Support
Email support@carbonintelligence.green
Website carbonintelligence.green
Script version 1.3.0
Methodology GMSF v1.2 (Ad Net Zero)
Carbon Intelligence™ — Installation Guide Google Ads — v1.3.0
ISO 14064 GHG Protocol ADEME Base Carbone GMSF v1.2 Ad Net Zero