CampaignGroups

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

Table Specific Information

NOTE: The Account column is deprecated and will be removed in the next major version of the add-in.

Select

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

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

SELECT * FROM CampaignGroups WHERE Status = 'ACTIVE'

SELECT * FROM CampaignGroups WHERE AdAccountId = '510013292'

CUD Operations

Insert

To create a new campaign group there are some fields that are required in initial creation which are: Account, Name, ScheduleStartTime, AdAccountId.

While the following parameters are optional: Status, TotalBudgetAmount, TotalBudgetCurrencyCode, ScheduleEndTime

Note: When specifying the status of the campaign group in creation it can only be ACTIVE or DRAFT.

    INSERT INTO CampaignGroups (Account, Name, Status, TotalBudgetAmount, TotalBudgetCurrencyCode, ScheduleStartTime, ScheduleEndTime, AdAccountId ) VALUES ( 'urn:li:sponsoredAccount:12345', 'Sample Campaign Group', 'ACTIVE', 5000.00, 'USD', '2025-07-15 09:00:00', '2025-12-31 23:59:59', '123465798' );

Update

To modify an existing campaign group the Id and AdAccountId columns are required in the WHERE clause.

The following columns are the ones that are mutable after creation: Name, Status, TotalBudgetAmount, TotalBudgetCurrencyCode, ScheduleStartTime, ScheduleEndTime.

    UPDATE CampaignGroups SET Name = 'Updated Campaign Group Name', Status = 'PAUSED', TotalBudgetAmount = 7500.00, TotalBudgetCurrencyCode = 'USD', ScheduleStartTime = '2025-08-01 00:00:00', ScheduleEndTime = '2025-12-31 23:59:59' WHERE Id = 789 AND AdAccountId = '123456789';

Delete

To remove a campaign group the Id and AdAccountId columns are required in the WHERE clause.

    DELETE FROM CampaignGroups WHERE Id = 789 AND AdAccountId = '123456789';

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Numerical identifier for the campaign group
Account	String	False		URN identifying the advertising account associated with the Campaign Group. This value is immutable once set
Name	String	False		The name of the Campaign Group. Primarily used to make it easier to reference a Campaign Group and to recall its purpose
Status	String	False		Current Status of the campaign group The allowed values are ACTIVE, PENDING_DELETION, REMOVED, PAUSED, ARCHIVED, DRAFT, CANCELED.
TotalBudgetAmount	Decimal	False		Maximum amount to spend over the life of the Campaign Group.
TotalBudgetCurrencyCode	String	False		ISO currency code. The currency code must match that of the parent account.
ScheduleStartTime	Datetime	False		Represents the inclusive (greater than or equal to) value in which to start the range.
ScheduleEndTime	Datetime	False		Scheduled date range to run associated objects.
Backfilled	Boolean	True		Flag that denotes whether the Campaign Group was created organically or was created to backfill existing campaigns.
AdAccountId	String	False		Id of the account
URN	String	True		The URN of the campaign group.

Excel Add-In for LinkedIn Marketing Solutions