JDBC Driver for LinkedIn Marketing Solutions

Build 22.0.8462

CampaignInsights

The Insights API offers analysis of a campaign's budget utilization, and identifies modifications that can be made to a bid, daily budget, or total budget to maximize utilization or impressions.

Table Specific Information

Select

The CampaignInsights view returns a list of the analysis of a campaign's budget utilization, and identifies modifications that can be made to a bid, daily budget, or total budget to maximize utilization or impressions.

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

SELECT * FROM CampaignInsights

SELECT * FROM CampaignInsights WHERE Campaign='123456'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type Description
Campaign String The campaign to which this recommendation belongs.
AverageSpendAmount String The average spend of the entity.
AverageSpendCurrencyCode String The currency code of the average spend.
BidAmount String A prediction of how much additional impressions could be generated from a different bid.
BidCurrencyCode String The currency code of additional impressions.
RelativeImpressions Decimal A prediction of how much additional impressions could be generated from a different bid.
BudgetExhaustedAt Timestamp Date at which the ad entity's TotalBudget will be exhausted, in Unix Epoch time.
CampaignRelevanceScore Long A score between 0 and 10 (inclusive) indicating how relevant this campaign is compared to its competitors.
DailyBudgetUtilization Decimal The average daily budget utilization.
TotalBudgetUtilization Decimal The fraction of the total budget this ad entity has spent so far.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462