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.