# Amazon Ads: Campaign Report

## Description

* Each record in this table represents the daily performance at the campaign level.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/amazon_ads/resources/amazon-ads-logo.svg" alt="" data-size="line"> Amazon Ads

## Columns

| Type    | Name                             | Description                                                                                                                                                                                                                |
| ------- | -------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| DATE    | date\_day                        | The date of the report.                                                                                                                                                                                                    |
| STRING  | account\_name                    | Account Name. Not currently populated for sellers.                                                                                                                                                                         |
| STRING  | account\_id                      | Identifier for sellers and vendors. Note that this value is not unique and may be the same across marketplaces.                                                                                                            |
| STRING  | country\_code                    | The code for a given country.                                                                                                                                                                                              |
| STRING  | profile\_id                      | The profile ID associated with your Amazon Ads account. Advertisers who operate in more than one marketplace (for example, Amazon.com, Amazon.co.uk, Amazon.co.jp) will have one profile associated with each marketplace. |
| STRING  | portfolio\_name                  | The name of the Portfolio.                                                                                                                                                                                                 |
| STRING  | portfolio\_id                    | The ID of the Portfolio.                                                                                                                                                                                                   |
| STRING  | campaign\_name                   | The name of the Campaign.                                                                                                                                                                                                  |
| STRING  | campaign\_id                     | The ID of the Campaign.                                                                                                                                                                                                    |
| STRING  | campaign\_bidding\_strategy      | The bidding strategy associated with a campaign.                                                                                                                                                                           |
| DECIMAL | campaign\_budget\_amount         | Total budget allocated to the campaign.                                                                                                                                                                                    |
| STRING  | campaign\_budget\_currency\_code | The currency code associated with the campaign.                                                                                                                                                                            |
| STRING  | campaign\_budget\_type           | One of: daily or lifetime.                                                                                                                                                                                                 |
| DECIMAL | cost                             | Total cost of ad clicks.                                                                                                                                                                                                   |
| INTEGER | clicks                           | Total number of ad clicks.                                                                                                                                                                                                 |
| INTEGER | impressions                      | Total number of ad impressions.                                                                                                                                                                                            |
