# Amazon Ads: Portfolio Report

## Description

* Each record in this table represents the daily performance at the portfolio 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.                                                                                                                                                                                                                              |
| INTEGER | budget\_amount         | The budget amount associated with the portfolio. Cannot be null.                                                                                                                                                                                      |
| INTEGER | budget\_currency\_code | The currency used for all monetary values for entities under this profile. Cannot be null.                                                                                                                                                            |
| INTEGER | budget\_start\_date    | The starting date in YYYYMMDD format to which the budget is applied. Required if policy is set to dateRange. Not specified if policy is set to monthlyRecurring. Note that the starting date for monthlyRecurring is the date when the policy is set. |
| INTEGER | budget\_end\_date      | The end date after which the budget is no longer applied. Optional if policy is set to dateRange or monthlyRecurring.                                                                                                                                 |
| INTEGER | budget\_policy         | The budget policy. Set to dateRange to specify a budget for a specific period of time. Set to monthlyRecurring to specify a budget that is automatically renewed at the beginning of each month. Cannot be null.                                      |
| BOOLEAN | in\_budget             | Indicates the current budget status of the portfolio. Set to true if the portfolio is in budget, set to false if the portfolio is out of budget.                                                                                                      |
| STRING  | serving\_status        | The current serving status of the record.                                                                                                                                                                                                             |
| STRING  | state                  | The state of the record (enabled, paused, or archived).                                                                                                                                                                                               |
| 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-portfolio-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.