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
      • 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
  • Amazon Fulfillment Reports
  • Where to analyze this data
  • How to validate this data
  • Amazon Business Reports
  • Where to analyze this data
  • Known causes for discrepancies

Was this helpful?

  1. Extract
  2. All Integrations
  3. Amazon Seller Central

Validating Your Amazon Data in Daasity

Important things to know when analyzing your Amazon Seller Central data in Daasity

PreviousAmazon Seller CentralNextComparing Your Amazon Seller Central Orders to Daasity

Last updated 1 year ago

Was this helpful?

Use this guide to understand which explores and dashboards to use in Daasity based on the reports you already use within Amazon.

Amazon Fulfillment Reports

Almost all of the order-based Amazon reporting in Daasity uses data from the All Orders report:

Where to analyze this data

You can analyze data from the All Orders report in the following places.

Filter for Source Name = asc to isolate Amazon data

If you have both Amazon and owned Ecommerce data in Daasity, you'll need to filter for the asc source name to only show data from Amazon

Explores

  • Order Line Revenue

  • Transactional Sales

  • Daily Plan to Actual

  • Daily Company Metrics

  • Lifetime Value Time Series

Dashboards

  • LTV & RFM

  • Retention

  • Orders & Revenue

  • Daily Flash

  • Daily Flash vs Plan

  • Hourly Flash

  • Weekly Flash

  • Repurchase Rates

  • Product (Except for the Product Detail Page Performance, which uses the Sales and Traffic Business Report)

Raw data tables

  • AMAZON_SELLER_CENTRAL.GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL

How to validate this data

Known causes for discrepancies

The data you see in your Daasity reporting will vary slightly from the raw All Orders reports you download from the Amazon Seller Central UI for the following reasons:

Timezone conversion

The raw report date/time values are always in UTC. The order data in your Daasity reporting will be converted to the timezone you have specified in your Daasity App settings.

Currency conversion

The monetary values in the raw Orders by Last Updated Date report will be in the source currency. The order data in your Daasity reporting will be converted to the master currency you have specified in your Daasity App settings. This will only be important to know if you are selling in multiple countries.

Multiple order lines for the same SKU

Amazon sometimes creates orders that have multiple lines for the same SKU, like in the example screenshot below:

In this scenario, Daasity will pick up only one of the lines from the order and drop the other. This will result in a discrepancy in some orders' sales totals and item counts when comparing in Daasity vs Amazon. This happens in only a small subset of orders (typically less than 2%), but it unfortunately will have an impact on your reporting.

If this unique order item ID was included in the report, we would use it as a primary key to help us ensure that we avoid loading duplicate data while also capturing updates to the same line over time. But since the order item ID does not come through in the raw data, we need to create a unique key from the information available in the file. We use the combination of order ID + SKU for the unique ID. In the cases like the example above, this combination is not truly unique — only the order item ID is truly unique — and as a result only one of the rows will be loaded to avoid data duplication.

Choose the Order Date report when comparing data with Daasity

When you download the All Orders report, you have the option of choosing to filter by Order Date or Last Updated Date:

If you are comparing data for a particular month between Daasity and the Amazon platform, it's best to choose the Order Date option.

Don't use the Last Updated Date option. If you're trying to compare data for orders placed in January 2024, for example, and you choose the Last Updated date option, that file could contain orders that were placed prior to January 2024. Additionally, if an order placed in January 2024 was updated in a later month, that order would not show up in that report download.

Compare gross sales in Daasity with the sum of item-price in the All Orders exports

Since the export contains and item-price column and a quantity column, you may (understandably) assume that you need to multiply item-price by quantity to get the full sales amount for the line item. In reality, item-price will reflect the sales amount for the entire line — it is not a unit price.

Amazon Business Reports

Daasity standard reports will use data from the Sales and Traffic report and the Detail Page Sales and Traffic report from Amazon.

Where to analyze this data

Amazon Sales and Traffic report

You can analyze data from the Sales and Traffic report in the following places:

Filter for Data Source = Amazon to isolate Amazon data

If you have both Google Analytics and Amazon data connected to Daasity, you'll need to filter for the Amazon data source to only show data from Amazon.

Explores

  • Traffic

  • Daily Plan to Actual*

Dashboards

  • Analytics & Attribution

  • Daily Flash*

  • Daily Flash vs Plan*

  • Weekly Flash*

* Only sessions from the Amazon Sales and Traffic report are used in these reports/explores. The sales and order data will be from the Amazon Orders by Last Updated Date fulfillment report.

Raw data tables

  • AMAZON_SELLER_CENTRAL.SALES_AND_TRAFFIC_REPORT

Amazon Detail Page Sales and Traffic report

You can analyze data from the Detail Page Sales and Traffic report in the following places:

Filter for Data Source = Amazon to isolate Amazon data

If you have both Google Analytics and Amazon data connected to Daasity, you'll need to filter for the Amazon data source to only show data from Amazon.

Explores

  • Product Page

Dashboards

  • Product (Only the Product Detail Page Performance tile)

Raw data tables

  • AMAZON_SELLER_CENTRAL.SALES_AND_TRAFFIC_SKU_REPORT

Known causes for discrepancies

Where this data is used in standard reports (listed in the previous section), it should match the UI exactly, except for any updates that have been made to orders since the data was extracted. For example, if we extract and transform the data at 1AM, there may be some changes between that time and when you analyze the data in the morning that will not be reflected in the Daasity reports.

However, when if you compare data from the Amazon Business Reports with other order-based reporting in Daasity (e.g.: Order Line Revenue, Transactional Sales, Daily Plan to Actual), there will be discrepancies for the following reasons:

Timezone conversion

Keep this in mind when comparing data from your Business Reports with Amazon order data in Daasity. All order data in Daasity is taken from the Orders by Last Updated Date fulfillment report and has been converted to match your Daasity account timezone settings. If your Daasity account is set to a timezone different from the marketplace you are comparing in the Amazon UI, you should expect a discrepancy.

Data loss for orders with multiple lines for the same SKU

As mentioned in the Amazon Fulfillment Reports section, there is an issue with the data export if an order has multiple lines for the same sku. Please read the Known causes for discrepancies section for the Fulfillment Reports for more details.

The core reason for this issue is that the raw Amazon report we use for order-based reporting — (or the "All Orders" report as it's named in the UI) — accurately reflects the contents of the order, BUT it does not provide the unique order item ID that you see in the screenshot:

The Amazon Business Reports will reflect set by Amazon. So if you are looking at reports for a US marketplace, for example, all of the data will reflect the Los Angeles time zone.

🔌
Flat File Orders by Last Update Report
the marketplace timezone
Where to find the All Orders report in the Amazon Seller Central UI
Where to find the Sales & Traffic report in the Amazon Seller Central UI
Where to find the Detail Page Sales & Traffic report in the Amazon Seller Central UI
Same product, different line items