Provides data on user interactions with conversation ad creatives, including clicks and message-level engagement metrics.

Table Specific Information

The ConversationCreativeURN column is required and must be specified in the criteria to query data from this table.

Select

For the ConversationCreativeURN column, the = operator is fully supported server-side. The IN operator is partially supported server-side and partially client-side. Refer to the query examples below:

SELECT * FROM ConversationCreativeActions WHERE ConversationCreativeURN = 'urn:li:sponsoredConversation:7069897';
SELECT * FROM ConversationCreativeActions WHERE ConversationCreativeURN IN ('urn:li:sponsoredConversation:7069897', 'urn:li:sponsoredConversation:5833860');

The rest of the query is processed client-side.

Insert

To insert a new conversation creative action, specify the ConversationCreativeURN along with the BodyContent and NextActions columns.

INSERT INTO ConversationCreativeActions (ConversationCreativeURN, BodyContent, NextActions) 
VALUES ('urn:li:sponsoredConversation:7932433', '{
     "text": "test conversation message"
  }', '{
    "options":[
      {
        "replyType": "SIMPLE_REPLY",
        "optionText": "Simple reply"
      }
    ]
  }');

Update

To modify an existing conversation creative action, use an UPDATE statement. Note that both the ConversationCreativeURN and URN columns are required in the WHERE clause.

UPDATE ConversationCreativeActions SET BodyContent = '{
   "text": "Updated text"
  }' 
WHERE ConversationCreativeURN = 'urn:li:sponsoredConversation:8584906' AND URN = 'urn:li:sponsoredMessageContent:(urn:li:sponsoredConversation:8584906,12219786)';

Columns

Name	Type	ReadOnly	References	Description
URN [KEY]	String	True		Uniform Resource Name (URN) that uniquely identifies the conversation creative action.
ConversationCreativeURN	String	False	ConversationCreatives.URN	URN that identifies the conversation creative associated with this action.
BodyContent	String	False		Contains the message content or body text of the conversation creative action, represented in JSON format.
NextActions	String	False		Specifies the next possible user actions that follow the current interaction, represented in JSON format.