JDBC Driver for LinkedIn Marketing Solutions

Build 23.0.8839

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 driver uses the LinkedIn Marketing Solutions API to process search criteria that refer to the Id, Account, Campaign, and IntendedStatus columns. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

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.
AdAccountId String Id of the account

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839