Google Ads (Adwords)

Creating the data source

Instructions

Log in to the Kondado platform, go to the add connectors page and select the Google Adwords data source
Click on AUTHORIZE
Select the account you will use
On the next screen, check ALL the permissions that are required and click Continue
You will be redirected to Kondado and just give your data source a name and click on SAVE

💡Check out the FAQ guide for Google Ads integrations

See the FAQ guide for Google Ads integrations.

Pipelines

Relationship chart

Click to expand

Campaign Conversions by Action

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many days to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for daily updates with savepoint.

Google Ads campaign conversions detailed by conversion action.

Campo	Tipo
_kdd_account_id	text	[en] Google Ads account ID.
segments_date	date	[en] Date to which metrics apply. yyyy-MM-dd format.
campaign_id	text	[en] The ID of the campaign.
campaign_name	text	[en] The name of the campaign.
segments_conversionactionname	text	[en] The name of the conversion action.
segments_conversionactioncategory	text	[en] The category of the conversion action.
metrics_conversions	float	[en] The number of conversions.
metrics_conversionsvalue	float	[en] The total value of conversions.
metrics_allconversions	float	[en] Total number of conversions (including non-counted conversions).
metrics_allconversionsvalue	float	[en] The total value of all conversions.

Campaign Performance Daily

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many days to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for daily updates with savepoint.

Daily campaign performance from Google Ads with metrics aggregated by campaign and date.

Campo	Tipo
_kdd_account_id	text	[en] Google Ads account ID.
segments_date	date	[en] Date to which metrics apply. yyyy-MM-dd format.
campaign_id	text	[en] The ID of the campaign.
campaign_name	text	[en] The name of the campaign.
campaign_advertising_channel_type	text	[en] The primary serving target for ads within the campaign (e.g., SEARCH, DISPLAY, VIDEO).
campaign_status	text	[en] The status of the campaign (ENABLED, PAUSED, REMOVED).
metrics_impressions	float	[en] Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_clicks	float	[en] The number of clicks.
metrics_cost_micros	float	[en] The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, in micros.
metrics_conversions	float	[en] The number of conversions.
metrics_ctr	float	[en] Click-through rate (CTR): the number of clicks divided by the number of impressions.
metrics_average_cpc	float	[en] Average cost-per-click: the total cost of all clicks divided by the total number of clicks.

Custom report

Important notes about this integration:

This integration fetches the actual performance data of your ads and allows you to define exactly how you want to fetch your data, according to the selected report, metrics and dimensions
As it is possible to fetch data from multiple accounts in the same integration (including MCC), by default the table of this integration will contain the __kdd_account_id column that indicates which account the data refers to

Replication type: Full

Parameters:

Dimensions: Select the report dimensions. More on: kondado.com.br/wiki
Metrics: Select the report metrics. More on: kondado.com.br/wiki
Report: Select which report to use. More on: kondado.com.br/wiki
Read start date (Savepoint): Initial date for the data replication
Update window: How many periods previous to the savepoint the data should be updated. More on: kondado.com.br/wiki
Accounts: Filter which Accounts to include in the replication or leave it empty to include all

Replication type: Full

Parameters:

Dimensions: Select the report dimensions. More on: kondado.com.br/wiki
Metrics: Select the report metrics. More on: kondado.com.br/wiki
Report: Select which report to use. More on: kondado.com.br/wiki
Read start date (Savepoint): Initial date for the data replication
Update window: How many periods previous to the savepoint the data should be updated. More on: kondado.com.br/wiki
Accounts: Filter which Accounts to include in the replication or leave it empty to include all

Campo	Tipo
_kdd_account_id	text
dimension_x	text
dimension_y	date
dimension_z	text
metric_a	float
metric_b	int
metric_c	float

Ad Performance Daily

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many days to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for daily updates with savepoint.

Daily ad performance from Google Ads with metrics aggregated by ad and date - *PMAX campaign data is not returned*

Campo	Tipo
_kdd_account_id	text	[en] Google Ads account ID.
segments_date	date	[en] Date to which metrics apply. yyyy-MM-dd format.
campaign_id	text	[en] The ID of the campaign.
campaign_name	text	[en] The name of the campaign.
ad_group_id	text	[en] The ID of the ad group.
ad_group_name	text	[en] The name of the ad group.
ad_group_ad_ad_id	text	[en] The ID of the ad.
ad_group_ad_ad_name	text	[en] The name of the ad.
metrics_impressions	float	[en] Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_clicks	float	[en] The number of clicks.
metrics_cost_micros	float	[en] The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, in micros.
metrics_conversions	float	[en] The number of conversions.
metrics_conversions_value	float	[en] The total value of conversions.
metrics_all_conversions	float	[en] Total number of conversions (including non-counted conversions).
metrics_all_conversions_value	float	[en] The total value of all conversions.

