Integration: Google Ads

This article will help you learn about how Daasity replicates data from Google Ads, limitations to the data we can extract and where the data is stored in the Google Ads schema.

Key Topics

Integration Availability 

This integration is available for:

  • Growth
  • Pro V2

NOTE: You are considered V2 if...

  • You are a Growth customer
  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to Support@Daasity.com 

 

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 on the area of Google (i.e., youtube, text search) and by campaign.  

No ad or ad group data for Performance Max & Smart Shopping campaigns

If you are running Performance Max and/or Smart Shopping campaigns on Google Ads, please be aware that there will be performance data for these campaigns only in the CAMPAIGNS table. There will be no data for these campaigns in the ADS or ADGROUPS tables. This is because there are no ad or ad group entities for these types of campaigns.

This means that if you aggregate data from the ADS or ADGROUPS tables, you will not see spend or any other performance metrics from Performance Max or Smart Shopping campaigns.

API Endpoints

The Daasity Google Ads extractor is built based on this Google Ads API Documentation. The following endpoints are used by Daasity to replicate data from Google Ads.

Entity Relationship Diagram (ERD)

Google Ads Schema

The Daasity Google Ads extractor creates these tables using the endpoints and replication methods listed.  The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

Ads 

  • Endpoint: Reports
  • 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 

  • Endpoint: Reports
  • 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

  • Endpoint: Reports
  • 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 

  • Endpoint: Reports
  • 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 

 

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

Related Resources