Integration Specifications

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

Integration Overview

Daasity extracts data from 3 Amazon Ads solutions - Amazon Sponsored Products, Amazon Sponsored Display, and Amazon Sponsored Brands.

• Amazon Sponsored Products are cost-per-click Amazon ads that help customers discover and purchase products that you sell on Amazon with ads that appear in shopping results and on product pages.

• Amazon Sponsored Display reaches relevant audiences who are browsing, discovering, or purchasing products on or off Amazon with ads that may appear on the Amazon home page, product detail pages, or shopping result pages as well as third-party websites and apps.

• Amazon Sponsored Brands are cost-per-click (CPC) ads that feature your brand logo, a custom headline, and multiple products. These ads appear in relevant shopping results and help drive the discovery of your brand among customers shopping for products like yours.

Only 60 days of history available

Amazon Ads only makes the last 60 days of history available via the API. (source)

Integration Availability

This integration is available for:

• Enterprise

• Growth

API Endpoints

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

• Profiles

• Attribution

  • Attribution Advertisers

  • Attribution Publishers

  • Attribution Reports

  • Attribution Tags

• Sponsored Brands

  • Sponsored Brands Ad Groups

  • Sponsored Brands Brands

  • Sponsored Brands Campaigns

  • Sponsored Brands Keywords

  • Sponsored Brands Negative Keywords

  • Sponsored Brands Product Targeting

  • Sponsored Brands Product Targeting Expressions

  • Sponsored Brands Report

  • Sponsored Brands Stores

• Sponsored Display

  • Sponsored Display Ad Groups

  • Sponsored Display Campaigns

  • Sponsored Display Product Ads

  • Sponsored Display Reports

  • Sponsored Display Targeting

  • Sponsored Display Targeting Recommendations

• Sponsored Products

  • Sponsored Products Ad Groups

  • Sponsored Products Bid Recommendations

  • Sponsored Products Campaigns

  • Sponsored Products Keywords

  • Sponsored Products Suggested Keywords

  • Sponsored Products Product Ads

  • Sponsored Products Reports

Amazon Ads API uses OAuth 2.0 for authenticating clients. Merchants will need to provide their SellerCentral login credentials and "authorize" Daasity to access their account.

The API parameters below outline what we need to obtain access_tokens thus to access data. Access token is only valid for 60 mins.

Amazon Ads Authorization

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity Amazon Ads integration illustrating the different tables and keys to join across tables.

Amazon Ads Schema

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

• Profiles
• Attribution

  • Attribution Advertisers
  • Attribution Publishers
  • Attribution Tags Macro Enabled
  • Attribution Tags Non-Macro-Enabled
  • Attribution Report
• Sponsored Brands

  • Sponsored Brands Brands
  • Sponsored Brands Brand Stores
  • Sponsored Brands Campaigns
  • Sponsored Brands Ad Groups
  • Sponsored Brands Keywords
  • Sponsored Brands Negative Keywords
  • Sponsored Brands Product Targeting
  • Sponsored Brands Product Targeting Expressions
  • Sponsored Brands Reports
• Sponsored Display

  • Sponsored Display Campaigns
  • Sponsored Display Ad Groups
  • Sponsored Display Product Ads
  • Sponsored Display Targets
  • Sponsored Display Targets Expressions
  • Sponsored Display Reports
• Sponsored Products

  • Sponsored Products Campaigns
  • Sponsored Products Campaign Bidding Strategy
  • Sponsored Products Ad Groups
  • Sponsored Products Ad Group Bid Recommendations
  • Sponsored Products Ad Group Keywords
  • Sponsored Products Product Ads
  • Sponsored Products Keyword Bid Recommendation
  • Sponsored Products Suggested Keywords
  • Sponsored Products Reports

Profiles

• Endpoint: Profiles
• Update Method: UPSERT

• Table Name: amazon_ads.profiles

