Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • Alchemer
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Algolia
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Amazon Advertising
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Amazon Seller Central
        • Validating Your Amazon Data in Daasity
          • Comparing Your Amazon Seller Central Orders to Daasity
        • Integration Setup
          • Configure Amazon Reports
          • Monitor Amazon Reports
        • Integration Specifications
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Sales Reports
          • FBA Inventory Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Performance Reports
          • Returns Reports
          • Settlement Reports
          • Seller Retail Analytics Reports
        • Workflow Configuration Setup
          • Orders API
          • FBA Customer Concession Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removal Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
        • Transformation Configuration Setup
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
      • Amazon Vendor Central
        • Integration Setup
        • Integration Specifications
        • How to use
        • ASIN Mapping Configuration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
          • Vendor Sales & Inventory Report
          • Vendor Traffic Report
      • AppLovin
        • Integration Setup
      • Attentive Mobile
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Azure SQL Database
      • Back In Stock
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Big Commerce
        • Integration Setup
          • Connect Daasity From BigCommerce Marketplace
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • BigQuery Datasource
      • Bing Ads
        • Integration Setup
        • Integration Specifications
      • Circana
        • Integration Setup
        • Integration Specifications
        • Data Release Calendar
        • H-E-B Circana
      • Cordial
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Criteo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • D​ata File (CSV, XLS)
      • Emplifi
        • Integration Specifications
      • Extensiv (Skubana)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Facebook Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Fairing V2
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Important Notes
      • Google Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Google Analytics 4
        • API vs BigQuery
        • API Integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Custom Reports
          • Validating GA4 Data in Daasity
          • Blending Universal Analytics & GA4 Data
        • BigQuery integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Important Notes
          • Creating a Custom Report
      • Google Sheet
      • Gorgias
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Impact Radius (Beta)
        • Integration Specifications
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Klaviyo Summary Statistics
        • Integration Setup
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • Loop Returns
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Microsoft SQL Server Database
      • Mongo Database
      • MySQL Database
      • Narvar
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • NetSuite
      • Newstore
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Northbeam
        • Integration Setup
      • Okendo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Ometria
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Order Desk
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pepperjam
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pinterest
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Postgres Database
      • Postscript (beta)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Recharge
        • Integration Setup
        • Integration Specifications
        • Integration Specifications (2021-11 Beta)
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Recharge Data and Known Discrepancies
      • Retail Next
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Salesforce Commerce Cloud
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SFTP
      • ShipBob
        • Integration Setup
        • Integration Specifications
      • Shipstation
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Shopify
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Shopify B2B Data
      • SKIO
        • Integration Setup
        • Integration Specifications
      • Snapchat
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SPINS
        • Integration Setup
        • Integration Specifications
        • How to Use
        • Data Release Calendar
      • Stay Ai
        • Integration Setup
        • Integration Specifications
      • Target Plus
        • Integration Setup
      • Thankful
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • TikTok
        • Integration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Walmart Marketplace
        • Integration Setup
        • Integration Specifications
      • Whole Foods Market
        • Integration Setup
        • Integration Specifications
        • How to use
      • Yotpo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Zendesk
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
    • Brand Supplied Data (BSD)
      • BSD Overview
      • Monitoring Your BSD Progress
      • Revenue Plan
      • Marketing Budget
      • Marketing Spend
      • RFM Values
      • Shipping & Fulfillment Cost
      • SKU Hierarchy
      • SKU Mapping
      • SKU Cost
      • Discount Code Mapping
      • Other Order Sources
      • Channel Mapping
        • Overview & Setup
        • Filling out Channel Mapping
        • Missing from GA & Missing from BSD
      • Configuration
  • 📊VISUALIZE
    • Dashboards
      • Dashboard Overview
      • Standard Dashboards
        • Daasity 101 Overview Dashboards
          • Flashes
          • Shopify Sales Report
          • Account Health
        • Digital Product & Revenue
          • Orders and Revenue
          • Amazon Settlement Report
          • Product Repurchase Rate
          • Product
            • Product Dimensions
              • Why is a Product Name NULL?
          • Inventory
          • Operations
            • Fulfilment Status Options
        • Retention Marketing Dashboards
          • Notifications (Email/SMS)
          • Retention
          • Customer Performance (Email/SMS)
          • Site Funnels
        • Acquisition Marketing Dashboards
          • Attribution Deep Dive
            • Marketing Attribution
              • Attribution Overview
              • Survey-Based Attribution
              • Discount Code Attribution
              • First Click, Last Click, and Assisted Attribution
              • Custom Attribution
              • Vendor-Reported Attribution
              • CPO, CPA, and CAC
              • Missing from GA & Missing from BSD
          • LTV & RFM
            • RFM
              • RFM in the Daasity App
              • Understanding RFM
              • Time on Books (TOB)
          • Marketing
          • Vendor-Reported Marketing Performance
          • Site Analytics & Attribution
      • Integration Dashboards
        • Amazon All Orders Report
        • Amazon Seller Central Business Reports
        • Gorgias
        • Klaviyo Campaign & Flow Performance
        • Loop Returns
        • Okendo Reviews
        • ShipBob
        • Shipstation
        • Subscription
        • Walmart Marketplace Account Sales Report
        • Yotpo
    • Explores
      • Explore Overview
      • Order Line Revenue vs. Transactional Sales Report
      • How to Access An Explore
      • Standard Daasity Explores
        • Current Inventory Level Explore
        • Customer Details Explore
        • Daily Company Metrics Explore
        • Daily Marketing Plan To Actual Marketing Performance Explore
        • Daily Plan to Actual Explore
        • Lifetime Value Explore
        • Marketing Attribution Explore
        • Multi-Channel Transaction Explore
        • Order and Order Line Revenue Explore
        • Product Page Explore
        • Shopping Stage Explore
        • SKU Level Repurchase Rates Explore
        • Traffic Explore
        • Transactional Sales Report Explore
        • UA vs G4 Explore
      • Integration Explores
        • Algolia
        • Amazon Settlement Explore
        • Fairing Survey Responses Explore
        • Gorgias Tickets Explore
        • Loop Returns Explore
        • Okendo Reviews Explore
        • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
        • Shipstation Explore
        • Yotpo
        • Zen Desk
    • Looker Guides
      • Building visualizations
      • Working with date dimensions & filters
      • Schedule a Report or Dashboard
      • Exporting Data
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • BigQuery
    • Redshift
    • Snowflake
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  • Integration Overview
  • Integration Availability
  • API Endpoints
  • Entity Relationship Diagram (ERD)
  • Amazon Ads Schema
  • Profiles
  • Attribution
  • Sponsored Brands
  • Sponsored Display
  • Sponsored Products

