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
Attribution
Attribution Advertisers
Endpoint: Attribution - Advertisers
Update Method: UPSERT
Table Name:
amazon_ads.advertisers
Attribution Publishers
Endpoint: Attribution - Publishers
Update Method: UPSERT
Table Name:
amazon_ads.attribution_publishers
Attribution Tags Macro-Enabled
Endpoint: Attribution - Attribution Tags
Update Method: UPSERT
Table Name:
amazon_ads.attribution_tags_macroenabled
Attribution Tags Non-Macro-Enabled
Endpoint: Attribution - Attribution Tags
Update Method: UPSERT
Table Name:
amazon_ads.attribution_tags_nonmacroenabled
Attribution Reports
Endpoint: Attribution - Reports
Update Method: UPSERT
Table Name:
amazon_ads.attribution_reports
Sponsored Brands
Sponsored Brands Brands
Endpoint: Sponsored Brands - Brands
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_brands_brands
Sponsored Brands Stores
Endpoint: Sponsored Brands - Brand Stores
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_brands_stores
Sponsored Brands Campaigns
Endpoint: Sponsored Brands - Campaigns
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_brands_campaigns
Sponsored Brands Ad Groups
Endpoint: Sponsored Brands - Ad Groups
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_brands_ad_groups
Sponsored Brands Keywords
Endpoint: Sponsored Brands - Keywords
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_brands_keywords
Sponsored Brands Negative Keywords
Endpoint: Sponsored Brands - Negative Keywords
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_brands_negative_keywords
Sponsored Brands Product Targeting
Endpoint: Sponsored Brands - Product Targeting
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_brands_product_targeting
Sponsored Brands Product Targeting Expressions
Endpoint: Sponsored Brands - Product Targeting Expressions
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_brands_product_targeting_expressions
Sponsored Brands Reports
Endpoint: Sponsored Brands - Reports
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_brands_reports
Sponsored Display
Sponsored Display Campaigns
Endpoint: Sponsored Display - Campaigns
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_display_campaigns
Sponsored Display Ad Groups
Endpoint: Sponsored Display - Ad Groups
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_display_ad_groups
Sponsored Display Product Ads
Endpoint: Sponsored Display - Product Ads
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_display_product_ads
Sponsored Display Targets
Endpoint: Sponsored Display - Targets
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_display_targets
Sponsored Display Target Expressions
Endpoint: Sponsored Display - Target Expressions
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_display_target_expressions
Sponsored Display Reports
Endpoint: Sponsored Display - Report
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_display_reports
Sponsored Products
Sponsored Products Campaigns
Endpoint: Sponsored Products - Campaigns
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_products_campaigns
Sponsored Products Campaigns Bid Strategy
Endpoint: Sponsored Products - Campaign Bidding Strategy
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_products_campaigns_bid_strategy
Sponsored Products Ad Groups
Endpoint: Sponsored Products - Ad Groups
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_products_ad_groups
Sponsored Products Ad Group Bid Recommendations
Endpoint: Sponsored Products - Bid Recommendations
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_products_ad_group_bid_recommendations
Sponsored Products Ad Group Keywords
Endpoint: Sponsored Products - Keywords
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_products_ad_group_keywords
Sponsored Products Keyword Bid Recommendations
Endpoint: Sponsored Products - Bid Recommendations
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_products_keyword_bid_recommendations
Sponsored Products Suggested Keywords
Endpoint: Sponsored Products - Suggested Keywords
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_products_suggested_keywords
Sponsored Products Product Ads
Endpoint: Sponsored Products - Product Ads
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_products_product_ads
Sponsored Products Reports
Endpoint: Sponsored Products - Reports
Update Method: UPSERT
Table Name:
amazon_ads.sponsored_products_reports
Last updated
