Daasity Knowledge Base
Ask or search…
K

Where to Find Your Data

Here is where you can find your Amazon Ads data once the integration has been successfully implemented and data has been loaded.

In Your Data Warehouse

If you are an Enterprise merchant, you can analyze your Amazon Ads data directly in your data warehouse.

Raw Data

You can analyze your raw, extracted data using the tables in your Amazon Ads Schema.

Transformed Data

You can also view your Amazon Ads data in more analysis-friendly tables if you set up the proper transformation code and wait for the next workflow to run.
If you have set up Amazon Ads transformation configuration, then your Amazon Ads data will be transformed into the following tables:
  • ums.amazon_ads_sponsored_products_spend
  • ums.amazon_ads_sponsored_product_display_spend
  • ums.amazon_ads_sponsored_brands_spend
If you have configured your Marketing Data Mart Code, you will also find Amazon Ads data in the following table:
  • dm_mkt.fct_vendor_level_performance

In Looker

If you are using Daasity's Looker template, you can analyze your transformed Amazon Ads data alongside other marketing sources in the following explores & dashboards:

Explores

  • Marketing Attribution
  • Vendor-Reported Marketing Performance

Dashboards

  • Marketing