Retrieve and manage LinkedIn Data Management Platform (DMP) segments for B2B audience targeting and custom audience creation across ad exchanges.

Table Specific Information

Select

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

SELECT * FROM DMPSegments WHERE Id = '43318048';

SELECT * FROM DMPSegments WHERE AccountURN = 'urn:li:sponsoredAccount:518270328';

CUD Operations

Insert

To insert a new DMP segment, specify the Name, SourcePlatform, AccountURN, Type, and Destinations columns.

INSERT INTO DMPSegments (Name, SourcePlatform, AccountURN, Type, Destinations) 
VALUES ('DMP Segment Name', 'VIDEO_ADS', 'urn:li:sponsoredAccount:518270328', 'USER', '[
      {
         "destination":"LINKEDIN"
      }
   ]');

Update

To modify an existing DMP segment, use an UPDATE statement. Note that the Id column is required in the WHERE clause.

The following columns can be updated: Name, Description, and SourceSegmentId.

UPDATE DMPSegments SET Name = 'DMPSegment Update', Description = 'Desc', SourceSegmentId = '159753' WHERE Id = '43318048';

Delete

To remove a DMP segment, use a DELETE statement. Note that the Id column is required in the WHERE clause.

DELETE FROM DMPSegments WHERE Id = 43333010;

Columns