# Amazon Ads: Ad Report

## Description

* Each record in this table represents the daily performance at the ad 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  | ad\_group\_name                  | The name of the Campaign.                                                                                                                                                                                                  |
| STRING  | ad\_group\_id                    | The ID of the AdGroup.                                                                                                                                                                                                     |
| STRING  | ad\_id                           | The ID of the Ad.                                                                                                                                                                                                          |
| STRING  | serving\_status                  | The current serving status of the record.                                                                                                                                                                                  |
| STRING  | state                            | The state of the record (enabled, paused, or archived).                                                                                                                                                                    |
| INTEGER | advertised\_asin                 | The ASIN associated to an advertised product.                                                                                                                                                                              |
| INTEGER | advertised\_sku                  | The SKU being advertised.                                                                                                                                                                                                  |
| 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.                                                                                                                                                                                            |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/amazon-ads-ad-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.