Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • Alchemer
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Algolia
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Amazon Advertising
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Amazon Seller Central
        • Validating Your Amazon Data in Daasity
          • Comparing Your Amazon Seller Central Orders to Daasity
        • Integration Setup
          • Configure Amazon Reports
          • Monitor Amazon Reports
        • Integration Specifications
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Sales Reports
          • FBA Inventory Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Performance Reports
          • Returns Reports
          • Settlement Reports
          • Seller Retail Analytics Reports
        • Workflow Configuration Setup
          • Orders API
          • FBA Customer Concession Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removal Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
        • Transformation Configuration Setup
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
      • Amazon Vendor Central
        • Integration Setup
        • Integration Specifications
        • How to use
        • ASIN Mapping Configuration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
          • Vendor Sales & Inventory Report
          • Vendor Traffic Report
      • AppLovin
        • Integration Setup
      • Attentive Mobile
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Azure SQL Database
      • Back In Stock
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Big Commerce
        • Integration Setup
          • Connect Daasity From BigCommerce Marketplace
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • BigQuery Datasource
      • Bing Ads
        • Integration Setup
        • Integration Specifications
      • Circana
        • Integration Setup
        • Integration Specifications
        • Data Release Calendar
        • H-E-B Circana
      • Cordial
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Criteo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • D​ata File (CSV, XLS)
      • Emplifi
        • Integration Specifications
      • Extensiv (Skubana)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Facebook Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Fairing V2
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Important Notes
      • Google Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Google Analytics 4
        • API vs BigQuery
        • API Integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Custom Reports
          • Validating GA4 Data in Daasity
          • Blending Universal Analytics & GA4 Data
        • BigQuery integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Important Notes
          • Creating a Custom Report
      • Google Sheet
      • Gorgias
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Impact Radius (Beta)
        • Integration Specifications
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Klaviyo Summary Statistics
        • Integration Setup
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • Loop Returns
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Microsoft SQL Server Database
      • Mongo Database
      • MySQL Database
      • Narvar
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • NetSuite
      • Newstore
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Northbeam
        • Integration Setup
      • Okendo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Ometria
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Order Desk
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pepperjam
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pinterest
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Postgres Database
      • Postscript (beta)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Recharge
        • Integration Setup
        • Integration Specifications
        • Integration Specifications (2021-11 Beta)
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Recharge Data and Known Discrepancies
      • Retail Next
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Salesforce Commerce Cloud
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SFTP
      • ShipBob
        • Integration Setup
        • Integration Specifications
      • Shipstation
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Shopify
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Shopify B2B Data
      • SKIO
        • Integration Setup
        • Integration Specifications
      • Snapchat
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SPINS
        • Integration Setup
        • Integration Specifications
        • How to Use
        • Data Release Calendar
      • Stay Ai
        • Integration Setup
        • Integration Specifications
      • Target Plus
        • Integration Setup
      • Thankful
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • TikTok
        • Integration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Walmart Marketplace
        • Integration Setup
        • Integration Specifications
      • Whole Foods Market
        • Integration Setup
        • Integration Specifications
        • How to use
      • Yotpo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Zendesk
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
    • Brand Supplied Data (BSD)
      • BSD Overview
      • Monitoring Your BSD Progress
      • Revenue Plan
      • Marketing Budget
      • Marketing Spend
      • RFM Values
      • Shipping & Fulfillment Cost
      • SKU Hierarchy
      • SKU Mapping
      • SKU Cost
      • Discount Code Mapping
      • Other Order Sources
      • Channel Mapping
        • Overview & Setup
        • Filling out Channel Mapping
        • Missing from GA & Missing from BSD
      • Configuration
  • 📊VISUALIZE
    • Dashboards
      • Dashboard Overview
      • Standard Dashboards
        • Daasity 101 Overview Dashboards
          • Flashes
          • Shopify Sales Report
          • Account Health
        • Digital Product & Revenue
          • Orders and Revenue
          • Amazon Settlement Report
          • Product Repurchase Rate
          • Product
            • Product Dimensions
              • Why is a Product Name NULL?
          • Inventory
          • Operations
            • Fulfilment Status Options
        • Retention Marketing Dashboards
          • Notifications (Email/SMS)
          • Retention
          • Customer Performance (Email/SMS)
          • Site Funnels
        • Acquisition Marketing Dashboards
          • Attribution Deep Dive
            • Marketing Attribution
              • Attribution Overview
              • Survey-Based Attribution
              • Discount Code Attribution
              • First Click, Last Click, and Assisted Attribution
              • Custom Attribution
              • Vendor-Reported Attribution
              • CPO, CPA, and CAC
              • Missing from GA & Missing from BSD
          • LTV & RFM
            • RFM
              • RFM in the Daasity App
              • Understanding RFM
              • Time on Books (TOB)
          • Marketing
          • Vendor-Reported Marketing Performance
          • Site Analytics & Attribution
      • Integration Dashboards
        • Amazon All Orders Report
        • Amazon Seller Central Business Reports
        • Gorgias
        • Klaviyo Campaign & Flow Performance
        • Loop Returns
        • Okendo Reviews
        • ShipBob
        • Shipstation
        • Subscription
        • Walmart Marketplace Account Sales Report
        • Yotpo
    • Explores
      • Explore Overview
      • Order Line Revenue vs. Transactional Sales Report
      • How to Access An Explore
      • Standard Daasity Explores
        • Current Inventory Level Explore
        • Customer Details Explore
        • Daily Company Metrics Explore
        • Daily Marketing Plan To Actual Marketing Performance Explore
        • Daily Plan to Actual Explore
        • Lifetime Value Explore
        • Marketing Attribution Explore
        • Multi-Channel Transaction Explore
        • Order and Order Line Revenue Explore
        • Product Page Explore
        • Shopping Stage Explore
        • SKU Level Repurchase Rates Explore
        • Traffic Explore
        • Transactional Sales Report Explore
        • UA vs G4 Explore
      • Integration Explores
        • Algolia
        • Amazon Settlement Explore
        • Fairing Survey Responses Explore
        • Gorgias Tickets Explore
        • Loop Returns Explore
        • Okendo Reviews Explore
        • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
        • Shipstation Explore
        • Yotpo
        • Zen Desk
    • Looker Guides
      • Building visualizations
      • Working with date dimensions & filters
      • Schedule a Report or Dashboard
      • Exporting Data
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • BigQuery
    • Redshift
    • Snowflake
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  • Integration Overview
  • Integration Availability
  • API Endpoints
  • Entity Relationship Diagram (ERD)
  • Google Ads Schema
  • Ads
  • Ad Groups
  • Campaigns
  • Keywords

