CampaignGroups

Lists all campaign groups available to the authenticated user, filtered by status, to help organize and manage related campaigns.

Table-Specific Information

Select

The CampaignGroups table returns campaign groups associated with the authenticated user. You can use these campaign groups as dimensions in analytic requests.

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

SELECT * FROM CampaignGroups WHERE Status = 'ACTIVE'

SELECT * FROM CampaignGroups WHERE AdAccountId = '510013292'

Insert

To create a new campaign group, the following fields are required: Name, ScheduleStartTime, and AdAccountId.

Note: When creating a campaign group, valid values for Status are ACTIVE or DRAFT.

    INSERT INTO CampaignGroups (Name, Status, TotalBudgetAmount, TotalBudgetCurrencyCode, ScheduleStartTime, ScheduleEndTime, AdAccountId) VALUES ('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 can be updated after creation: Name, Status, TotalBudgetAmount, TotalBudgetCurrencyCode, ScheduleStartTime, and 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		Unique numerical identifier assigned to the campaign group.
AdAccountId	String	False		Unique identifier of the advertising account linked to the campaign group.
Name	String	False		Descriptive name of the campaign group, used to identify and manage related campaigns within the account.
Status	String	False		Indicates the current operational status of the campaign group. The allowed values are ACTIVE, PENDING_DELETION, REMOVED, PAUSED, ARCHIVED, DRAFT, CANCELED.
TotalBudgetAmount	Decimal	False		Specifies the maximum total budget allocated for all campaigns within the campaign group.
TotalBudgetCurrencyCode	String	False		Currency code defined by the ISO that specifies the currency for the total budget. It must match the parent account's currency.
ScheduleStartTime	Datetime	False		Start date and time for when the campaign group becomes active and eligible to run associated campaigns.
ScheduleEndTime	Datetime	False		End date and time defining when the campaign group stops running associated campaigns.
Backfilled	Boolean	True		If the value is 'true', the campaign group was created to backfill pre-existing campaigns rather than being created organically.
URN	String	True		URN that uniquely identifies the campaign group within LinkedIn Ads.