Power BI Connector for LinkedIn Marketing Solutions

Build 24.0.9060

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

NOTE: This view is deprecated and will be removed in early 2025.

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 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 CampaignInsights WHERE Campaign = '123456'

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060