Was this helpful?

  1. Extract
  2. All Integrations
  3. Google Ads

Integration Specifications

PreviousIntegration SetupNextWorkflow Configuration Setup

Last updated 1 year ago

Was this helpful?

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 . The following endpoints are used by Daasity to replicate data from Google Ads.

Entity Relationship Diagram (ERD)

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.

Ads

  • Update Method: UPSERT

  • Table Name: [adwords.ads]

JSON Element 
Database Column 

Id

id

Date

date

Device

device

BusinessName

business_name

AccountDescriptiveName

account_descriptive_name

Automated

automated

AdGroupId

ad_group_id

AdType

ad_type

AdNetworkType1

ad_network_type1

AdNetworkType2

ad_network_type2

ActiveViewCpm

active_view_cpm

ActiveViewCtr

active_view_ctr

ActiveViewImpressions

active_view_impressions

AverageCost

average_cost

AverageCpc

average_cpc

AverageCpm

average_cpm

AverageCpv

average_cpv

AveragePosition

average_position

CallToActionText

call_to_action_next

Clicks

clicks

Conversions

conversions

ConversionValue

conversion_value

Cost

cost

AllConversions

all_conversions

AllConversionValue

all_conversion_value

CreativeDestinationUrl

creative_destination_url

CrossDeviceConversions

cross_device_conversions

Ctr

ctr

Description

description

DisplayUrl

display_url

GmailTeaserHeadline

gmail_teaser_headline

Headline

headline

ImageCreativeName

image_creative_name

Impressions

impressions

Interactions

interactions

InteractionTypes

interaction_types

MainColor

main_color

AccentColor

accent_color

MarketingImageHeadline

marketing_image_headline

MarketingImageDescription

marketing_image_description

ResponsiveSearchAdHeadlines

responsive_search_ad_headlines

ResponsiveSearchAdDescriptions

responsive_search_ad_descriptions

Status

status

VideoQuartile25Rate

video_quartile25_rate

VideoQuartile50Rate

