Accounts

The Account status finder returns all accounts in a specified status that the authenticated user has access to.

Table Specific Information

Select

The Accounts view returns a list of the accounts that belong to the authenticated user so they can be used as dimensions in analytic requests.

The server uses the LinkedIn Marketing Solutions API to process search criteria that refer to the Status column. The server processes other filters client-side within the server. For example, the following queries are processed server side.

SELECT * FROM Accounts WHERE Status = 'ACTIVE'

CUD Operations

Insert

To create a new account, use an INSERT statement. The Type column only accepts 'BUSINESS' value as you cannot create ENTERPRISE accounts through the API.

The following columns are required for insert operations: Name and Type. Currency, NotifiedOnCreativeRejection, NotifiedOnEndOfCampaign, Status, NotifiedOnCampaignOptimization, Reference, NotifiedOnCreativeApproval and IsTest are optional columns.

    INSERT INTO Accounts (Name, Currency, Type, NotifiedOnCreativeRejection, NotifiedOnEndOfCampaign, Status, NotifiedOnCampaignOptimization, Reference, NotifiedOnCreativeApproval, IsTest) VALUES ('Sample Business Account', 'USD', 'BUSINESS', TRUE, TRUE, 'ACTIVE', FALSE, 'urn:li:organization:12345', TRUE, FALSE);

Update

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

The following columns are the ones that are mutable after creation: Name, NotifiedOnCreativeRejection, NotifiedOnEndOfCampaign, Status, NotifiedOnCampaignOptimization, Reference, NotifiedOnCreativeApproval.

    UPDATE Accounts SET Name = 'Updated Account Name',NotifiedOnCreativeRejection = FALSE,NotifiedOnEndOfCampaign = TRUE,Status = 'DRAFT',NotifiedOnCampaignOptimization = TRUE,Reference = 'urn:li:organization:67890',NotifiedOnCreativeApproval = FALSE WHERE Id = 123456;

Delete

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

DELETE FROM Accounts WHERE Id = '123456'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Id of the account
Name	String	False		A label for the account
Currency	String	False		The account's ISO-4217currency code.
Type	String	False		The type of account. The allowed values are BUSINESS, ENTERPRISE.
NotifiedOnCreativeRejection	Boolean	False		Indicates if creative contact is notified when a creative has been rejected due to content.
NotifiedOnEndOfCampaign	Boolean	False		Indicates if campaign contact is notified when an associated campaign has been completed.
Status	String	False		Status of the account The allowed values are ACTIVE, PENDING_DELETION, CANCELED, DRAFT, REMOVED.
NotifiedOnCampaignOptimization	Boolean	False		Indicates if campaign contact is notified about campaign optimization opportunities.
Version	String	True		Version of the account
Reference	String	False		The entity on whose behalf the account advertises.
NotifiedOnCreativeApproval	Boolean	False		Indicates if creative contact is notified when a creative has been reviewed and approved.
AuditStampsCreator	String	True		The person who created audit stamps for the first time
AuditStampsCreatedAt	Datetime	True		The datetime in which the audit stamp was created first
AuditStampsLastModifier	String	True		Last modifier of the Audit stamps
AuditStampsLastModifiedAt	Datetime	True		Last modified datetime of the audit stamps
IsTest	Boolean	False		Flag showing whether this account is marked as a test account. An account can be marked as test only during creation. This is an immutable field.
URN	String	True		The URN of the account.

MCP Server for LinkedIn Marketing Solutions