Google Ad Extractor Document

 

blobid0.png

 

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. 

 

INTEGRATION OVERVIEW 

The Daasity<>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.  

 

AVAILABILITY 

This information is incorporated into Daasity’s Unified Marketing Schema for Growth and Pro 2.0 merchants. 

It is available in the Google Ads Dashboard for Pro Legacy merchants. Legacy merchants are those whose Daasity accounts were created prior to July 15, 2020 and have their own Looker instance. 

SUPPORTED ENDPOINTS 

Reports API 

https://developers.google.com/adwords/api/docs/guides/reporting 

Ads 

https://adwords.google.com/api/adwords/cm/v201809/CampaignService?wsdl 

AdGroups 

https://adwords.google.com/api/adwords/cm/v201809/CampaignService?wsdl 

Campaigns 

https://adwords.google.com/api/adwords/cm/v201809/CampaignService?wsdl 

Keywords 

https://adwords.google.com/api/adwords/cm/v201809/CampaignService?wsdl 

 

 

ERD 

 

Ads Table 

Data mapping from source JSON to database columns: 

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 

 

 

Incremental data extraction  

Business Rule 

Value 

Load type 

UPSERT 

Extraction Frequency 

Daily 

 

 

Adgroups Table 

Data mapping from source JSON to database columns: 

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 

 

 

Incremental data extraction  

Business Rule 

Value 

Load type 

UPSERT 

Extraction Frequency 

Daily 

 

 

Campaigns Table 

Data mapping from source JSON to database columns: 

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 

 

 

Incremental data extraction  

Business Rule 

Value 

Load type 

UPSERT 

Extraction Frequency 

Daily 

 

 

Keywords Table 

Data mapping from source JSON to database columns: 

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 

 

 

Incremental data extraction  

Business Rule 

Value 

Load type 

UPSERT 

Extraction Frequency 

Daily 

 

 

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 

Was this article helpful?
0 out of 0 found this helpful