Amazon Ads

##Snapshot
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<br>Key Based Incremental
Replication Key | Date
Suggested Replication Frequency | 24 hours
​
##Tables/APIs Supported
|||
:---: | :---:
Profile | Portfolio 
Store | SponsoredProducts_Campaign 
SponsoredProducts_CampaignEx | SponsoredProducts_AdGroup 
SponsoredProducts_AdGroupEx | SponsoredProducts_BiddableKeyword 
SponsoredProducts_BiddableKeywordsEx | SponsoredProducts_NegativeKeyword 
SponsoredProducts_NegativeKeywordEx | SponsoredProducts_CampaignNegativeKeyword 
SponsoredProducts_CampaignNegativeKeywordEx | SponsoredProducts_ProductAd 
SponsoredProducts_ProductAdEx | SponsoredProducts_TargetingClause 
SponsoredProducts_TargetingClauseEx | SponsoredProducts_CampaignsReports 
SponsoredProducts_CampaignsReports_Placement | SponsoredProducts_AdGroupReports 
SponsoredProducts_KeywordReports | SponsoredProducts_KeywordReports_SearchTerm 
SponsoredProducts_ProductAdsReports | SponsoredProducts_ProductTargetingReports 
SponsoredProducts_ProductTargetingReports_SearchTerm | 
​
##Integrate AmazonAds with Daton
1. Signin to Daton.
2. Select AmazonAds from Integrations page
3. Provide Integration Name, Replication Frequency, History and Region/Marketplace associated with your Amazon Advertising account. Integration name would be used in creating tables for the integration and cannot be changed later.
4. You will be redirected to Amazon Advertising login for authorizing Daton to extract data periodically.
5. Post successful 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 which you need daton to pull.
7. Then select required fields for each table.
8. Submit the integration.
​
##Workflow
1. Integrations could be seen Active tab of Integration List while the job loads data on to the configured 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.
​
##AmazonAds Data
###TABLES
​
​
####Profile
Purpose: Retrieve all profiles associated with the Amazon Advertising account.
​
Source API Documentation: <Link> [Amazon Ads Profile](https://advertising.amazon.com/API/docs/en-us/reference/2/profiles)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
countryCode | STRING
currencyCode | STRING
dailyBudget | NUMERIC
timeZone | STRING
accountInfo | RECORD
​
####Portfolio
Purpose: Retrieve a list of up to 100 portfolios.
​
Source API Documentation: <Link> [Amazon Ads Portfolio](https://advertising.amazon.com/API/docs/en-us/reference/2/portfolios)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
portfolioId | STRING
name | STRING
budget | RECORD
inBudget | BOOLEAN
state | STRING
​
####Store
Purpose: List store information for all registered stores under an advertiser.
​
Source API Documentation: <Link> [Amazon Ads Store](https://advertising.amazon.com/API/docs/en-us/reference/2/stores)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
code | STRING
entityId | STRING
storeName | STRING
brandEntityId | STRING
storePageInfo | RECORD
​
####SponsoredProducts_Campaign
Purpose: Return a list of Sponsored Products campaigns.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Campaign](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/campaigns)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
campaignId | STRING
name | STRING
campaignType | STRING
targetingType | STRING
state | STRING
dailyBudget | NUMERIC
startDate | STRING
premiumBidAdjustment | BOOLEAN
bidding | RECORD
​
####SponsoredProducts_CampaignEx
Purpose: Return a list of Sponsored Products campaigns with additional properties.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Campaign Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/campaigns)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
campaignId | STRING
name | STRING
campaignType | STRING
targetingType | STRING
state | STRING
dailyBudget | NUMERIC
startDate | STRING
premiumBidAdjustment | BOOLEAN
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
bidding | RECORD
​
####SponsoredProducts_AdGroup
Purpose: Return a list of ad groups.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Products - Ad Group](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-groups)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
adGroupId | STRING
campaignId | STRING
name | STRING
defaultBid | NUMERIC
state | STRING
​
####SponsoredProducts_AdGroupEx
Purpose: Return a list of ad groups with additional properties
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Ad Group Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-groups)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
adGroupId | STRING
campaignId | STRING
name | STRING
defaultBid | NUMERIC
state | STRING
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
​
####SponsoredProducts_BiddableKeyword
Purpose: Return a list of ad group-level biddable keywords.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Keyword](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-keywords)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
keywordId | STRING
campaignId | STRING
adGroupId | STRING
state | STRING
keywordText | STRING
matchType | STRING
​
####SponsoredProducts_BiddableKeywordsEx
Purpose: Return a list of ad group-level biddable keywords with additional properties.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Keyword Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-keywords)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
keywordId | STRING
campaignId | STRING
adGroupId | STRING
state | STRING
keywordText | STRING
matchType | STRING
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
​
####SponsoredProducts_NegativeKeyword
Purpose: Return a list of negative ad group-level keywords.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Negative Keyword](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-negative-keywords)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
keywordId | STRING
campaignId | STRING
adGroupId | STRING
state | STRING
keywordText | STRING
matchType | STRING
​
####SponsoredProducts_NegativeKeywordEx
Purpose: Return a list of negative ad group-level keywords with additional properties.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Negative Keyword Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/ad-group-negative-keywords)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
keywordId | STRING
campaignId | STRING
adGroupId | STRING
state | STRING
keywordText | STRING
matchType | STRING
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
​
####SponsoredProducts_CampaignNegativeKeyword
Purpose: Return a list of campaign level negative keywords.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Campaign Negative Keyword](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/campaign-negative-keywords)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
keywordId | STRING
campaignId | STRING
state | STRING
keywordText | STRING
matchType | STRING
​
####SponsoredProducts_CampaignNegativeKeywordEx
Purpose: Return a list of campaign level negative keywords with additional properties.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Campaign Negative Keyword Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/campaign-negative-keywords)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
keywordId | STRING
campaignId | STRING
state | STRING
keywordText | STRING
matchType | STRING
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
​
####SponsoredProducts_ProductAd
Purpose: Return a list of product ads.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Product Ads](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/product-ads)
​
Replication: Full Replication
 
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
adId | STRING
campaignId | STRING
adGroupId | STRING
sku | STRING
state | STRING
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
​
####SponsoredProducts_ProductAdEx
Purpose: Return a list of product ads with additional properties.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Product Ads Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/product-ads)
​
Replication: Full Replication
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
adId | STRING
campaignId | STRING
adGroupId | STRING
sku | STRING
asin | STRING
state | STRING
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
​
####SponsoredProducts_TargetingClause
Purpose: List targeting expressions.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Product Targeting](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/product-attribute-targeting)
​
Replication: Full Load
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
targetId | STRING
campaignId | STRING
adGroupId | STRING
state | STRING
resolvedExpression | RECORD
expression | RECORD
expressionType | STRING
bid | NUMERIC
​
####SponsoredProducts_TargetingClauseEx
Purpose: List targeting expressions with additional properties.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Product Targeting Extended](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/product-attribute-targeting)
​
Replication: Full Load
​
Replication Key: N/A
​
#####Fields
Name | Target Datatype
:---:|:---:
profileId | STRING
targetId | STRING
campaignId | STRING
adGroupId | STRING
state | STRING
expression | RECORD
expressionType | STRING
bid | NUMERIC
creationDate | STRING
lastUpdatedDate | STRING
servingStatus | STRING
​
####SponsoredProducts_CampaignsReports
Purpose: Retrieves campaigns performance report.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/reports)
​
Replication: Key Based Replication
​
Replication Key: Date
​
#####Fields
Name | Target Datatype
:---:|:---:
date | STRING
bidPlus | NUMERIC
campaignName | STRING
campaignId | STRING
campaignStatus | BOOLEAN
campaignBudget | NUMERIC
impressions | INTEGER
clicks | INTEGER
cost | NUMERIC
attributedConversions1d | INTEGER
attributedConversions7d | INTEGER
attributedConversions14d | INTEGER
attributedConversions30d | INTEGER
attributedConversions1dSameSKU | INTEGER
attributedConversions7dSameSKU | INTEGER
attributedConversions14dSameSKU | INTEGER
attributedConversions30dSameSKU | INTEGER
attributedUnitsOrdered1d | INTEGER
attributedUnitsOrdered7d | INTEGER
attributedUnitsOrdered14d | INTEGER
attributedUnitsOrdered30d | INTEGER
attributedSales1d | INTEGER
attributedSales7d | INTEGER
attributedSales14d | INTEGER
attributedSales30d | INTEGER
attributedSales1dSameSKU | INTEGER
attributedSales7dSameSKU | INTEGER
attributedSales14dSameSKU | INTEGER
attributedSales30dSameSKU | INTEGER
attributedUnitsOrdered1dSameSKU | INTEGER
attributedUnitsOrdered7dSameSKU | INTEGER
attributedUnitsOrdered14dSameSKU | INTEGER
attributedUnitsOrdered30dSameSKU | INTEGER
​
####SponsoredProducts_CampaignsReports_Placement
Purpose: Retrieves campaigns performance report with 'placement' segmentation'.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/reports)
​
Replication: Key Based Replication
​
Replication Key: Date
​
#####Fields
Name | Target Datatype
:---:|:---:
date | STRING
placement | STRING
bidPlus | NUMERIC
campaignName | STRING
campaignId | STRING
campaignStatus | STRING
campaignBudget | NUMERIC
impressions | INTEGER
clicks | INTEGER
cost | NUMERIC
attributedConversions1d | INTEGER
attributedConversions7d | INTEGER
attributedConversions14d | INTEGER
attributedConversions30d | INTEGER
attributedConversions1dSameSKU | INTEGER
attributedConversions7dSameSKU | INTEGER
attributedConversions14dSameSKU | INTEGER
attributedConversions30dSameSKU | INTEGER
attributedUnitsOrdered1d | INTEGER
attributedUnitsOrdered7d | INTEGER
attributedUnitsOrdered14d | INTEGER
attributedUnitsOrdered30d | INTEGER
attributedSales1d | INTEGER
attributedSales7d | INTEGER
attributedSales14d | INTEGER
attributedSales30d | INTEGER
attributedSales1dSameSKU | INTEGER
attributedSales7dSameSKU | INTEGER
attributedSales14dSameSKU | INTEGER
attributedSales30dSameSKU | INTEGER
attributedUnitsOrdered1dSameSKU | INTEGER
attributedUnitsOrdered7dSameSKU | INTEGER
attributedUnitsOrdered14dSameSKU | INTEGER
attributedUnitsOrdered30dSameSKU | INTEGER
​
####SponsoredProducts_AdGroupReports
Purpose: Retrieves ad-group performance report.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/reports)
​
Replication: Key Based Replication
​
Replication Key: Date
​
#####Fields
Name | Target Datatype
:---:|:---:
date | STRING
campaignName | STRING
campaignId | STRING
adGroupName | STRING
adGroupId | STRING
impressions | INTEGER
clicks | INTEGER
cost | NUMERIC
currency | STRING
attributedConversions1d | INTEGER
attributedConversions7d | INTEGER
attributedConversions14d | INTEGER
attributedConversions30d | INTEGER
attributedConversions1dSameSKU | INTEGER
attributedConversions7dSameSKU | INTEGER
attributedConversions14dSameSKU | INTEGER
attributedConversions30dSameSKU | INTEGER
attributedUnitsOrdered1d | INTEGER
attributedUnitsOrdered7d | INTEGER
attributedUnitsOrdered14d | INTEGER
attributedUnitsOrdered30d | INTEGER
attributedSales1d | INTEGER
attributedSales7d | INTEGER
attributedSales14d | INTEGER
attributedSales30d | INTEGER
attributedSales1dSameSKU | INTEGER
attributedSales7dSameSKU | INTEGER
attributedSales14dSameSKU | INTEGER
attributedSales30dSameSKU | INTEGER
attributedUnitsOrdered1dSameSKU | INTEGER
attributedUnitsOrdered7dSameSKU | INTEGER
attributedUnitsOrdered14dSameSKU | INTEGER
attributedUnitsOrdered30dSameSKU | INTEGER
​
####SponsoredProducts_KeywordReports
Purpose: Retrieves keyword performance report.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/reports)
​
Replication: Key Based Replication
​
Replication Key: Date
​
#####Fields
Name | Target Datatype
:---:|:---:
date | STRING
campaignName | STRING
campaignId | STRING
adGroupName | STRING
adGroupId | STRING
keywordId | STRING
keywordText | STRING
matchType | STRING
impressions | INTEGER
clicks | INTEGER
cost | NUMERIC
attributedConversions1d | INTEGER
attributedConversions7d | INTEGER
attributedConversions14d | INTEGER
attributedConversions30d | INTEGER
attributedConversions1dSameSKU | INTEGER
attributedConversions7dSameSKU | INTEGER
attributedConversions14dSameSKU | INTEGER
attributedConversions30dSameSKU | INTEGER
attributedUnitsOrdered1d | INTEGER
attributedUnitsOrdered7d | INTEGER
attributedUnitsOrdered14d | INTEGER
attributedUnitsOrdered30d | INTEGER
attributedSales1d | INTEGER
attributedSales7d | INTEGER
attributedSales14d | INTEGER
attributedSales30d | INTEGER
attributedSales1dSameSKU | INTEGER
attributedSales7dSameSKU | INTEGER
attributedSales14dSameSKU | INTEGER
attributedSales30dSameSKU | INTEGER
attributedUnitsOrdered1dSameSKU | INTEGER
attributedUnitsOrdered7dSameSKU | INTEGER
attributedUnitsOrdered14dSameSKU | INTEGER
attributedUnitsOrdered30dSameSKU | INTEGER
​
####SponsoredProducts_KeywordReports_SearchTerm
Purpose: Retrieves keyword performance report with 'query' segmentation.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/reports)
​
Replication: Key Based Replication
​
Replication Key: Date
​
#####Fields
Name | Target Datatype
:---:|:---:
date | STRING
query | STRING
campaignName | STRING
campaignId | STRING
adGroupName | STRING
adGroupId | STRING
keywordId | STRING
keywordText | STRING
matchType | STRING
impressions | INTEGER
clicks | INTEGER
cost | NUMERIC
attributedConversions1d | INTEGER
attributedConversions7d | INTEGER
attributedConversions14d | INTEGER
attributedConversions30d | INTEGER
attributedConversions1dSameSKU | INTEGER
attributedConversions7dSameSKU | INTEGER
attributedConversions14dSameSKU | INTEGER
attributedConversions30dSameSKU | INTEGER
attributedUnitsOrdered1d | INTEGER
attributedUnitsOrdered7d | INTEGER
attributedUnitsOrdered14d | INTEGER
attributedUnitsOrdered30d | INTEGER
attributedSales1d | INTEGER
attributedSales7d | INTEGER
attributedSales14d | INTEGER
attributedSales30d | INTEGER
attributedSales1dSameSKU | INTEGER
attributedSales7dSameSKU | INTEGER
attributedSales14dSameSKU | INTEGER
attributedSales30dSameSKU | INTEGER
attributedUnitsOrdered1dSameSKU | INTEGER
attributedUnitsOrdered7dSameSKU | INTEGER
attributedUnitsOrdered14dSameSKU | INTEGER
attributedUnitsOrdered30dSameSKU | INTEGER
​
####SponsoredProducts_ProductAdsReports
Purpose: Retrieves product-ads performance report.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/reports)
​
Replication: Key Based Replication
​
Replication Key: Date
​
#####Fields
Name | Target Datatype
:---:|:---:
date | STRING
campaignName | STRING
campaignId | STRING
adGroupName | STRING
adGroupId | STRING
impressions | INTEGER
clicks | INTEGER
cost | NUMERIC
currency | STRING
asin | STRING
attributedConversions1d | INTEGER
attributedConversions7d | INTEGER
attributedConversions14d | INTEGER
attributedConversions30d | INTEGER
attributedConversions1dSameSKU | INTEGER
attributedConversions7dSameSKU | INTEGER
attributedConversions14dSameSKU | INTEGER
attributedConversions30dSameSKU | INTEGER
attributedUnitsOrdered1d | INTEGER
attributedUnitsOrdered7d | INTEGER
attributedUnitsOrdered14d | INTEGER
attributedUnitsOrdered30d | INTEGER
attributedSales1d | INTEGER
attributedSales7d | INTEGER
attributedSales14d | INTEGER
attributedSales30d | INTEGER
attributedSales1dSameSKU | INTEGER
attributedSales7dSameSKU | INTEGER
attributedSales14dSameSKU | INTEGER
attributedSales30dSameSKU | INTEGER
attributedUnitsOrdered1dSameSKU | INTEGER
attributedUnitsOrdered7dSameSKU | INTEGER
attributedUnitsOrdered14dSameSKU | INTEGER
attributedUnitsOrdered30dSameSKU | INTEGER
​
####SponsoredProducts_ProductTargetingReports
Purpose: Retrieves targets performance report.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/reports)
​
Replication: Key Based Replication
​
Replication Key: Date
​
#####Fields
Name | Target Datatype
:---:|:---:
date | STRING
campaignName | STRING
campaignId | STRING
adGroupName | STRING
adGroupId | STRING
targetId | STRING
targetingExpression | STRING
targetingText | STRING
targetingType | STRING
impressions | INTEGER
clicks | INTEGER
cost | NUMERIC
attributedConversions1d | INTEGER
attributedConversions7d | INTEGER
attributedConversions14d | INTEGER
attributedConversions30d | INTEGER
attributedConversions1dSameSKU | INTEGER
attributedConversions7dSameSKU | INTEGER
attributedConversions14dSameSKU | INTEGER
attributedConversions30dSameSKU | INTEGER
attributedUnitsOrdered1d | INTEGER
attributedUnitsOrdered7d | INTEGER
attributedUnitsOrdered14d | INTEGER
attributedUnitsOrdered30d | INTEGER
attributedSales1d | INTEGER
attributedSales7d | INTEGER
attributedSales14d | INTEGER
attributedSales30d | INTEGER
attributedSales1dSameSKU | INTEGER
attributedSales7dSameSKU | INTEGER
attributedSales14dSameSKU | INTEGER
attributedSales30dSameSKU | INTEGER
attributedUnitsOrdered1dSameSKU | INTEGER
attributedUnitsOrdered7dSameSKU | INTEGER
attributedUnitsOrdered14dSameSKU | INTEGER
attributedUnitsOrdered30dSameSKU | INTEGER
​
####SponsoredProducts_ProductTargetingReports_SearchTerm
Purpose: Retrieves targets performance report with 'query' segmentation.
​
Source API Documentation: <Link> [Amazon Ads Sponsored Product - Reports](https://advertising.amazon.com/API/docs/en-us/reference/sponsored-products/2/reports)
​
Replication: Key Based Replication
​
Replication Key: Date
​
#####Fields
Name | Target Datatype
:---:|:---:
date | STRING
query | STRING
campaignName | STRING
campaignId | STRING
adGroupName | STRING
adGroupId | STRING
targetId | STRING
targetingExpression | STRING
targetingText | STRING
targetingType | STRING
impressions | INTEGER
clicks | INTEGER
cost | NUMERIC
attributedConversions1d | INTEGER
attributedConversions7d | INTEGER
attributedConversions14d | INTEGER
attributedConversions30d | INTEGER
attributedConversions1dSameSKU | INTEGER
attributedConversions7dSameSKU | INTEGER
attributedConversions14dSameSKU | INTEGER
attributedConversions30dSameSKU | INTEGER
attributedUnitsOrdered1d | INTEGER
attributedUnitsOrdered7d | INTEGER
attributedUnitsOrdered14d | INTEGER
attributedUnitsOrdered30d | INTEGER
attributedSales1d | INTEGER
attributedSales7d | INTEGER
attributedSales14d | INTEGER
attributedSales30d | INTEGER
attributedSales1dSameSKU | INTEGER
attributedSales7dSameSKU | INTEGER
attributedSales14dSameSKU | INTEGER
attributedSales30dSameSKU | INTEGER
attributedUnitsOrdered1dSameSKU | INTEGER
attributedUnitsOrdered7dSameSKU | INTEGER
attributedUnitsOrdered14dSameSKU | INTEGER
attributedUnitsOrdered30dSameSKU | INTEGER