JDBC Driver for LinkedIn Marketing Solutions

Build 22.0.8462

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

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'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462