Read data on message creatives in your LinkedIn ad-account.

Table Specific Information

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

Select

For the URN 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 MessageCreatives WHERE URN = 'urn:li:adInMailContent:147611443';
SELECT * FROM MessageCreatives WHERE URN IN ('urn:li:adInMailContent:147611443', 'urn:li:adInMailContent:147551513', 'urn:li:adInMailContent:147581293');

The rest of the query is processed client-side.

Insert

To create a new message creative, use an INSERT statement.

The following columns are required for this operation:

• Name
• Subject
• BodyContent
• SubContent
• SenderURN
• AccountURN

INSERT INTO MessageCreatives (Name, Subject, BodyContent, FooterContent, SubContent, SenderURN, AccountURN) VALUES ('Message Ad 1', 'This is Message Ad 1', 'Message advertisement.', 'Terms and Conditions for Message Ad 1', '{"regular":{"rightRailAdPicture":"urn:li:image:D4D10AQGyoJMKvxNVFA","callToActionLandingPageUrl":"https://test.com","callToActionText":"Learn More"}}', 'urn:li:person:5a_yNKOQQe', 'urn:li:sponsoredAccount:512859024')

Update

To modify an existing message creative, use an UPDATE statement. Note that the URN column is required in the WHERE clause.

The following columns are the ones that are mutable after creation:

• Name
• Subject
• BodyContent
• FooterContent
• SubContent
• SenderURN

UPDATE MessageCreatives SET SenderURN = 'urn:li:person:0P8ph3huTC', Subject = 'My Message Ad 1', BodyContent = 'My Message Ad 1 body content.', SubContent = '{"regular":{"callToActionLandingPageUrl":"https://cloud.google.com/apigee?hl=en","callToActionText":"Learn More Here"}}', Name = 'My Message Ad 1', FooterContent = 'My Message Ad 1 footer content.' WHERE URN = 'urn:li:adInMailContent:148081693'

Columns

Name	Type	ReadOnly	References	Description
URN [KEY]	String	True		The URN of the message creative.
Name	String	False		The name of the message creative.
Subject	String	False		The subject of the message creative.
BodyContent	String	False		The HTML content of the message creative.
FooterContent	String	False		The terms and conditions of the message creative, located at the bottom of the message.
SubContent	String	False		The sub-content of the message creative. This can vary depending on the advertiser's goal. Represented in JSON format.
SenderURN	String	False		The URN of the LinkedIn user which will be used to send the message creative to the targeted audience.
AccountURN	String	False		The URN of the ad-account to which this message creative belongs.
CreatedAt	Datetime	True		The time when the message creative was created.
UpdatedAt	Datetime	True		The time when the message creative was last modified.