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:
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.
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
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 |
Last updated
