Google Ads

The Google Ads connector brings your Google ad campaign data into the sheet: impressions, clicks, cost, conversions and more. The report level (account, campaign, ad group or individual ad) is chosen automatically based on the selected metrics/dimensions.

Monetary values (cost, CPC, CPM, etc.) come from the API in millionths of a currency unit and are automatically converted to the real amount: no manual conversion needed.

Permessi richiesti

• adwords : Needed to read your Google Ads account data (campaigns, ad groups, ads, statistics).

Metriche disponibili

There is no fixed list: metrics and dimensions are read live from your account through the Google Ads API (including any custom conversion variables configured on the account). Full official reference: Google's metrics catalog.

Dimensioni disponibili

There is no fixed list: dimensions (called "segments"/"attributes" in Google's documentation) are read live from your account. Full official reference: Google's dimensions catalog.

Limiti noti

• Account list: slower with more manager (MCC) accounts
  Google Ads doesn't natively offer a single-call way to list accounts across multiple manager accounts: our system compensates for this with additional calls per connected manager account. With many manager accounts, the initial list load may therefore take a bit longer than other connectors.
• The "Property id" cell format when chosen through a manager account (MCC)
  If you pick the account from the sidebar, this cell is filled in automatically and you do not need to touch it. If you type or edit it by hand instead: for an account managed through a manager account (MCC), the format is <code>account_ID|manager_account_ID</code> (the two IDs separated by the <code>|</code> symbol, with or without dashes). For an account with no MCC, just the <code>account_ID</code> is enough.