> For the complete documentation index, see [llms.txt](https://help.daasity.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/amazon-advertising/integration-specifications.md). # Integration Specifications ## 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. {% hint style="warning" %} **Only 60 days of history available** Amazon Ads only makes the last 60 days of history available via the API. [(source)](https://advertising.amazon.com/API/docs/en-us/guides/reporting/v2/advertising-console) {% endhint %} ## 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](https://advertising.amazon.com/API/docs/en-us/info/api-overview). The following endpoints are used by Daasity to replicate data from Amazon Ads: * [Profiles](https://advertising.amazon.com/API/docs/en-us/reference/2/profiles) * Attribution * [Attribution Advertisers](https://advertising.amazon.com/API/docs/en-us/amazon-attribution-prod-3p/#/Advertisers) * [Attribution Publishers](https://advertising.amazon.com/API/docs/en-us/amazon-attribution-prod-3p/#/Publishers) * [Attribution Reports](https://advertising.amazon.com/API/docs/en-us/amazon-attribution-prod-3p/#/Reports) * [Attribution Tags](https://advertising.amazon.com/API/docs/en-us/amazon-attribution-prod-3p/#/Attribution%20Tags) * Sponsored Brands * [Sponsored Brands Ad Groups](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Ad%20groups) * [Sponsored Brands Brands](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Brands) * [Sponsored Brands Campaigns](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Campaigns) * [Sponsored Brands Keywords](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Keywords) * [Sponsored Brands Negative Keywords](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Negative%20keywords) * [Sponsored Brands Product Targeting](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Product%20targeting) * [Sponsored Brands Product Targeting Expressions](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Targeting%20recommendations) * [Sponsored Brands Report](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Reports) * [Sponsored Brands Stores](https://advertising.amazon.com/API/docs/en-us/reference/2/stores) * Sponsored Display * [Sponsored Display Ad Groups](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Ad%20groups) * [Sponsored Display Campaigns](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Campaigns) * [Sponsored Display Product Ads](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Product%20ads) * [Sponsored Display Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Reports) * [Sponsored Display Targeting](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Targeting) * [Sponsored Display Targeting Recommendations](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Targeting%20Recommendations) * Sponsored Products * [Sponsored Products Ad Groups](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Ad%20groups) * [Sponsored Products Bid Recommendations](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Bid%20recommendations) * [Sponsored Products Campaigns](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Campaigns) * [Sponsored Products Keywords](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Keywords) * [Sponsored Products Suggested Keywords](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Suggested%20keywords) * [Sponsored Products Product Ads](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Product%20ads) * [Sponsored Products Reports](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Reports) {% hint style="info" %} 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. {% endhint %}

Amazon Ads Authorization

## Entity Relationship Diagram (ERD) [Click here to view the ERD for the Daasity Amazon Ads integration](https://lucid.app/documents/embedded/f4c98d1f-7808-4083-a5fc-e7d9f0e21fd3) 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](#profiles) * [Attribution](#attribution) * [Attribution Advertisers](#attribution-a-dvertisers) * [Attribution Publishers](#attribution-publishers) * [Attribution Tags Macro Enabled](#attribution-tags-macro-enabled) * [Attribution Tags Non-Macro-Enabled](#attribution-tags-non-macro-enabled) * [Attribution Report](#attribution-reports) * [Sponsored Brands](#sponsored-brands) * [Sponsored Brands Brands](#sponsored-brands-brands) * [Sponsored Brands Brand Stores](#sponsored-brands-stores) * [Sponsored Brands Campaigns](#sponsored-brands-campaigns) * [Sponsored Brands Ad Groups](#sponsored-brands-a-d-groups) * [Sponsored Brands Keywords](#sponsored-brands-keywords) * [Sponsored Brands Negative Keywords](#sponsored-brands-negative-keywords) * [Sponsored Brands Product Targeting](#sponsored-brands-product-targeting) * [Sponsored Brands Product Targeting Expressions](#sponsored-brands-product-targeting) * [Sponsored Brands Reports](#sponsored-brands-reports) * [Sponsored Display](#sponsored-display) * [Sponsored Display Campaigns](#sponsored-display-campaigns) * [Sponsored Display Ad Groups](#sponsored-display-a-d-groups) * [Sponsored Display Product Ads](#sponsored-display-product-a-ds) * [Sponsored Display Targets](#sponsored-display-targets) * [Sponsored Display Targets Expressions](#sponsored-display-target-expressions) * [Sponsored Display Reports](#sponsored-display-reports) * [Sponsored Products](#sponsored-products) * [Sponsored Products Campaigns](#sponsored-products-campaigns) * [Sponsored Products Campaign Bidding Strategy](#sponsored-products-campaigns-bid-strategy) * [Sponsored Products Ad Groups](#sponsored-products-a-d-groups) * [Sponsored Products Ad Group Bid Recommendations](#sponsored-products-a-d-group-keywords) * [Sponsored Products Ad Group Keywords](#sponsored-products-a-d-group-keywords) * [Sponsored Products Product Ads](#sponsored-products-product-a-ds) * [Sponsored Products Keyword Bid Recommendation](#sponsored-products-keyword-bid-recommendations) * [Sponsored Products Suggested Keywords](#sponsored-products-suggested-keywords) * [Sponsored Products Reports](#sponsored-products-reports) ### Profiles * Endpoint: [Profiles](https://advertising.amazon.com/API/docs/en-us/reference/2/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](https://advertising.amazon.com/API/docs/en-us/amazon-attribution-prod-3p/#/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](https://advertising.amazon.com/API/docs/en-us/amazon-attribution-prod-3p/#/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](https://advertising.amazon.com/API/docs/en-us/amazon-attribution-prod-3p/#/Attribution%20Tags) * 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](https://advertising.amazon.com/API/docs/en-us/amazon-attribution-prod-3p/#/Attribution%20Tags) * 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](https://advertising.amazon.com/API/docs/en-us/amazon-attribution-prod-3p/#/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](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Brands) * Update Method: UPSERT * Table Name: `amazon_ads.sponsored_brands_brands`
JSON ElementDatabase Column
brandIdbrand_id
brandEntityIdbrand_entity_id
brandRegistryNamebrand_registry_name
_account_id_account_id
profile_idprofile_id
MD5(brandId + profile_id)__sync_key
timestamp when loaded into DB__synced_at
#### **Sponsored Brands Stores** * Endpoint: [Sponsored Brands - Brand Stores](https://advertising.amazon.com/API/docs/en-us/reference/2/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](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/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](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Ad%20groups) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/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](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Negative%20keywords) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/Product%20targeting) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-brands/3-0/openapi#/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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Ad%20groups) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Product%20ads) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Targeting) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-display/3-0/openapi#/Reports) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Ad%20groups) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Bid%20recommendations) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Bid%20recommendations) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Suggested%20keywords) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/Product%20ads) * 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](https://advertising.amazon.com/API/docs/en-us/sponsored-products/2-0/openapi#/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 | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://help.daasity.com/core-concepts/data-integrations/setup-guides/digital-integrations/amazon-advertising/integration-specifications.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.