JSON Element	Database Column
profileId	profile_id
countryCode	country_code
currencyCode	currency_code
dailyBudget	daily_budget
timezone	timezone
accountInfo::marketplaceStringId	account_info_marketplace_string_id
accountInfo::id	account_info_id
accountInfo::type	account_into_type
account_id	_account_id
MD5(profileId + countryCode + currencyCode + dailyBudget + timezone + accountInfo::marketplaceStringId + accountInfo::id + accountInfo::type)	__sync_key
timestamp when loaded into DB	__synced_at

Attribution

Attribution Advertisers

• Endpoint: Attribution - Advertisers
• Update Method: UPSERT

• Table Name: amazon_ads.advertisers

JSON Element	Database Column
advertiserId	advertiser_id
advertiserName	advertiser_name
account_id	_account_id
profile_id	profile_id
MD5(advertiserId + advertiserName)	__sync_key
timestamp when loaded into DB	__synced_at

Attribution Publishers

• Endpoint: Attribution - Publishers
• Update Method: UPSERT

• Table Name: amazon_ads.attribution_publishers

JSON Element	Database Column
id	publisher_id
name	publisher_name
macroEnabled	macro_enabled
account_id	_account_id
profile_id	profile_id
MD5(id + name + macroEnabled)	__sync_key
timestamp when loaded into DB	__synced_at

Attribution Tags Macro-Enabled

• Endpoint: Attribution - Attribution Tags
• Update Method: UPSERT

• Table Name: amazon_ads.attribution_tags_macroenabled

JSON Element	Database Column
publisher_ids[0]	advertiser_id
publisher_ids[1]	publisher_id
publisher_ids[2]	publisher_tags
account_id	_account_id
profile_id	profile_id
MD5(publisher_ids[0] + publisher_ids[1] + publisher_ids[2])	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Attribution Tags Non-Macro-Enabled

• Endpoint: Attribution - Attribution Tags
• Update Method: UPSERT

• Table Name: amazon_ads.attribution_tags_nonmacroenabled

JSON Element	Database Column
publisher_ids[0]	advertiser_id
publisher_ids[1]	publisher_id
publisher_ids[2]	publisher_tags
account_id	_account_id
profile_id	profile_id
MD5(publisher_ids[0] + publisher_ids[1] + publisher_ids[2])	__sync_key
timestamp when loaded into DB	__synced_at

Attribution Reports

• Endpoint: Attribution - Reports
• Update Method: UPSERT

• Table Name: amazon_ads.attribution_reports

JSON Element	Database Column
report_date	report_date
creative_type	creative_type
adGroupName	ad_group_name
adGroupId	ad_group_id
keywordId	keyword_id
keywordText	keyword_text
keywordStatus	keyword_status
targetId	target_id
targetingExpression	targeting_expression
targetingText	targeting_text
targetingType	targeting_type
matchType	match_type
currency	currency
campaignName	campaign_name
campaignId	campaign_id
campaignStatus	campaignStatus
campaignBudgetType	campaign_budget_type
cost	cost
impressions	impressions
clicks	clicks
campaignBudget	campaign_budget
keywordBid	keyword_bid
attributedDetailPageViewsClicks14d	attributed_detail_pageviewclicks_14d
attributedSales14d	attributed_sales_14d
attributedSales14dSameSKU	attributed_sales_14d_same_sku
attributedConversions14d	attributed_conversions_14d
attributedConversions14dSameSKU	attributed_conversions_14d_same_sku
attributedOrdersNewToBrand14d	attributed_orders_newtobrand_14d
attributedOrdersNewToBrandPercentage14d	attributed_orders_newtobrand_percentage_14d
attributedOrderRateNewToBrand14d	attributed_order_rate_newtobrand_14d
attributedSalesNewToBrand14d	attributed_sales_newtobrand_14d
attributedSalesNewToBrandPercentage14d	attributed_sales_newtobrand_percentage_14d
attributedUnitsOrderedNewToBrand14d	attributed_units_ordered_newtobrand_14d
attributedUnitsOrderedNewToBrandPercentage14d	attributed_units_ordered_newtobrand_percentage_14d
unitsSold14d	units_sold_14d
dpv14d	dpv_14d
account_id	_account_id
MD5(campaignId + advertiserName+ publisher + adGroupId + creativeId + report_date + profileId)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Brands

Sponsored Brands Brands

