Creatives
The Ad Creatives search finder allows you to search for creatives by id, campaign URN, status, or reference URN.
Table Specific Information
Select
The Creatives view returns a list of the creatives that belong to the authenticated user so they can be used as dimensions in analytic requests.
The adapter uses the LinkedInAds API to process search criteria that refer to the Id, Account, Campaign, and IntendedStatus columns. The adapter processes other filters client-side within the adapter. For example, the following queries are processed server side.
SELECT * FROM Creatives
SELECT * FROM Creatives WHERE Id='179345687'
SELECT * FROM Creatives WHERE Account='510013292'
SELECT * FROM Creatives WHERE Account IN ('510013292', '510013293')
SELECT * FROM Creatives WHERE Campaign='198952936'
SELECT * FROM Creatives WHERE IntendedStatus='ACTIVE'
Columns
| Name | Type | Description |
| Id | String | Numerical identifier for the creative. |
| Account | String | URN identifying the advertising account associated with the creative. |
| Campaign | String | URN identifying the campaign associated with the creative. |
| Content | String | Content sponsored in the creative. |
| CreatedAt | Datetime | Datetime when the creative was first created |
| CreatedBy | String | Entity that developed the creative. |
| IntendedStatus | String | Creative user intended status. |
| IsServing | Boolean | This indicates whether the creative is currently being served or not. |
| ServingHoldReasons | String | Array that contains all the reasons why the creative is not serving. |
| LastModifiedAt | Datetime | Datetime when the creative was last modified. |
| LastModifiedBy | String | Entity that modified the creative. |
| ReviewStatus | String | The current review status of the creative. |
| IsTest | Boolean | Flag showing whether this creative is a test creative, i.e., belongs to a test campaign. |