Retrieves ad creative details, including identifiers, campaign references, and statuses, to support creative management and optimization.

Table-Specific Information

Select

The Creatives table returns creatives associated with the authenticated user. You can use these creatives as dimensions in analytic requests.

The add-in uses the LinkedIn Marketing Solutions API to process search criteria that refer to the Id, AdAccountId, Campaign, and IntendedStatus columns. The add-in processes other filters client-side within the add-in. For example, the following queries are processed server-side.

SELECT * FROM Creatives WHERE Id = '179345687'

SELECT * FROM Creatives WHERE AdAccountId = '510013292'

SELECT * FROM Creatives WHERE AdAccountId IN ('510013292', '510013293')

SELECT * FROM Creatives WHERE Campaign = '198952936'

SELECT * FROM Creatives WHERE IntendedStatus = 'ACTIVE'

Insert

To create a new advertising creative, there are some fields that are required in initial creation which are: Campaign, Content, IntendedStatus, and AdAccountId.

    INSERT INTO Creatives (Campaign, Content, IntendedStatus, Name, AdAccountId) VALUES ('urn:li:sponsoredCampaign:403027733', ' { \"reference\": \"urn:li:share:7346473724906237952\" }', 'DRAFT', 'Summer Campaign Main Creative', '515218099');

Update

To modify an existing creative, use an UPDATE statement.

Note: The Id and AdAccountId columns are required in the WHERE clause.

The following columns are the ones that are mutable after creation: Content, IntendedStatus, CallToActionLabel, CallToActionFormId, Name.

    UPDATE Creatives SET Campaign = 'urn:li:sponsoredCampaign:403027733', Name = 'Updated Summer Campaign Creative' WHERE Id = 'urn:li:sponsoredCreative:722532663' and AdAccountId = '515218099';

Delete

To remove a creative, use a DELETE statement.

Note: The Id and AdAccountId columns are required in the WHERE clause.

    DELETE FROM Creatives WHERE Id = 'urn:li:sponsoredCreative:722492693' and AdAccountId = '515218099';

Columns