Ad Conversions by Action

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many days to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for daily updates with savepoint.

Ad conversions by action from Google Ads with conversion metrics aggregated by ad, conversion action and date.

Campo	Tipo
_kdd_account_id	text	[en] Google Ads account ID.
segments_date	date	[en] Date to which metrics apply. yyyy-MM-dd format.
campaign_id	text	[en] The ID of the campaign.
campaign_name	text	[en] The name of the campaign.
ad_group_id	text	[en] The ID of the ad group.
ad_group_name	text	[en] The name of the ad group.
segments_conversion_action_name	text	[en] The name of the conversion action.
segments_conversion_action_category	text	[en] The category of the conversion action.
metrics_conversions	float	[en] The number of conversions.
metrics_all_conversions	float	[en] Total number of conversions (including non-counted conversions).
metrics_all_conversions_value	float	[en] The total value of all conversions.

Campaign Video Performance

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many days to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for daily updates with savepoint.

Campaign video performance from Google Ads with video views and engagement metrics aggregated by campaign and date.

Campo	Tipo
_kdd_account_id	text	[en] Google Ads account ID.
segments_date	date	[en] Date to which metrics apply. yyyy-MM-dd format.
campaign_id	text	[en] The ID of the campaign.
campaign_name	text	[en] The name of the campaign.
customer_id	text	[en] The ID of the customer.
customer_descriptive_name	text	[en] Descriptive name of the customer.
metrics_impressions	int	[en] Count of how often your ad appeared.
metrics_clicks	int	[en] Number of clicks.
metrics_cost_micros	int	[en] The sum of CPC and CPM costs in micros.
metrics_video_trueview_views	int	[en] The number of times your TrueView video ads were viewed.
metrics_video_quartile_p25_rate	float	[en] Percentage of impressions where the viewer watched 25% of the video.
metrics_video_quartile_p50_rate	float	[en] Percentage of impressions where the viewer watched 50% of the video.
metrics_video_quartile_p75_rate	float	[en] Percentage of impressions where the viewer watched 75% of the video.
metrics_video_quartile_p100_rate	float	[en] Percentage of impressions where the viewer watched 100% of the video.
metrics_engagements	int	[en] Number of engagements. An engagement occurs when a viewer expands your lightbox ad.

Ad Group Performance Daily

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many days to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for daily updates with savepoint.

Daily ad group performance from Google Ads with metrics aggregated by ad group and date.

Campo	Tipo
_kdd_account_id	text	[en] Google Ads account ID.
segments_date	date	[en] Date to which metrics apply. yyyy-MM-dd format.
campaign_id	text	[en] The ID of the campaign.
campaign_name	text	[en] The name of the campaign.
ad_group_id	text	[en] The ID of the ad group.
ad_group_name	text	[en] The name of the ad group.
ad_group_status	text	[en] The status of the ad group (ENABLED, PAUSED, REMOVED).
metrics_impressions	float	[en] Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_clicks	float	[en] The number of clicks.
metrics_cost_micros	float	[en] The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, in micros.
metrics_conversions	float	[en] The number of conversions.
metrics_ctr	float	[en] Click-through rate (CTR): the number of clicks divided by the number of impressions.
metrics_average_cpc	float	[en] Average cost-per-click: the total cost of all clicks divided by the total number of clicks.

Keyword Performance Daily

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many days to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for daily updates with savepoint.

Daily keyword performance from Google Ads with metrics aggregated by keyword and date.

Campo	Tipo
_kdd_account_id	text	[en] Google Ads account ID.
segments_date	date	[en] Date to which metrics apply. yyyy-MM-dd format.
campaign_id	text	[en] The ID of the campaign.
campaign_name	text	[en] The name of the campaign.
ad_group_id	text	[en] The ID of the ad group.
ad_group_name	text	[en] The name of the ad group.
ad_group_criterion_keyword_text	text	[en] The text of the keyword.
ad_group_criterion_keyword_match_type	text	[en] The match type of the keyword (EXACT, PHRASE, BROAD).
metrics_impressions	float	[en] Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_clicks	float	[en] The number of clicks.
metrics_cost_micros	float	[en] The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, in micros.
metrics_conversions	float	[en] The number of conversions.
metrics_ctr	float	[en] Click-through rate (CTR): the number of clicks divided by the number of impressions.
metrics_average_cpc	float	[en] Average cost-per-click: the total cost of all clicks divided by the total number of clicks.
metrics_search_impression_share	float	[en] The percentage of search impressions your ad received compared to the estimated total of search impressions you were eligible to receive.

Geographic Performance

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many months to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for updates with savepoint.

Geographic performance from Google Ads with metrics aggregated by location, campaign and month.

