# Twitter Ads: Url Report

## Description

* Each record in this table represents the daily performance of ads at the account, campaign, line item (ad group), promoted tweet, and url level, within a placement in Twitter.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/twitter/resources/twitter_ads.svg" alt="" data-size="line"> Twitter Ads

## 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 date of the performance.                                                                                                                                                                                                                      |
| STRING   | placement           | Where on Twitter the ad is being displayed. Possible values include 'ALL\_ON\_TWITTER', 'PUBLISHER\_NETWORK', 'TWITTER\_PROFILE', 'TWITTER\_SEARCH', 'TWITTER\_TIMELINE', and 'TAP\_\*', which are more granular options for `PUBLISHER_NETWORK`. |
| STRING   | account\_id         | The ID of the related account.                                                                                                                                                                                                                    |
| STRING   | account\_name       | The name of the related account.                                                                                                                                                                                                                  |
| STRING   | campaign\_id        | The ID of the related campaign.                                                                                                                                                                                                                   |
| STRING   | campaign\_name      | The name of the related campaign.                                                                                                                                                                                                                 |
| STRING   | line\_item\_id      | The ID of the related line item (ad group).                                                                                                                                                                                                       |
| STRING   | line\_item\_name    | The ID of the related line item.                                                                                                                                                                                                                  |
| STRING   | promoted\_tweet\_id | The ID of the promoted tweet that the URL appeared in.                                                                                                                                                                                            |
| INTEGER  | tweet\_id           | The ID of the tweet that the URL appeared in.                                                                                                                                                                                                     |
| INTEGER  | tweet\_name         | The name, if provided, of the tweet that the URL appeared in.                                                                                                                                                                                     |
| STRING   | tweet\_full\_text   | The full text of the tweet that the URL appeared in.                                                                                                                                                                                              |
| STRING   | base\_url           | The base URL of the ad, extracted from the `expanded_url`.                                                                                                                                                                                        |
| STRING   | url\_host           | The URL host of the ad, extracted from the `expanded_url`.                                                                                                                                                                                        |
| STRING   | url\_path           | The URL path of the ad, extracted from the `expanded_url`.                                                                                                                                                                                        |
| STRING   | utm\_source         | The utm\_source parameter of the ad, extracted from the `expanded_url`.                                                                                                                                                                           |
| STRING   | utm\_medium         | The utm\_medium parameter of the ad, extracted from the `expanded_url`.                                                                                                                                                                           |
| STRING   | utm\_campaign       | The utm\_campaign parameter of the ad, extracted from the `expanded_url`.                                                                                                                                                                         |
| STRING   | utm\_content        | The utm\_content parameter of the ad, extracted from the `expanded_url`.                                                                                                                                                                          |
| STRING   | utm\_term           | The utm\_term parameter of the ad, extracted from the `expanded_url`.                                                                                                                                                                             |
| STRING   | expanded\_url       | The fully expanded URL.                                                                                                                                                                                                                           |
| STRING   | display\_url        | The URL as it will be displayed.                                                                                                                                                                                                                  |
| STRING   | currency            | The currency all metrics for the account are set to.                                                                                                                                                                                              |
| INTEGER  | clicks              | The clicks for the promoted tweet + URL on that day. Includes clicks on the URL (shortened or regular links), profile pic, screen name, username, detail, hashtags, and likes.                                                                    |
| INTEGER  | impressions         | The impressions for the promoted tweet + URL on that day. This is the number of users who see a Promoted Ad either in their home timeline or search results.                                                                                      |
| INTEGER  | spend               | The spend for the promoted tweet + URL on that day.                                                                                                                                                                                               |
| INTEGER  | spend\_micro        | The spend, in micros, for the tweet + URL on that day.                                                                                                                                                                                            |
| INTEGER  | url\_clicks         | The URL clicks for the promoted tweet + URL on that day.                                                                                                                                                                                          |


---

# 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/twitter-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.