Accounts

Retrieves all advertising accounts the authenticated user has access to, filtered by a specified status to help manage and monitor active or inactive accounts.

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 connector uses the LinkedIn Marketing Solutions API to process search criteria that refer to the Status column. The connector processes other filters client-side within the connector. 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		Unique identifier of the advertising account within LinkedIn Ads.
Name	String	False		Display name assigned to the account, typically used to identify it in reports and the Campaign Manager interface.
Currency	String	False		Currency code defined by ISO 4217 representing the currency used for billing and reporting in this account.
Type	String	False		Specifies the type of advertising account, such as a business or enterprise account. The allowed values are BUSINESS, ENTERPRISE.
NotifiedOnCreativeRejection	Boolean	False		Indicates whether the creative contact receives notifications when a creative is rejected due to policy or content issues.
NotifiedOnEndOfCampaign	Boolean	False		Indicates whether the campaign contact receives a notification when a campaign associated with the account has finished running.
Status	String	False		Current operational status of the account. The allowed values are ACTIVE, PENDING_DELETION, CANCELED, DRAFT, REMOVED.
NotifiedOnCampaignOptimization	Boolean	False		Indicates whether the campaign contact is notified about optimization recommendations or performance improvement opportunities.
Version	String	True		Represents the version or revision identifier for the account record, used to manage updates and concurrency.
Reference	String	False		Identifies the entity or organization on whose behalf the account runs advertisements.
NotifiedOnCreativeApproval	Boolean	False		Indicates whether the creative contact receives a notification when a creative has been reviewed and approved for use.
AuditStampsCreator	String	True		Name or identifier of the user who initially created the audit record for this account.
AuditStampsCreatedAt	Datetime	True		Date and time when the account's audit record was first created.
AuditStampsLastModifier	String	True		Name or identifier of the user who last modified the audit record for this account.
AuditStampsLastModifiedAt	Datetime	True		Date and time when the account's audit record was most recently updated.
IsTest	Boolean	False		If the value is 'true', the account is designated as a test account, which can only be set during account creation and cannot be changed later.
URN	String	True		Uniform Resource Name (URN) that uniquely identifies the account within LinkedIn's system.

Power BI Connector for LinkedIn Marketing Solutions