Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Amazon Sponsored Products

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        Need help with something?

        Talk to data expert

        Amazon Sponsored Products

        Essential Attributes

        The following table shows some of the essential connector attributes and their details:

        Features Details
        Release Status Released
        Source API Version V2
        Table Selection Yes
        Column Selection Yes
        Edit Integration Yes
        Replication Type Selection No
        Authentication Parameters Login ID and Password
        Replication Type Full Replication Key Based Incremental
        Replication Key Date
        Suggested Replication Frequency 24 hours
        Supports attribution Yes

         Supported Tables

        The following table lists all the tables supported by Daton for the Amazon Sponsored Products connector:

        Supported Table Names
        Profile
        Portfolio
        Store
        ProductMetadata
        Campaign
        CampaignEx
        AdGroup
        AdGroupEx
        BiddableKeyword
        BiddableKeywordsEx
        NegativeKeyword
        NegativeKeywordEx
        CampaignNegativeKeyword
        CampaignNegativeKeywordEx
        ProductAd
        ProductAdEx
        TargetingClause
        TargetingClauseEx
        KeywordBidRecommendations
        TargetBidRecommendations
        SuggestedKeywords
        ProductTargetingRecommendations
        NegativeTargetingClause
        CampaignsReports
        Store_AsinEngagement
        StoresInsights

        Reports Mapping

        The following table represents how Daton maps tables with respect to the reports you see in the Amazon Ad console interface.

        Report in Ad console Report in Daton
        Search term SearchTermKeywordReport
        Targeting SearchTermTargetingReport
        Advertised product ProductAdsReport
        Campaign CampaignsReport
        Budget -
        Placement PlacementCampaignsReport
        Purchased product

        AsinsReportWithTargetId

        AsinsReportWithKeywordId

        Performance Over Time -
        Search Term Impression Share -
        Gross And Invalid Traffic -

        Known Issues

        1. Amazon reconciles data and may update metrics for up to 30 days. If you want to use 7-day attribution metrics, then you must select 8-day attribution offset in the configuration.
        2. Daton will repeat the report data for a given date depending on the attribution offset selected
        3. Data would always be fetched for the previous day after 2 AM Seller time
        4. There can be mismatches of <1% in metrics even with 30-day attribution selection in Daton

        Authentication Credentials

        1. Sponsored Product APIs work for 'Seller' type users. Agency users and Attribution accounts will not have access to APIs.
        2. User account used for authentication must have access to Campaign Manager and all Reports.

        Integrate Amazon Sponsored Product Ads with Daton

        1. Sign in to Daton.
        2. Select Amazon Sponsored Product from the Connectors page.
        3. Provide all required configuration parameters - Integration Name, Replication Frequency, History, Region/Marketplace, and Attribution lookback. The integration name would be used while creating tables in the warehouse and cannot be changed later.
        4. You will be redirected to the Amazon Advertising login page to authorize Daton to extract data periodically. Log in with your seller account.
        5. After authentication, you will be prompted to choose from the list of available Amazon Advertising Accounts/ProfileIds.
        6. After account selection, you'll be prompted to select the Tables/APIs for replication.
        7. Then select the required fields for each table.
        8. Submit the integration.

        Workflow

        1. Integrations would be in the configuring state initially. They would be moved to the active state when selected tables are created in the warehouse.
        2. Users would be able to edit/pause/re-activate/delete integration anytime.
        3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list.

        Schema Information

        Dive deeper into data structuring essentials by now visiting the Amazon Sponsored Products - Schema Information page.

        e-commerce promotion amazon promotion

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Product Glossary
        • April
        • Essential Attributes and Supported Tables for Amazon Selling Partner
        • September
        • Essential Attributes and Supported Tables for Pinterest

        Table of Contents

        Essential Attributes Supported Tables Reports Mapping Known Issues Authentication Credentials Integrate Amazon Sponsored Product Ads with Daton Workflow Schema Information

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand