> For the complete documentation index, see [llms.txt](https://help.daasity.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/google-ads/integration-specifications.md).

# Integration Specifications

## **Integration Overview**

Google is the place people go to search for information, places, products, and more, so this is where brands want to make sure they have a presence. Show up when users search in text, product listing, video ads, and more with Ads.

The Daasity Google Ads integration extracts key advertising information from the Google platform, like spend, clicks, and impressions. Because Google has several networks, info is available in the area of Google (i.e., Youtube, Text Search) and by the campaign.

## **Integration Availability**

This integration is available for:

* Enterprise
* Growth

## **API Endpoints**

The Daasity Google Ads extractor is built based on this [Google Ads API Documentation](https://developers.google.com/google-ads/api/docs/start). The following endpoints are used by Daasity to replicate data from Google Ads.

* [Reports](https://developers.google.com/google-ads/api/docs/reporting/overview)

## **Entity Relationship Diagram (ERD)**

[Click here to view the ERD for the Daasity Google Ads integration](https://lucid.app/documents/embedded/455c6558-5c32-49fa-8530-b437327b00c0) illustrating the different tables and keys to join across tables.

## **Google Ads Schema**

The Daasity Google Ads extractor creates these tables using the endpoints and replication methods listed. The data is mapped from the source API endpoint to the table based on the mapping logic outlined in each table. JSON Elements are the fields of the Google Ads API (GAQL) report rows; money columns ending in micros, and `cost`, are stored in micros as returned by the API.

By default the integration extracts Ads, Ad Groups, Campaigns, Keywords and Campaign Product Performance. Geo Campaigns and Geo Ad Groups are optional reports that can be enabled on the integration.

* [Ads](#a-ds)
* [Ad Groups](#a-d-groups)
* [Campaigns](#campaigns)
* [Keywords](#keywords)
* [Campaign Product Performance](#campaign-product-performance)
* [Geo Campaigns](#geo-campaigns)
* [Geo Ad Groups](#geo-ad-groups)

### **Ads**

* Endpoint: [Reports](https://developers.google.com/google-ads/api/docs/reporting/overview)
* Update Method: UPSERT
* Table Name: \[`adwords.ads`]

| JSON Element                                                                                                                               | Database Column                      |
| ------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------ |
| MD5(adGroupAd.ad.id + segments.date)                                                                                                       | id                                   |
| segments.date                                                                                                                              | date                                 |
| segments.device                                                                                                                            | device                               |
| adGroupAd.ad.legacyResponsiveDisplayAd.businessName                                                                                        | business\_name                       |
| customer.descriptiveName                                                                                                                   | account\_descriptive\_name           |
| customer.currencyCode                                                                                                                      | account\_currency\_code              |
| adGroupAd.ad.addedByGoogleAds                                                                                                              | automated                            |
| adGroupAd.adGroup (ID from the resource name)                                                                                              | ad\_group\_id                        |
| adGroupAd.ad.id                                                                                                                            | adwords\_ad\_id                      |
| adGroupAd.ad.type                                                                                                                          | ad\_type                             |
| segments.adNetworkType                                                                                                                     | ad\_network\_type1                   |
| segments.adNetworkType                                                                                                                     | ad\_network\_type2                   |
| metrics.activeViewCpm                                                                                                                      | active\_view\_cpm                    |
| metrics.activeViewCtr                                                                                                                      | active\_view\_ctr                    |
| metrics.activeViewImpressions                                                                                                              | active\_view\_impressions            |
| metrics.averageCost                                                                                                                        | average\_cost                        |
| metrics.averageCpc                                                                                                                         | average\_cpc                         |
| metrics.averageCpm                                                                                                                         | average\_cpm                         |
| metrics.trueviewAverageCpv                                                                                                                 | average\_cpv                         |
| adGroupAd.ad.legacyResponsiveDisplayAd.callToActionText                                                                                    | call\_to\_action\_text               |
| metrics.clicks                                                                                                                             | clicks                               |
| metrics.conversions                                                                                                                        | conversions                          |
| metrics.conversionsValue                                                                                                                   | conversion\_value                    |
| metrics.costMicros                                                                                                                         | cost                                 |
| metrics.allConversions                                                                                                                     | all\_conversions                     |
| metrics.allConversionsValue                                                                                                                | all\_conversion\_value               |
| metrics.crossDeviceConversions                                                                                                             | cross\_device\_conversions           |
| metrics.ctr                                                                                                                                | ctr                                  |
| adGroupAd.ad.expandedTextAd.description                                                                                                    | description                          |
| adGroupAd.ad.displayUrl                                                                                                                    | display\_url                         |
| adGroupAd.ad.textAd.headline                                                                                                               | headline                             |
| adGroupAd.ad.imageAd.name                                                                                                                  | image\_creative\_name                |
| metrics.impressions                                                                                                                        | impressions                          |
| metrics.interactions                                                                                                                       | interactions                         |
| metrics.interactionEventTypes                                                                                                              | interaction\_types                   |
| adGroupAd.ad.legacyResponsiveDisplayAd.mainColor                                                                                           | main\_color                          |
| adGroupAd.ad.responsiveDisplayAd.accentColor                                                                                               | accent\_color                        |
| adGroupAd.ad.responsiveSearchAd.headlines                                                                                                  | responsive\_search\_ad\_headlines    |
| adGroupAd.ad.responsiveSearchAd.descriptions                                                                                               | responsive\_search\_ad\_descriptions |
| adGroupAd.status                                                                                                                           | status                               |
| metrics.videoQuartileP25Rate                                                                                                               | video\_quartile25\_rate              |
| metrics.videoQuartileP50Rate                                                                                                               | video\_quartile50\_rate              |
| metrics.videoQuartileP75Rate                                                                                                               | video\_quartile75\_rate              |
| metrics.videoQuartileP100Rate                                                                                                              | video\_quartile100\_rate             |
| metrics.videoTrueviewViews                                                                                                                 | video\_views                         |
| metrics.viewThroughConversions                                                                                                             | view\_through\_conversions           |
| MD5(adGroupAd.ad.id + segments.date + segments.device + ad group ID + adGroupAd.ad.type + segments.adNetworkType + segments.adNetworkType) | \_key                                |
| — (no longer populated)                                                                                                                    | average\_position                    |
| — (no longer populated)                                                                                                                    | creative\_destination\_url           |
| — (no longer populated)                                                                                                                    | gmail\_teaser\_headline              |
| — (no longer populated)                                                                                                                    | marketing\_image\_headline           |
| — (no longer populated)                                                                                                                    | marketing\_image\_description        |
| Google Ads customer ID                                                                                                                     | adwords\_client\_id                  |
| ID of Merchant in Daasity App                                                                                                              | \_account\_id                        |
| timestamp when data was extracted from Google Ads                                                                                          | \_\_synced\_at                       |

### **Ad Groups**

* Endpoint: [Reports](https://developers.google.com/google-ads/api/docs/reporting/overview)
* Update Method: UPSERT
* Table Name: \[`adwords.adgroups`]

| JSON Element                                                                                                                                      | Database Column            |
| ------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------- |
| MD5(adGroup.id + segments.date)                                                                                                                   | id                         |
| segments.date                                                                                                                                     | date                       |
| segments.device                                                                                                                                   | device                     |
| campaign.id                                                                                                                                       | campaign\_id               |
| adGroup.id                                                                                                                                        | ad\_group\_id              |
| adGroup.name                                                                                                                                      | ad\_group\_name            |
| adGroup.status                                                                                                                                    | ad\_group\_status          |
| adGroup.type                                                                                                                                      | ad\_group\_type            |
| segments.adNetworkType                                                                                                                            | ad\_network\_type1         |
| segments.adNetworkType                                                                                                                            | ad\_network\_type2         |
| segments.adRotationMode                                                                                                                           | ad\_rotation\_mode         |
| adGroup.cpcBidMicros                                                                                                                              | cpc\_bid                   |
| adGroup.cpmBidMicros                                                                                                                              | cpm\_bid                   |
| adGroup.cpvBidMicros                                                                                                                              | cpv\_bid                   |
| metrics.viewThroughConversions                                                                                                                    | view\_through\_conversions |
| metrics.allConversions                                                                                                                            | all\_conversions           |
| metrics.conversions                                                                                                                               | conversions                |
| metrics.crossDeviceConversions                                                                                                                    | cross\_device\_conversions |
| metrics.allConversionsFromInteractionsRate                                                                                                        | all\_conversion\_rate      |
| metrics.conversionsFromInteractionsRate                                                                                                           | conversion\_rate           |
| metrics.allConversionsValue                                                                                                                       | all\_conversion\_value     |
| metrics.conversionsValue                                                                                                                          | conversion\_value          |
| metrics.costMicros                                                                                                                                | cost                       |
| MD5(adGroup.name + adGroupAd.id + segments.date + segments.device + campaign.id + adGroup.type + segments.adNetworkType + segments.adNetworkType) | \_key                      |
| Google Ads customer ID                                                                                                                            | adwords\_client\_id        |
| ID of Merchant in Daasity App                                                                                                                     | \_account\_id              |
| timestamp when data was extracted from Google Ads                                                                                                 | \_\_synced\_at             |

### **Campaigns**

* Endpoint: [Reports](https://developers.google.com/google-ads/api/docs/reporting/overview)
* Update Method: UPSERT
* Table Name: \[`adwords.campaigns`]

| JSON Element                                       | Database Column            |
| -------------------------------------------------- | -------------------------- |
| MD5(campaign.id + segments.date)                   | id                         |
| segments.date                                      | date                       |
| segments.device                                    | device                     |
| campaign.id                                        | campaign\_id               |
| campaign.name                                      | campaign\_name             |
| campaign.status                                    | campaign\_status           |
| metrics.viewThroughConversions                     | view\_through\_conversions |
| metrics.allConversions                             | all\_conversions           |
| metrics.conversions                                | conversions                |
| metrics.crossDeviceConversions                     | cross\_device\_conversions |
| metrics.allConversionsFromInteractionsRate         | all\_conversions\_rate     |
| metrics.conversionsFromInteractionsRate            | conversion\_rate           |
| metrics.allConversionsValue                        | all\_conversion\_value     |
| metrics.conversionsValue                           | conversion\_value          |
| metrics.costMicros                                 | cost                       |
| metrics.clicks                                     | clicks                     |
| metrics.impressions                                | impressions                |
| MD5(campaign.id + segments.date + segments.device) | \_key                      |
| — (no longer populated)                            | campaign\_group\_id        |
| Google Ads customer ID                             | adwords\_client\_id        |
| ID of Merchant in Daasity App                      | \_account\_id              |
| timestamp when data was extracted from Google Ads  | \_\_synced\_at             |

### **Keywords**

* Endpoint: [Reports](https://developers.google.com/google-ads/api/docs/reporting/overview)
* Update Method: UPSERT
* Table Name: \[`adwords.keywords`]

| JSON Element                                                                     | Database Column                                  |
| -------------------------------------------------------------------------------- | ------------------------------------------------ |
| MD5(adGroupCriterion.criterionId + segments.date)                                | id                                               |
| segments.date                                                                    | date                                             |
| segments.device                                                                  | device                                           |
| adGroup.id                                                                       | ad\_group\_id                                    |
| adGroupCriterion.effectiveCpcBidMicros                                           | cpc\_bid                                         |
| adGroupCriterion.effectiveCpmBidMicros                                           | cpm\_bid                                         |
| adGroupCriterion.positionEstimates.estimatedAddClicksAtFirstPositionCpc          | estimated\_add\_clicks\_at\_first\_position\_cpc |
| adGroupCriterion.positionEstimates.estimatedAddCostAtFirstPositionCpc            | estimated\_add\_cost\_at\_first\_position\_cpc   |
| adGroupCriterion.positionEstimates.firstPageCpcMicros                            | first\_page\_cpc                                 |
| adGroupCriterion.positionEstimates.firstPositionCpcMicros                        | first\_position\_cpc                             |
| adGroupCriterion.positionEstimates.topOfPageCpcMicros                            | top\_of\_page\_cpc                               |
| adGroupCriterion.qualityInfo.creativeQualityScore                                | creative\_quality\_score                         |
| adGroupCriterion.keyword.matchType                                               | keyword\_match\_type                             |
| adGroupCriterion.qualityInfo.postClickQualityScore                               | post\_click\_quality\_score                      |
| adGroupCriterion.qualityInfo.qualityScore                                        | quality\_score                                   |
| adGroupCriterion.qualityInfo.searchPredictedCtr                                  | search\_predicted\_ctr                           |
| adGroupCriterion.status                                                          | status                                           |
| adGroupCriterion.urlCustomParameters                                             | url\_custom\_parameters                          |
| metrics.activeViewCpm                                                            | active\_view\_cpm                                |
| metrics.clicks                                                                   | clicks                                           |
| metrics.impressions                                                              | impressions                                      |
| metrics.interactions                                                             | interactions                                     |
| metrics.averageCost                                                              | average\_cost                                    |
| metrics.averageCpc                                                               | average\_cpc                                     |
| metrics.averageCpm                                                               | average\_cpm                                     |
| metrics.trueviewAverageCpv                                                       | average\_cpv                                     |
| metrics.conversions                                                              | conversions                                      |
| metrics.conversionsValue                                                         | conversion\_value                                |
| metrics.costPerAllConversions                                                    | cost\_per\_all\_conversion                       |
| metrics.costPerConversion                                                        | cost\_per\_conversion                            |
| metrics.ctr                                                                      | ctr                                              |
| metrics.searchExactMatchImpressionShare                                          | search\_exact\_match\_impression\_share          |
| metrics.searchImpressionShare                                                    | search\_impression\_share                        |
| metrics.searchRankLostImpressionShare                                            | search\_rank\_lost\_impression\_share            |
| metrics.valuePerAllConversions                                                   | value\_per\_all\_conversion                      |
| metrics.valuePerConversion                                                       | value\_per\_conversion                           |
| MD5(adGroupCriterion.criterionId + segments.date + segments.device + adGroup.id) | \_key                                            |
| — (no longer populated)                                                          | average\_position                                |
| Google Ads customer ID                                                           | adwords\_client\_id                              |
| ID of Merchant in Daasity App                                                    | \_account\_id                                    |
| timestamp when data was extracted from Google Ads                                | \_\_synced\_at                                   |

### **Campaign Product Performance**

* Endpoint: [Reports](https://developers.google.com/google-ads/api/docs/reporting/overview)
* Update Method: UPSERT
* Table Name: \[`adwords.campaign_product_performance`]

Shopping performance by campaign, product item and day (`shopping_performance_view`).

| JSON Element                                                                      | Database Column                            |
| --------------------------------------------------------------------------------- | ------------------------------------------ |
| MD5(campaign.id + segments.productItemId + segments.date + segments.productTitle) | id                                         |
| campaign.id                                                                       | campaign\_id                               |
| campaign.name                                                                     | campaign\_name                             |
| campaign.status                                                                   | campaign\_status                           |
| segments.date                                                                     | date                                       |
| segments.productItemId                                                            | product\_item\_id                          |
| segments.productTitle                                                             | product\_title                             |
| metrics.allConversions                                                            | all\_conversions                           |
| metrics.allConversionsValue                                                       | all\_conversions\_value                    |
| metrics.allConversionsFromInteractionsRate                                        | all\_conversions\_from\_interactions\_rate |
| metrics.averageCartSize                                                           | average\_cart\_size                        |
| metrics.averageCpc                                                                | average\_cpc                               |
| metrics.averageOrderValueMicros                                                   | average\_order\_value\_micros              |
| metrics.clicks                                                                    | clicks                                     |
| metrics.conversions                                                               | conversions                                |
| metrics.conversionsFromInteractionsRate                                           | conversions\_from\_interactions\_rate      |
| metrics.conversionsValue                                                          | conversions\_value                         |
| metrics.costMicros                                                                | cost\_micros                               |
| metrics.costOfGoodsSoldMicros                                                     | cost\_of\_goods\_sold\_micros              |
| metrics.costPerAllConversions                                                     | cost\_per\_all\_conversions                |
| metrics.costPerConversion                                                         | cost\_per\_conversion                      |
| metrics.crossDeviceConversions                                                    | cross\_device\_conversions                 |
| metrics.crossSellCostOfGoodsSoldMicros                                            | cross\_sell\_cost\_of\_goods\_sold\_micros |
| metrics.crossSellGrossProfitMicros                                                | cross\_sell\_gross\_profit\_micros         |
| metrics.crossSellRevenueMicros                                                    | cross\_sell\_revenue\_micros               |
| metrics.crossSellUnitsSold                                                        | cross\_sell\_units\_sold                   |
| metrics.ctr                                                                       | ctr                                        |
| metrics.grossProfitMargin                                                         | gross\_profit\_margin                      |
| metrics.grossProfitMicros                                                         | gross\_profit\_micros                      |
| metrics.impressions                                                               | impressions                                |
| metrics.leadCostOfGoodsSoldMicros                                                 | lead\_cost\_of\_goods\_sold\_micros        |
| metrics.leadGrossProfitMicros                                                     | lead\_gross\_profit\_micros                |
| metrics.leadRevenueMicros                                                         | lead\_revenue\_micros                      |
| metrics.leadUnitsSold                                                             | lead\_units\_sold                          |
| metrics.orders                                                                    | orders                                     |
| metrics.revenueMicros                                                             | revenue\_micros                            |
| metrics.unitsSold                                                                 | units\_sold                                |
| metrics.valuePerAllConversions                                                    | value\_per\_all\_conversions               |
| metrics.valuePerConversion                                                        | value\_per\_conversion                     |
| MD5(campaign.id + segments.productItemId + segments.date + segments.productTitle) | \_key                                      |
| Google Ads customer ID                                                            | adwords\_client\_id                        |
| ID of Merchant in Daasity App                                                     | \_account\_id                              |
| timestamp when data was extracted from Google Ads                                 | \_\_synced\_at                             |

### **Geo Campaigns**

* Endpoint: [Reports](https://developers.google.com/google-ads/api/docs/reporting/overview)
* Update Method: UPSERT
* Table Name: \[`adwords.geo_campaigns`]

Optional report. Campaign performance by country and location type per day (`geographic_view`).

| JSON Element                                                                                         | Database Column            |
| ---------------------------------------------------------------------------------------------------- | -------------------------- |
| MD5(geographicView\.countryCriterionId + campaign.id + segments.date + geographicView\.locationType) | id                         |
| segments.date                                                                                        | date                       |
| geographicView\.countryCriterionId                                                                   | country\_criterion\_id     |
| geographicView\.locationType                                                                         | location\_type             |
| campaign.id                                                                                          | campaign\_id               |
| campaign.name                                                                                        | campaign\_name             |
| campaign.status                                                                                      | campaign\_status           |
| metrics.costMicros                                                                                   | cost                       |
| metrics.clicks                                                                                       | clicks                     |
| metrics.impressions                                                                                  | impressions                |
| metrics.conversions                                                                                  | conversions                |
| metrics.conversionsValue                                                                             | conversions\_value         |
| metrics.allConversions                                                                               | all\_conversions           |
| metrics.allConversionsValue                                                                          | all\_conversions\_value    |
| metrics.crossDeviceConversions                                                                       | cross\_device\_conversions |
| metrics.viewThroughConversions                                                                       | view\_through\_conversions |
| MD5(geographicView\.countryCriterionId + campaign.id + segments.date + geographicView\.locationType) | \_key                      |
| Google Ads customer ID                                                                               | adwords\_client\_id        |
| ID of Merchant in Daasity App                                                                        | \_account\_id              |
| timestamp when data was extracted from Google Ads                                                    | \_\_synced\_at             |

### **Geo Ad Groups**

* Endpoint: [Reports](https://developers.google.com/google-ads/api/docs/reporting/overview)
* Update Method: UPSERT
* Table Name: \[`adwords.geo_adgroups`]

Optional report. Ad group performance by country and location type per day (`geographic_view`).

| JSON Element                                                                                                      | Database Column            |
| ----------------------------------------------------------------------------------------------------------------- | -------------------------- |
| MD5(geographicView\.countryCriterionId + campaign.id + adGroup.id + segments.date + geographicView\.locationType) | id                         |
| segments.date                                                                                                     | date                       |
| geographicView\.countryCriterionId                                                                                | country\_criterion\_id     |
| geographicView\.locationType                                                                                      | location\_type             |
| campaign.id                                                                                                       | campaign\_id               |
| campaign.name                                                                                                     | campaign\_name             |
| campaign.status                                                                                                   | campaign\_status           |
| adGroup.id                                                                                                        | ad\_group\_id              |
| adGroup.name                                                                                                      | ad\_group\_name            |
| adGroup.status                                                                                                    | ad\_group\_status          |
| metrics.costMicros                                                                                                | cost                       |
| metrics.clicks                                                                                                    | clicks                     |
| metrics.impressions                                                                                               | impressions                |
| metrics.conversions                                                                                               | conversions                |
| metrics.conversionsValue                                                                                          | conversions\_value         |
| metrics.allConversions                                                                                            | all\_conversions           |
| metrics.allConversionsValue                                                                                       | all\_conversions\_value    |
| metrics.crossDeviceConversions                                                                                    | cross\_device\_conversions |
| metrics.viewThroughConversions                                                                                    | view\_through\_conversions |
| MD5(geographicView\.countryCriterionId + campaign.id + adGroup.id + segments.date + geographicView\.locationType) | \_key                      |
| Google Ads customer ID                                                                                            | adwords\_client\_id        |
| ID of Merchant in Daasity App                                                                                     | \_account\_id              |
| timestamp when data was extracted from Google Ads                                                                 | \_\_synced\_at             |

{% hint style="info" %}
**NOTE**: Not all dimensions are used in transformation and/or exposed. If you would like to explore customization for this data, please contact <support@daasity.com>.
{% endhint %}
