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

Schema Information of the Amazon Attribution Connector

This subtopic provides a structured reference to assist you in working with Daton's Amazon Attribution connector and the associated fields and tables.

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

        Schema Information of the Amazon Attribution Connector

        This subtopic provides a structured reference to assist you in working with Daton's Amazon Attribution connector and the associated fields and tables.

        Tables/APIs

        The following is the list of tables or APIs associated with the Amazon Brand Metrics connector:

        Advertiser

        Gets a list of advertisers associated with an Amazon Attribution account. For sellers, an attribution profile has one associated advertiser. For vendors, an attribution profile may have more than one associated advertiser.
        For more information, see Amazon Attribution - Advertiser.
        Replication Type: Full Load
        Replication Key: N/A

        Field Name Data Type
        profileId STRING
        countryName STRING
        accountName STRING
        accountId STRING
        fetchDate DATE
        advertiserName STRING
        advertiserId STRING
        _daton_user_id NUMERIC
        _daton_batch_runtime NUMERIC
        _daton_batch_id NUMERIC

        MacroTag

        Gets a list of attribution tags for third-party publisher campaigns that support macros.
        For more information, see Amazon Attribution - Attribution Tags.
        Replication Type: Full Load
        Replication Key: N/A

        Field Name Data Type
        profileId STRING
        countryName STRING
        accountName STRING
        accountId STRING
        fetchDate DATE
        response RECORD

        NonMacroTemplateTag

        Gets a list of attribution tags for third-party publisher campaigns that do not support macros.
        For more information, see Amazon Attribution - Attribution Tags.
        Replication Type: Full Load
        Replication Key: N/A

        Field Name Data Type
        profileId STRING
        countryName STRING
        accountName STRING
        accountId STRING
        fetchDate DATE
        response RECORD

        PerformanceReport

        Retrieves performance report for Campaign, Adgroup and Creative dimensions
        For more information, see Amazon Attribution - Reports.
        ReportName in Seller Central: Campaign
        Replication Type: Key Based Replication
        Replication Key: Date

        Field Name Data Type
        profileId STRING
        countryName STRING
        accountName STRING
        accountId STRING
        reportDate DATE
        date STRING
        campaignId STRING
        advertiserName STRING
        adGroupId STRING
        creativeId STRING
        publisher STRING
        attributedDetailPageViewsClicks14d INTEGER
        attributedAddToCartClicks14d INTEGER
        attributedPurchases14d INTEGER
        unitsSold14d INTEGER
        attributedSales14d NUMERIC
        attributedTotalAddToCartClicks14d INTEGER
        attributedTotalDetailPageViewsClicks14d INTEGER
        attributedTotalPurchases14d NUMERIC
        totalAttributedSales14d NUMERIC
        click_throughs NUMERIC
        totalUnitsSold14d INTEGER

        ProductReport

        Retrieves product performance report for Campaign, Adgroup dimensions
        For more information, see Amazon Attribution - Reports. 
        ReportName in Seller Central: Promoted product
        Replication Type: Key Based Replication
        Replication Key: Date

        Field Name Data Type
        profileId STRING
        countryName STRING
        accountName STRING
        accountId STRING
        reportDate DATE
        date STRING
        brandName STRING
        productAsin STRING
        productConversionType STRING
        marketplace STRING
        campaignId STRING
        advertiserName STRING
        adGroupId STRING
        productName STRING
        productCategory STRING
        productSubcategory STRING
        productGroup STRING
        publisher STRING
        attributedDetailPageViewsClicks14d INTEGER
        attributedAddToCartClicks14d INTEGER
        attributedPurchases14d INTEGER
        unitsSold14d INTEGER
        attributedSales14d NUMERIC
        brandHaloDetailPageViewsClicks14d INTEGER
        brandHaloAttributedAddToCartClicks14d INTEGER
        brandHaloAttributedPurchases14d NUMERIC
        brandHaloUnitsSold14d INTEGER
        brandHaloAttributedSales14d NUMERIC
        attributedNewToBrandPurchases14d NUMERIC
        attributedNewToBrandUnitsSold14d INTEGER
        attributedNewToBrandSales14d NUMERIC
        brandHaloNewToBrandPurchases14d NUMERIC
        brandHaloNewToBrandUnitsSold14d INTEGER
        brandHaloNewToBrandSales14d NUMERIC

        Profile

        Retrieve all profiles associated with the Amazon Attribution account
        For more information, see Amazon Attribution - Profile.
        Replication Type: Full Load
        Replication Key: N/A

        Field Name Data Type
        profileId STRING
        fetchDate DATE
        countryCode STRING
        currencyCode STRING
        dailyBudget NUMERIC
        timeZone STRING
        accountInfo RECORD

        Publisher 

        Gets a list of all available publishers.

        For more information, see Amazon Attribution - Publisher.

        Replication Type: Full Load

        Replication Key: N/A

        Field Name Data Type
        profileId STRING
        countryName STRING
        accountName STRING
        accountId STRING
        fetchDate DATE
        macroEnabled BOOLEAN
        name STRING
        id STRING
        attribution connector amazon schema

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Essential Attributes and Supported Tables- Amazon Attribution
        • About the Amazon Attribution Connector
        • How to Integrate Amazon Attribution with Daton

        Table of Contents

        Tables/APIs Advertiser MacroTag NonMacroTemplateTag PerformanceReport ProductReport Profile Publisher

        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