• Endpoint: Sponsored Brands - Brands
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_brands_brands

JSON Element	Database Column
brandId	brand_id
brandEntityId	brand_entity_id
brandRegistryName	brand_registry_name
_account_id	_account_id
profile_id	profile_id
MD5(brandId + profile_id)	__sync_key
timestamp when loaded into DB	__synced_at

Sponsored Brands Stores

• Endpoint: Sponsored Brands - Brand Stores
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_brands_stores

JSON Element	Database Column
entityID	entity_id
storeName	store_name
storePageInfo::storePageID	store_page_id
storePageInfo::storePageURL	store_page_url
storePageInfo::storePageName	store_page_name
brandEntityID	brand_entity_id
account_id	_account_id
profile_id	profile_id
MD5(entityID + storePageInfo::storePageID + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Brands Campaigns

• Endpoint: Sponsored Brands - Campaigns
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_brands_campaigns

JSON Element	Database Column
name	name
budget	budget
bidOptimization	bid_optimization
portfolioId	portfolio_id
adFormat	ad_format
campaignId	campaign_id
budgetType	budget_type
startDate	start_date
state	state
servingStatus	serving_status
creative::brandName	creative_brand_name
creative::brandLogoAssetId	creative_brand_logo_asset_id
creative::headline	creative_headline
creative::shouldOptimizeAsins	creative_should_optimize_asins
creative::asins	creative_asins
creative::brandLogoUrl	creative_brand_logo_url
landingPage::pageType	landing_page_type
landingPage::url	landing_page_url
account_id	_account_id
profile_id	profile_id
MD5(campaignId + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Brands Ad Groups

• Endpoint: Sponsored Brands - Ad Groups
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_brands_ad_groups

JSON Element	Database Column
adGroupId	ad_group_id
name	adgroup_name
campaignId	campaign_id
account_id	_account_id
profile_id	profile_id
MD5(adGroupId + campaignId + profile_id)	__sync_key
timestamp when loaded into DB	__synced_at

Sponsored Brands Keywords

• Endpoint: Sponsored Brands - Keywords
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_brands_keywords

JSON Element	Database Column
keywordId	keyword_id
adGroupId	ad_group_id
campaignId	campaign_id
keywordText	keyword_text
matchType	match_type
state	state
bid	bid
account_id	_account_id
profile_id	profile_id
MD5(campaignId + adGroupId + keywordId + profile_id)	__sync_key
timestamp when loaded into DB	__synced_at

Sponsored Brands Negative Keywords

• Endpoint: Sponsored Brands - Negative Keywords
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_brands_negative_keywords

JSON Element	Database Column
targetId	target_id
adGroupId	ad_group_id
campaignId	campaign_id
bid	bid
state	state
account_id	_account_id
profile_id	profile_id
MD5(adGroupId + targetId + campaignId + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Brands Product Targeting

• Endpoint: Sponsored Brands - Product Targeting
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_brands_product_targeting

JSON Element	Database Column
keywordId	keyword_id
adGroupId	ad_group_id
campaignId	campaign_id
keywordText	keyword_text
matchType	match_type
state	state
account_id	_account_id
profile_id	profile_id
MD5(campaignId + adGroupId + keywordId + profile_id)	__sync_key
timestamp when loaded into DB	__synced_at

Sponsored Brands Product Targeting Expressions

• Endpoint: Sponsored Brands - Product Targeting Expressions

• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_brands_product_targeting_expressions

JSON Element	Database Column
targetId	target_id
adGroupId	ad_group_id
campaignId	campaign_id
expressionType	expression_type
type	type
value	value
account_id	_account_id
profile_id	profile_id
MD5(adGroupId + targetId + campaignId + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Brands Reports

• Endpoint: Sponsored Brands - Reports
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_brands_reports

JSON Element	Database Column
reportType(campaigns, keywords, adGroups)	report_type
creativeType	creative_type
date	report_date
segment	segment
campaignName	campaign_name
campaignID	campaign_id
campaignStatus	campaign_status
campaignBudget	campaign_budget
campaignBudgetType	campaign_budget_type
adGroupName	adgroup_name
adGroupId	adgroup_id
keywordId	keyword_id
keywordText	keyword_text
keywordBid	keyword_bid
keywordStatus	keyword_status
targetID	target_id
targetingExpression	targeting_expression
targetingText	targeting_text
targetingType	targeting_type
matchType	match_type
impressions	impressions
clicks	clicks
cost	cost
attributedDetailPageViewsClicks14d	attributed_detail_pageviewclicks_14d
attributedSales14d	attributed_sales_14d
attributedSales14dSameSKU	attributed_sales_14d_same_sku
attributedConversions14d	attributed_conversions_14d
attributedConversions14dSameSKU	attributed_conversions_14d_same_sku
attributedOrdersNewToBrand14d	attributed_orders_newtobrand_14d
attributedOrdersNewToBrandPercentage14d	attributed_orders_newtobrand_percentage_14d
attributedOrderRateNewToBrand14d	attributed_order_rate_newtobrand_14d
attributedSalesNewToBrand14d	attributed_sales_newtobrand_14d
attributedSalesNewToBrandPercentage14d	attributed_sales_newtobrand_percentage_14d
unitsSold14d	units_sold_14d
dpv14d	dpv_14d
account_id	_account_id
profile_id	profile_id
MD5(campaignId + campaignName + adGroupName + adGroupId + keyId + keywordText + matchType + report_date + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Display

Sponsored Display Campaigns

• Endpoint: Sponsored Display - Campaigns
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_display_campaigns

JSON Element	Database Column
campaignId	campaign_id
name	campaign_name
tactic	tactic
startDate	start_date
state	state
budget	budget
servingStatus	serving_status
creationDate	created_at
lastUpdatedDate	updated_at
budgetType	budget_type
costType	cost_type
deliveryProfile	delivery_profile
account_id	_account_id
profile_id	profile_id
MD5(campaignId + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Display Ad Groups

• Endpoint: Sponsored Display - Ad Groups
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_display_ad_groups

JSON Element	Database Column
adGroupId	ad_group_id
name	ad_group_name
campaignId	campaign_id
defaultBid	default_bid
state	state
servingStatus	serving_status
creationDate	created_at
lastUpdatedDate	updated_at
tactic	tactic
account_id	_account_id
profile_id	profile_id
MD5(adGroupId + campaignId + profileId)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Display Product Ads

• Endpoint: Sponsored Display - Product Ads
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_display_product_ads

JSON Element	Database Column
adID	ad_id
adGroupId	ad_group_id
campaignId	campaign_id
asin	asin
sku	sku
state	state
ServingStatus	serving_status
CreationDate	created_at
LastUpdatedDate	updated_at
account_id	_account_id
profile_id	profile_id
MD5(adGroupId + adId + campaignId + profileId)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Display Targets

• Endpoint: Sponsored Display - Targets
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_display_targets

JSON Element	Database Column
adGroupID	ad_group_id
targetID	target_id
expressionType	expression_type
bid	bid
state	state
servingStatus	serving_status
creationDate	created_at
lastUpdatedDate	updated_at
account_id	_account_id
profile_id	profile_id
MD5(adGroupId + targetId + profileId)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Display Target Expressions

• Endpoint: Sponsored Display - Target Expressions

• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_display_target_expressions

JSON Element	Database Column
adGroupId	ad_group_id
targetId	target_id
expressionType	expression_type
key	type
value	value
account_id	_account_id
profile_id	profile_id
MD5(adGroupId + targetId + profileId)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Display Reports

• Endpoint: Sponsored Display - Report
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_display_reports

JSON Element	Database Column
reportType(campaign, adGroup, product ads)	report_type
tactic	tactic
date	report_date
campaignName	campaign_name
campaignID	campaign_id
impressions	impressions
clicks	clicks
cost	cost
currency	currency
attributedConversions1d	attributed_conversions_1d
attributedConversions7d	attributed_conversions_7d
attributedConversions14d	attributed_conversion_14d
attributedConversions30d	attributed_conversion_30d
attributedConversions1dSameSKU	attributed_conversions_1d_same_sku
attributedConversions7dSameSKU	attributed_conversions_7d_same_sku
attributedConversions14dSameSKU	attributed_conversions_14d_same_sku
attributedConversions30dSameSKU	attributed_conversions_30d_same_sku
attributedUnitsOrdered1d	attributed_units_ordered_1d
attributedUnitsOrdered7d	attributed_units_ordered_7d
attributedUnitsOrdered14d	attributed_units_ordered_14d
attributedUnitsOrdered30d	attributed_units_ordered_30d
attributedSales1d	attributed_sales_1d
attributedSales7d	attributed_sales_7d
attributedSales14d	attributed_sales_14d
attributedSales30d	attributed_sales_30d
attributedSales1dSameSKU	attributed_sales_1d_same_sku
attributedSales7dSameSKU	attributed_sales_7d_same_sku
attributedSales14dSameSKU	attributed_sales_14d_same_sku
attributedSales30dSameSKU	attributed_sales_30d_same_sku
adGroupName	ad_group_name
adGroupID	ad_group_id
asin	asin
sku	sku
adID	ad_id
account_id	_account_id
profile_id	profile_id
MD5(campaignId + campaignName + adGroupName + adGroupId + asin + sku + adId + report_date + profileId)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Products

Sponsored Products Campaigns

• Endpoint: Sponsored Products - Campaigns
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_products_campaigns

JSON Element	Database Column
campaignID	campaign_id
name	campaign_name
campaignType	campaign_type
targetingType	targeting_type
premiumBidAdjustment	premium_bid_adjustments
dailyBudget	daily_budget
startDate	start_date
state	state
portfolioID	portfolio_id
servingStatus	serving_status
creationDate	created_at
lastUpdatedDate	updated_at
account_id	_account_id
profile_id	profile_id
MD5(campaignId + profileId)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Products Campaigns Bid Strategy

• Endpoint: Sponsored Products - Campaign Bidding Strategy

• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_products_campaigns_bid_strategy

JSON Element	Database Column
campaignID	campaign_id
bidding::Strategy	bid_strategy
bidding::Adjustments::Predicate	bid_adjustment_predicate
bidding::Adjustments::Percentage	bid_adjustment_percentage
account_id	_account_id
profile_id	profile_id
MD5(campaignId + bidding::strategy + profileId)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Products Ad Groups

• Endpoint: Sponsored Products - Ad Groups
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_products_ad_groups

JSON Element	Database Column
adgroupID	ad_group_id
name	adgroup_name
campaignID	campaign_id
defaultBid	default_bid
state	state
servingStatus	serving_status
creationDate	created_at
lastUpdatedDate	updated_at
account_id	_account_id
profile_id	profile_id
MD5(adGroupId + profileId)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Products Ad Group Bid Recommendations

• Endpoint: Sponsored Products - Bid Recommendations
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_products_ad_group_bid_recommendations

JSON Element	Database Column
adGroupId	ad_group_id
suggestedBid::rangeEnd	suggested_bid_range_end
suggestedBid::rangeStart	suggested_bid_range_start
suggestedBid::suggested	suggested_bid_suggested
current_timestamp	created_at
current_timestamp	updated_at
account_id	_account_id
profile_id	profile_id
MD5(adGroupId + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Products Ad Group Keywords

• Endpoint: Sponsored Products - Keywords
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_products_ad_group_keywords

JSON Element	Database Column
keywordId	keyword_id
adGroupId	adgroup_id
campaignId	campaign_id
keywordText	keyword_text
matchType	match_type
state	state
bid	bid
servingStatus	serving_status
creationDate	created_at
lastUpdatedDate	updated_at
account_id	_account_id
profile_id	profile_id
MD5(keywordId + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Products Keyword Bid Recommendations

• Endpoint: Sponsored Products - Bid Recommendations
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_products_keyword_bid_recommendations

JSON Element	Database Column
keywordId	keyword_id
adGroupId	ad_group_id
suggestedBid::rangeEnd	suggested_bid_range_end
suggestedBid::rangeStart	suggested_bid_range_start
suggestedBid::suggested	suggested_bid_suggested
current_timestamp	created_at
current_timestamp	updated_at
account_id	_account_id
profile_id	profile_id
MD5(keywordId + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Products Suggested Keywords

• Endpoint: Sponsored Products - Suggested Keywords
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_products_suggested_keywords

JSON Element	Database Column
adGroupId	ad_group_id
keywordText	keyword_text
matchType	match_type
current_timestamp	created_at
current_timestamp	updated_at
account_id	_account_id
profile_id	profile_id
MD5(ad_group_id + keywordText + matchType + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Products Product Ads

• Endpoint: Sponsored Products - Product Ads
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_products_product_ads

JSON Element	Database Column
adId	ad_id
adGroupId	ad_group_id
campaignId	campaign_id
asin	asin
sku	sku
state	state
servingStatus	serving_status
creationDate	created_at
lastUpdatedDate	updated_at
account_id	_account_id
profile_id	profile_id
MD5(adId + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at

Sponsored Products Reports

• Endpoint: Sponsored Products - Reports
• Update Method: UPSERT

• Table Name: amazon_ads.sponsored_products_reports

JSON Element	Database Column
ReportType(campaign, keyword, adGroup, productAds)	report_type
bigplus	bigplus
date	report_date
segment	segment
campaignName	campaign_name
campaignId	campaign_id
adGroupName	ad_group_name
adGroupId	ad_group_id
keywordId	keyword_id
keywordText	keyword_text
matchType	match_type
campaignStatus	campaign_status
campaignBudget	campaign_budget
targetID	target_id
targetingExpression	targeting_expression
targetingText	targeting_text
targetingType	targeting_type
impressions	impressions
clicks	clicks
cost	cost
currency	currency
asin	asin
otherAsin	other_asin
sku	sku
attributedConversions1d	attributed_conversions_1d
attributedConversions7d	attributed_conversions_7d
attributedConversions14d	attributed_conversion_14d
attributedConversions30d	attributed_conversion_30d
attributedConversions1dSameSKU	attributed_conversions_1d_same_sku
attributedConversions7dSameSKU	attributed_conversions_7d_same_sku
attributedConversions14dSameSKU	attributed_conversions_14d_same_sku
attributedConversions30dSameSKU	attributed_conversions_30d_same_sku
attributedUnitsOrdered1d	attributed_units_ordered_1d
attributedUnitsOrdered7d	attributed_units_ordered_7d
attributedUnitsOrdered14d	attributed_units_ordered_14d
attributedUnitsOrdered30d	attributed_units_ordered_30d
attributedUnitsOrdered1dOtherSKU	attributed_units_ordered_1d_osku
attributedUnitsOrdered7dOtherSKU	attributed_units_ordered_7d_osku
attributedUnitsOrdered14dOtherSKU	attributed_units_ordered_14d_osku
attributedUnitsOrdered30dOtherSKU	attributed_units_ordered_30d_osku
attributedSales1d	attributed_sales_1d
attributedSales7d	attributed_sales_7d
attributedSales14d	attributed_sales_14d
attributedSales30d	attributed_sales_30d
attributedSales1dSameSKU	attributed_sales_1d_same_sku
attributedSales7dSameSKU	attributed_sales_7d_same_sku
attributedSales14dSameSKU	attributed_sales_14d_same_sku
attributedSales30dSameSKU	attributed_sales_30d_same_sku
attributedSales1dOtherSKU	attributed_sales_1d_osku
attributedSales7dOtherSKU	attributed_sales_7d_osku
attributedSales14dOtherSKU	attributed_sales_14d_osku
attributedSales30dOtherSKU	attributed_sales_30d_osku
attributedUnitsOrdered1dSameSKU	attributed_units_ordered_1d_same_sku
attributedUnitsOrdered7dSameSKU	attributed_units_ordered_7d_same_sku
attributedUnitsOrdered14dSameSKU	attributed_units_ordered_14d_same_sku
attributedUnitsOrdered30dSameSKU	attributed_units_ordered_30d_same_sku
account_id	_account_id
profile_id	profile_id
MD5(campaignId + campaignName + adGroupName + adGroupId + asin + sku + keyword + targetId + profile_id)	__sync_key
Daasity: timestamp when loaded into DB	__synced_at