Excel Add-In for LinkedIn Marketing Solutions

Build 26.0.9655

Campaigns

Retrieves campaigns in your LinkedIn Ads account by specified status, allowing performance tracking and campaign management.

Table-Specific Information

Select

The Campaigns table returns campaigns associated with the authenticated user. You can use these campaigns 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 Campaigns WHERE Status = 'ACTIVE'

SELECT * FROM Campaigns WHERE AdAccountId = '510013292'

Insert

To create a new campaign, the following columns are required: CampaignGroup, DailyBudgetAmount, DailyBudgetCurrency, Country, Language, Name, OffsiteDeliveryEnabled, ScheduleStartTime, Status, Type, UnitCostAmount, UnitCostCurrency, and AdAccountId. 

     INSERT INTO Campaigns (Id, CampaignGroup, DailyBudgetAmount, DailyBudgetCurrency, Country, Language, Name, OffsiteDeliveryEnabled, ScheduleStartTime, ScheduleEndTime, Status, Type, UnitCostAmount, UnitCostCurrency, AdAccountId) VALUES ('camp789', 'urn:li:sponsoredCampaignGroup:756063323', '150.00', 'USD', 'US', 'en', 'Spring Lead Generation 4', FALSE, '2025-07-01 09:00:00', '2025-07-31 23:59:59', 'DRAFT', 'TEXT_AD', '2.50', 'USD', '515218099');

Update

To update a campaign, use an UPDATE statement.

Note: The Id and AdAccountId columns are required in the WHERE clause.

The following columns cannot be updated after creation: Id, Account, AdAccountId, Type, and ConnectedTelevisionOnly. 

     UPDATE Campaigns SET CampaignGroup = 'urn:li:sponsoredCampaignGroup:756063323', Name = 'Updated Campaign Name', ScheduleStartTime = '2025-07-15 09:00:00', ScheduleEndTime = '2025-08-15 18:00:00', Status = 'PAUSED' WHERE Id = '403469283' and AdAccountId = '515218099'

Delete

To remove a campaign, use a DELETE statement.

Note: The Id and AdAccountId columns are required in the WHERE clause. 

     DELETE FROM Campaigns WHERE Id = 123456789 AND AdAccountId = '123456789';

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique numerical identifier assigned to the campaign.

AdAccountId String False

Unique identifier of the advertising account linked to the campaign.

CampaignGroup String False

Numerical identifier of the campaign group that the campaign belongs to.

AssociatedEntity String False

URN that identifies a related object, with the specific meaning depending on the campaign type (for example, a creative or targeting entity).

AudienceExpansionEnabled Boolean False

Identifies whether or not Audience Expansion is enabled, allowing LinkedIn to broaden targeting by including members with similar attributes to the defined audience.

CostType String False

Specifies the campaign's pricing model: cost-per-click (CPC) or cost-per-impression (CPM).

The allowed values are CPM, CPC, CPV.

CreativeSelection String False

Determines how creatives are rotated or prioritized. ROUND_ROBIN evenly rotates creatives, while OPTIMIZED favors those expected to perform better.

DailyBudgetAmount String False

Specifies the campaign's daily spending limit as a real number string.

DailyBudgetCurrency String False

Currency code defined by the ISO that specifies the currency for the daily budget.

Country String False

Specifies the country where the campaign is served, using an uppercase two-letter code defined by ISO 3166.

Language String False

Specifies the campaign language using a lowercase two-letter code defined by '.

Name String False

Name assigned to the campaign, used to identify it in reports and within the account.

OffsiteDeliveryEnabled Boolean False

Identifies whether or not the campaign is allowed to serve ads on the LinkedIn Audience Network beyond the LinkedIn platform.

ScheduleStartTime Datetime False

Start date and time when the campaign becomes active and eligible to serve ads.

ScheduleEndTime Datetime False

End date and time when the campaign is scheduled to stop serving ads.

Status String False

Indicates the current operational status of the campaign.

The allowed values are ACTIVE, ARCHIVED, COMPLETED, CANCELED, DRAFT, PAUSED, PENDING_DELETION, REMOVED.

Type String False

Specifies the campaign type.

The allowed values are TEXT_AD, SPONSORED_UPDATES, SPONSORED_INMAILS, DYNAMIC.

UnitCostAmount String False

Specifies the bid amount per click, impression, or other event, depending on the campaign's pricing model.

UnitCostCurrency String False

Specifies the currency used for the bid amount, matching the account's currency settings.

ObjectiveType String False

Defines the primary objective of the campaign.

The allowed values are BRAND_AWARENESS, ENGAGEMENT, JOB_APPLICANTS, LEAD_GENERATION, WEBSITE_CONVERSIONS, WEBSITE_VISITS, VIDEO_VIEWS.

ConnectedTelevisionOnly Boolean False

Identifies whether or not the campaign is designated as a Connected Television (CTV)–only campaign, meaning ads are shown exclusively on connected TV devices.

TimeSpanDuration Integer False

Specifies the numerical duration value for the campaign's time span.

TimeSpanUnit String False

Specifies the time unit associated with the campaign's duration, such as days or weeks.

Frequency Integer False

Defines how many times a campaign's ad is shown to the same member within a given period.

OptimizationType String False

Specifies the optimization strategy applied to control ad frequency and performance.

OptimizationTargetType String False

Defines how the campaign is optimized for spending or outcomes. If not set, no optimization strategy is applied.

The allowed values are NONE, ENHANCED_CONVERSION, TARGET_COST_PER_CLICK, TARGET_COST_PER_IMPRESSION, TARGET_COST_PER_VIDEO_VIEW, CAP_COST_AND_MAXIMIZE_CLICKS, CAP_COST_AND_MAXIMIZE_IMPRESSIONS, CAP_COST_AND_MAXIMIZE_VIDEO_VIEWS, MAX_REACH, MAX_LEAD, MAX_VIDEO_VIEW, MAX_CONVERSION, MAX_CLICK, MAX_IMPRESSION, MAX_QUALIFIED_LEAD.

BlockedIABCategories String False

Lists Interactive Advertising Bureau (IAB) mobile application categories that are blocked from serving this campaign's ads off-network.

AllowedPublisherRestrictionFiles String False

Lists publisher restriction files that define which off-network sites are approved to serve the campaign's ads.

BlockedPublisherRestrictionFiles String False

Lists publisher restriction files that define which off-network sites are prohibited from serving the campaign's ads.

PoliticalIntent String False

The political intent of the campaign.

The allowed values are NOT_DECLARED, NOT_POLITICAL, POLITICAL.

The default value is NOT_DECLARED.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655