# Linkedin Ads: Url Report

## Description

* Each record in this table represents the daily performance of ads at the url level.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/linkedin/resources/linkedin_ads.svg" alt="" data-size="line"> LinkedIn Ad Analytics

## Columns

| Type     | Name                  | Description                                                                                                                                                       |
| -------- | --------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING   | source\_relation      | The source of the record if the unioning functionality is being used. If not this field will be empty.                                                            |
| DATETIME | date\_day             | The day of the activity.                                                                                                                                          |
| STRING   | click\_uri            | Required when creative type is TEXT\_AD. Maximum character limit of 500 after URL encoding all special characters. Limit does not include the "https\://" prefix. |
| STRING   | base\_url             | The base URL of the ad, extracted from the `click_uri`.                                                                                                           |
| STRING   | url\_host             | The URL host of the ad, extracted from the `click_uri`.                                                                                                           |
| STRING   | url\_path             | The URL path of the ad, extracted from the `click_uri`.                                                                                                           |
| STRING   | utm\_source           | The utm\_source parameter of the ad, extracted from the `click_uri`.                                                                                              |
| STRING   | utm\_medium           | The utm\_medium parameter of the ad, extracted from the `click_uri`.                                                                                              |
| STRING   | utm\_campaign         | The utm\_campaign parameter of the ad, extracted from the `click_uri`.                                                                                            |
| STRING   | utm\_content          | The utm\_content parameter of the ad, extracted from the `click_uri`.                                                                                             |
| STRING   | utm\_term             | The utm\_term parameter of the ad, extracted from the `click_uri`.                                                                                                |
| INTEGER  | creative\_id          | Unique internal ID representing the creative.                                                                                                                     |
| INTEGER  | campaign\_id          | Unique internal ID representing the creative's campaign.                                                                                                          |
| STRING   | campaign\_name        | A label for the creative's campaign.                                                                                                                              |
| INTEGER  | campaign\_group\_id   | Unique internal ID representing the campaign group.                                                                                                               |
| STRING   | campaign\_group\_name | A label for the campaign group.                                                                                                                                   |
| INTEGER  | account\_id           | Unique internal ID representing the account.                                                                                                                      |
| STRING   | account\_name         | A label for the account.                                                                                                                                          |
| STRING   | currency              | The ISO 4217 currency code of the account, such as 'USD' for United States Dollar (default).                                                                      |
| INTEGER  | clicks                | The count of chargeable clicks.                                                                                                                                   |
| INTEGER  | impressions           | This is the count of "impressions" for Direct Ads and Sponsored Updates and "sends" for InMails.                                                                  |
| INTEGER  | cost                  | The cost of the ads in the local currency or USD.                                                                                                                 |


---

# 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/linkedin-ads-url-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.