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 connector uses the LinkedIn Marketing Solutions API to process search criteria that refer to the Id and AccountURN columns. The connector processes other filters client-side within the connector. 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