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.
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 |