Was this helpful?

  1. Extract
  2. All Integrations
  3. Amazon Advertising

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.

PreviousIntegration SetupNextWorkflow Configuration Setup

Last updated 1 year ago

Was this helpful?

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.

Integration Availability

This integration is available for:

  • Enterprise

  • Growth

API Endpoints

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

  • Attribution

  • Sponsored Brands

  • Sponsored Display

  • Sponsored Products

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)

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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

illustrating the different tables and keys to join across tables.

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

🔌
(source)
Amazon Ads API documentation
Profiles
Attribution Advertisers
Attribution Publishers
Attribution Reports
Attribution Tags
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 Ad Groups
Sponsored Display Campaigns
Sponsored Display Product Ads
Sponsored Display Reports
Sponsored Display Targeting
Sponsored Display Targeting Recommendations
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
Click here to view the ERD for the Daasity Amazon Ads integration
Profiles
Attribution - Advertisers
Attribution - Publishers
Attribution - Attribution Tags
Attribution - Attribution Tags
Attribution - Reports
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 - Reports
Sponsored Display - Campaigns
Sponsored Display - Ad Groups
Sponsored Display - Product Ads
Sponsored Display - Targets
Sponsored Display - Report
Sponsored Products - Campaigns
Sponsored Products - Ad Groups
Sponsored Products - Bid Recommendations
Sponsored Products - Keywords
Sponsored Products - Bid Recommendations
Sponsored Products - Suggested Keywords
Sponsored Products - Product Ads
Sponsored Products - Reports
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
Amazon Ads Authorization