Campo	Tipo
_kdd_account_id	text	[en] Google Ads account ID.
segments_month	date	[en] Month to which metrics apply. yyyy-MM-dd format (first day of month).
campaign_id	text	[en] The ID of the campaign.
campaign_name	text	[en] The name of the campaign.
segments_geo_target_city	text	[en] City geo target name where the ad appeared.
segments_geo_target_state	text	[en] State geo target name where the ad appeared.
metrics_impressions	float	[en] Count of how often your ad has appeared on a search results page or website on the Google Network.
metrics_clicks	float	[en] The number of clicks.
metrics_cost_micros	float	[en] The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, in micros.
metrics_conversions	float	[en] The number of conversions.
metrics_average_cpc	float	[en] Average cost-per-click: the total cost of all clicks divided by the total number of clicks.
metrics_cost_per_conversion	float	[en] Average cost per conversion: the total cost divided by the number of conversions.

Age Demographics Performance

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many months to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for updates with savepoint.

Age demographics performance from Google Ads.

Campo	Tipo
_kdd_account_id	text	[en] Account ID.
segments_date	date	[en] Date.
campaign_id	text	[en] Campaign ID.
campaign_name	text	[en] Campaign name.
ad_group_criterion_age_range_type	text	[en] Age range.
metrics_impressions	float	[en] Impressions.
metrics_clicks	float	[en] Clicks.
metrics_cost_micros	float	[en] Cost in micros.
metrics_conversions	float	[en] Conversions.

Campaign Budget Analysis

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many months to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for updates with savepoint.

Campaign budget analysis from Google Ads.

Campo	Tipo
_kdd_account_id	text	[en] Account ID.
segments_date	date	[en] Date.
campaign_id	text	[en] Campaign ID.
campaign_name	text	[en] Campaign name.
campaign_budget_amount_micros	float	[en] Budget in micros.
campaign_start_date	date	[en] Start date.
campaign_end_date	date	[en] End date.
metrics_cost_micros	float	[en] Cost in micros.
metrics_impressions	float	[en] Impressions.
metrics_clicks	float	[en] Clicks.
metrics_conversions	float	[en] Conversions.

Gender Demographics Performance

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many months to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for updates with savepoint.

Gender demographics performance from Google Ads.

Campo	Tipo
_kdd_account_id	text	[en] Account ID.
segments_date	date	[en] Date.
campaign_id	text	[en] Campaign ID.
campaign_name	text	[en] Campaign name.
ad_group_criterion_gender_type	text	[en] Gender.
metrics_impressions	float	[en] Impressions.
metrics_clicks	float	[en] Clicks.
metrics_cost_micros	float	[en] Cost in micros.
metrics_conversions	float	[en] Conversions.

Search Terms Report

Replication type: Full

Parameters:

Read start date (Savepoint): Initial date for data replication.
Update window: How many months to look back from savepoint to update data.
Accounts: Select the accounts to fetch data from. Leave empty to include all accounts.
Period: Select the data period to fetch. Use Incremental for updates with savepoint.

Search terms report from Google Ads.

Campo	Tipo
_kdd_account_id	text	[en] Account ID.
segments_date	date	[en] Date.
campaign_id	text	[en] Campaign ID.
campaign_name	text	[en] Campaign name.
ad_group_id	text	[en] Ad group ID.
ad_group_name	text	[en] Ad group name.
search_term_view_search_term	text	[en] Search term.
metrics_impressions	float	[en] Impressions.
metrics_clicks	float	[en] Clicks.
metrics_cost_micros	float	[en] Cost in micros.
metrics_conversions	float	[en] Conversions.

Notes

Some metrics and dimensions cannot be combined, so during the integration creation process, the list of available metrics and dimensions will be constantly reloaded for a few seconds
All selected dimensions will be replication keys, along with __kdd_account_id
The integration can be full or incremental, depending on the selected dimensions. The dimensions that will make the integration incremental are: Date, Week, Month, Quarter and Year. If the integration is full, the savepoint will not be updated after each run
Integrations will include "zero impressions"
There may be a variation in results depending on the report attribution type
In some cases, certain dimensions may filter results. For example, using a keyword-type dimension will cause video ads not to be returned
Performance Max (Pmax) campaigns do not have ad groups. Therefore, they may not be returned in integrations that use ad group dimensions, requiring a separate integration to fetch Pmax data
Only data from Active accounts is fetched
Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Account access denied behavior: If the Accounts parameter is filled with more than 10 accounts, the integration will continue running even if access to one of the accounts is lost - it will simply skip the account without access and continue with the others. If there are fewer than 10 accounts or the Accounts parameter is not filled (automatically fetching all accounts), the integration will fail if access to any account is lost.

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information