# Pinterest Ads: Pin Promotion Report

## Description

* Each record in this table represents the daily performance of ads at the advertiser, campaign, ad group, and pin level.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/pinterest/resources/pinterest-ads.svg" alt="" data-size="line"> Pinterest Ads

## Columns

| Type | Name               | Description                                                                                                                                                                                                                                            |
| ---- | ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
|      | source\_relation   | The source of the record if the unioning functionality is being used. If not this field will be empty.                                                                                                                                                 |
|      | date\_day          | The performance date of the record.                                                                                                                                                                                                                    |
|      | advertiser\_id     | The ID of the related Advertiser.                                                                                                                                                                                                                      |
|      | advertiser\_name   | Name of the advertiser.                                                                                                                                                                                                                                |
|      | campaign\_id       | The ID of the related Campaign.                                                                                                                                                                                                                        |
|      | campaign\_name     | Name of the campaign.                                                                                                                                                                                                                                  |
|      | campaign\_status   | Status of the campaign.                                                                                                                                                                                                                                |
|      | ad\_group\_id      | The ID of the related Ad group.                                                                                                                                                                                                                        |
|      | ad\_group\_name    | Name of the ad group.                                                                                                                                                                                                                                  |
|      | ad\_group\_status  | Status of the ad group.                                                                                                                                                                                                                                |
|      | creative\_type     | The creative type. One of "APP", "APP\_VIDEO", "BOARD", "CAROUSEL", "CINEMATIC", "COMMERCE", "MAX\_VIDEO", "NATIVE\_VIDEO", "REGULAR", "SEARCH\_PROMINENCE", "SEARCH\_PROMINENCE\_CAROUSEL", "SHOPPING", "SHOP\_THE\_PIN", "THIRD\_PARTY", or "VIDEO". |
|      | pin\_promotion\_id | The ID of the related Pin promotion.                                                                                                                                                                                                                   |
|      | pin\_name          | Name of the pin.                                                                                                                                                                                                                                       |
|      | pin\_status        | Status of the pin.                                                                                                                                                                                                                                     |
|      | destination\_url   | Pin destination URL.                                                                                                                                                                                                                                   |
|      | base\_url          | The base URL of the ad, extracted from the `destination_url`.                                                                                                                                                                                          |
|      | clicks             | The number of paid and earned clicks that occurred on the day of the record.                                                                                                                                                                           |
|      | impressions        | The number of paid and earned impressions that occurred on the day of the record.                                                                                                                                                                      |
|      | spend              | The amount of spend that occurred on the day of the record.                                                                                                                                                                                            |


---

# 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/pinterest-ads-pin-promotion-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.