# Pinterest Ads: Url Report ## Description * Each record in this table represents the daily performance of ads at the advertiser, campaign, ad group, and url level. ## Supported Data Sources * 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\_status | Status of the campaign. | | | ad\_group\_status | Status of the ad group. | | | destination\_url | Pin destination URL. | | | pin\_promotion\_id | The ID of the related Pin promotion. | | | pin\_name | Pin promotion name. | | | pin\_status | The status of the Pin promotion. One of "ACTIVE", "ARCHIVED", "PAUSED" | | | 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". | | | base\_url | The base URL of the ad, extracted from the `destination_url`. | | | url\_host | The URL host of the ad, extracted from the `destination_url`. | | | url\_path | The URL path of the ad, extracted from the `destination_url`. | | | utm\_source | The utm\_source parameter of the ad, extracted from the `destination_url`. | | | utm\_medium | The utm\_medium parameter of the ad, extracted from the `destination_url`. | | | utm\_campaign | The utm\_campaign parameter of the ad, extracted from the `destination_url`. | | | utm\_content | The utm\_content parameter of the ad, extracted from the `destination_url`. | | | utm\_term | The utm\_term parameter of the ad, extracted from the `destination_url`. | | | campaign\_id | The ID of the related Campaign. | | | campaign\_name | The name of the related Campaign. | | | ad\_group\_id | The ID of the related Ad group. | | | ad\_group\_name | The name of the related Ad group. | | | impressions | The number of paid and earned impressions that occurred on the day of the record. | | | clicks | The number of paid and earned clicks 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-url-report.md?ask= ``` 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.