Google Ads (Adwords)

Google Ads is an online advertising platform created by Google, through which companies have the possibility to stand out by creating ads and promoting themselves on the search platform. The Google Ads data integration for the Data Warehouse created by Kondado allows you to have access to your ads and search data in your analytical cloud.

Adding the data source

To automate Google Ads ETL with Kondado for your database, follow the steps below:

1) On the Kondado platform, go to the add new sources page and select the Google Adwords data source;

2) Click AUTHORIZE

3) Select the account you will use

4) On the next screen, check ALL permissions that are required and click Continue

5) You will be redirected to Kondado and all you have to do is give your data source

a name and click on SAVE

Pipelines

Summary

Custom Report

Relationship Chart

Clique para ampliar

Custom Report

This pipeline retrieves the actual performance data of your ads and allows you to define exactly how you want to retrieve your data, according to the report, metrics and selected dimensions, which can be consulted here

As it is possible to fetch data from several accounts in the same integration (including with MCC) by default the table of this integration will contain the column __kdd_account_id that indicates which account the returned data refer to. In addition to this column, the table created will also have columns for the selected dimensions and metrics, with a structure similar to this one:

Field	Type
__kdd_account_id	text
dimension_x	text
dimension_y	date
dimension_z	text
metric_a	float
metric_b	int
metric_c	float

1.Some metrics and dimensions cannot be combined, so during the process of creating the pipeline, the list of possible metrics and dimensions will constantly reload for a few seconds to reflect the metrics and dimensions that can be selected
2.All selected dimensions will be replication keys along with __kdd_account_id
3.The pipeline can be integral or incremental, depending on the selected dimensions. The dimensions that will make the pipeline incremental are: Date, Week, Month, Quarter and Year. If the pipeline is incremental, in addition to the initial savepoint, it will be necessary to provide an update window. The update window value will be subtracted from the savepoint at the time of the replication, to update past data. This value can be days or months, depending on the shortest period selected, in this order: Date=days, Week=days, Month=months, Quarter=months, Year=months
4.Integrations will include “zero impressions”
5.There may be a variation of results depending on the type of report attribution
6.In some cases, certain dimensions can filter the results. For example, using a keyword-type dimension will cause video ads not to be returned.
7.Campaigns of the type “Performance Max (Pmax)” do not have an ad group. Therefore, they may not be returned in integrations that use ad group dimensions, requiring an integration without this dimension for these campaigns to be returned