# Linkedin Ads: Creative Report

## Description

* Each record in this table represents the daily performance of ads at the creative 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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| 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   | 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   | creative\_status        | ACTIVE - Creative creation is complete and creative is available for review and serve.PAUSED - Creative creation is complete and creative is current, but should temporarily not be served. This status is not valid upon creation.DRAFT - Creative creation is incomplete and may still be edited.ARCHIVED - Creative creation is complete, but creative should not be served and should be separated from non-archived creatives in any UI.CANCELED - Creative is permanently canceled.                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| STRING   | campaign\_status        | ACTIVE - Denotes that the campaign is fully servable.PAUSED - Denotes that the campaign meets all requirements to be served, but temporarily should not be.ARCHIVED - Denotes that the campaign is presently inactive, and should mostly be hidden in the UI until un-archived.COMPLETED - Denotes that the campaign has reached a specified budgetary or chronological limit.CANCELED - Denotes that the campaign has been permanently canceled, such as when an advertising account is permanently closed.DRAFT - Denotes that the campaign is still being edited and not eligible for serving. Some validation will be postponed until the campaign is activated.PENDING\_DELETION - Denotes that the campaign has been requested to be deleted that is currently pending.REMOVED - Denotes that the campaign was deleted, but must remain fetchable due to the existence of performance data.                                                                    |
| STRING   | campaign\_group\_status | Status of campaign's campaign group. Possible values are: ACTIVE - Denotes that the campaign group is capable of serving ads, subject to run date and budget limitations (as well as any other limitations at the account or campaign level). ARCHIVED - Denotes that the campaign group is presently inactive, and should mostly be hidden in the UI until un-archived. CANCELLED - Denotes that the campaign group has been permanently canceled and cannot be reactivated. Not a settable status. DRAFT - Denotes that the campaign group is in a preliminary state and should temporarily not be served. PAUSED - Denotes that the campaign group meets all requirements to be served, but temporarily should not be. PENDING\_DELETION - Denotes that the campaign group has been requested to be deleted that is currently pending. REMOVED - Denoted that the campaign group was deleted, but must remain fetchable due to the existence of performance data. |
| STRING   | currency                | The ISO 4217 currency code of the account, such as 'USD' for United States Dollar (default).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| DATETIME | last\_modified\_at      | The timestamp of when the version was updated.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| DATETIME | created\_at             | The timestamp of when the creative was created.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 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-creative-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.
