Provides details about message ad creatives in your LinkedIn Ads account, including content, delivery, and performance attributes.

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		Uniform Resource Name (URN) that uniquely identifies the message creative.
Name	String	False		Display name of the message creative, used to identify it in the advertiser's account.
Subject	String	False		Subject line of the message creative, displayed to recipients in their LinkedIn inbox.
BodyContent	String	False		Main body of the message creative, formatted in HTML to include text, links, and visual elements.
FooterContent	String	False		Footer section of the message creative containing terms, conditions, or disclaimers displayed at the bottom of the message.
SubContent	String	False		Additional sub-content associated with the message creative, which varies depending on the advertiser's objective. It is represented in JSON format.
SenderURN	String	False		URN that identifies the LinkedIn member profile used as the sender of the message creative.
AccountURN	String	False		URN that identifies the advertising account associated with the message creative.
CreatedAt	Datetime	True		Date and time when the message creative was created.
UpdatedAt	Datetime	True		Date and time when the message creative was last updated.