video_quartile50_rate

VideoQuartile75Rate

video_quartile75_rate

VideoQuartile100Rate

video_quartile100_rate

VideoViews

video_views

ViewThroughConversions

view_through_conversions

Google Adwords Account ID

adwords_client_id

MD5(Id + Date + Device + AdGroupId + AdType + AdNetworkType1 + AdNetworkType2)

_key

ID of Merchant in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

Ad Groups

  • Update Method: UPSERT

  • Table Name: [adwords.adgroups]

JSON Element 
Database Column 

Id

id

Date

date

Device

device

CampaignId

campaign_id

AdGroupId

ad_group_id

AdGroupName

ad_group_name

AdGroupStatus

ad_group_status

AdGroupType

ad_group_type

AdNetworkType1

ad_network_type1

AdNetworkType2

ad_network_type2

AdRotationMode

ad_rotation_mode

CpcBid

cpc_bid

CpmBid

cpm_bid

CpvBid

cpv_bid

ViewThroughConversions

view_through_conversions

AllConversionRate

all_conversion_rate

ConversionRate

conversion_rate

AllConversionValue

all_conversion_value

ConversionValue

conversion_value

Cost

cost

Google Adwords Account ID

adwords_client_id

MD5(AdGroupId + Date + Device + CampaignId + AdGroupType + AdNetworkType1 + AdNetworkType2)

_key

ID of Merchant in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

Campaigns

  • Update Method: UPSERT

  • Table Name: [adwords.campaigns]

JSON Element 
Database Column 

Id

id

Date

date

Device

device

CampaignGroupId

campaign_group_id

CampaignId

campaign_id

CampaignName

campaign_name

CampaignStatus

campaign_status

ViewThroughConversions

view_through_conversions

AllConversions

all_conversions

Conversions

conversions

CrossDeviceConversions

cross_device_conversions

AllConversionRate

all_conversions_rate

ConversionRate

conversion_rate

AllConversionValue

all_conversion_value

Cost

cost

Google Adwords Account ID

adwords_client_id

MD5(AdGroupId + Date + Device + CampaignId + AdGroupType + AdNetworkType1 + AdNetworkType2)

_key

ID of Merchant in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

Keywords

  • Update Method: UPSERT

  • Table Name: [adwords.keywords]

JSON Element 
Database Column 

Id

id

Date

date

AdGroupId

ad_group_id

CpcBid

cpc_bid

CpmBid

cpm_bid

EstimatedAddClicksAtFirstPositionCpc

estimated_add_clicks_at_first_position_cpc

EstimatedAddCostAtFirstPositionCpc

estimated_add_cost_at_first_position_cpc

FirstPageCpc

first_page_cpc

FirstPositionCpc

first_position_cpc

TopOfPageCpc

top_of_page_cpc

CreativeQualityScore

creative_quality_score

KeywordMatchType

keyword_match_type

PostClickQualityScore

post_click_quality_score

QualityScore

quality_score

SearchPredictedCtr

search_predicted_ctr

Status

status

UrlCustomParameters

url_custom_parameters

ActiveViewCpm

active_view_cpm

Clicks

clicks

Impressions

impressions

Interactions

interactions

AverageCost

average_cost

AverageCpc

average_cpc

AverageCpm

average_cpm

AverageCpv

average_cpv

AveragePosition

average_position

Conversions

conversions

ConversionValue

conversion_value

CostPerAllConversion

cost_per_all_conversion

CostPerConversion

cost_per_conversion

Ctr

ctr

SearchExactMatchImpressionShare

search_exact_match_impression_share

SearchImpressionShare

search_rank_lost_impression_share

SearchRankLostImpressionShare

value_per_all_conversion

ValuePerAllConversion

value_per_conversion

Google Adwords Account ID

adwords_client_id

MD5(Id + Date + Device + AdGroupId)

_key

ID of Merchant in Daasity App

_account_id

timestamp when data was extracted from Shopify

__synced_at

Endpoint:

Endpoint:

Endpoint:

Endpoint:

 NOTE: Not all dimensions are used in transformation and/or exposed. If you would like to explore customization for this data, please contact .

🔌
Google Ads API Documentation
Reports
Click here to view the ERD for the Daasity Google Ads integration
Reports
Reports
Reports
Reports
support@daasity.com
Ads
Ad Groups
Campaigns
Keywords