Linkedin Ads: Campaign Report

Description

• Each record in this table represents the daily performance of ads at the campaign level.

Supported Data Sources

• LinkedIn Ad Analytics

Columns

Type	Name	Description
STRING	source_relation	The source of the record if the unioning functionality is being used. If not this field will be empty.
DATETIME	date_day	The day of the activity.
INTEGER	campaign_id	Unique internal ID representing the campaign.
STRING	campaign_name	A label for the campaign.
INTEGER	version_tag	An integer representation of the version of the campaign.
INTEGER	campaign_group_id	Unique internal ID representing the campaign group.
STRING	campaign_group_name	A label for the campaign group.
INTEGER	account_id	Unique internal ID representing the account.
STRING	account_name	A label for the account.
STRING	campaign_status	ACTIVE - Denotes that the campaign is fully servable.PAUSED - Denotes that the campaign meets all requirements to be served, but temporarily should not be.ARCHIVED - Denotes that the campaign is presently inactive, and should mostly be hidden in the UI until un-archived.COMPLETED - Denotes that the campaign has reached a specified budgetary or chronological limit.CANCELED - Denotes that the campaign has been permanently canceled, such as when an advertising account is permanently closed.DRAFT - Denotes that the campaign is still being edited and not eligible for serving. Some validation will be postponed until the campaign is activated.PENDING_DELETION - Denotes that the campaign has been requested to be deleted that is currently pending.REMOVED - Denotes that the campaign was deleted, but must remain fetchable due to the existence of performance data.
STRING	campaign_group_status	Status of campaign's campaign group. Possible values are: ACTIVE - Denotes that the campaign group is capable of serving ads, subject to run date and budget limitations (as well as any other limitations at the account or campaign level). ARCHIVED - Denotes that the campaign group is presently inactive, and should mostly be hidden in the UI until un-archived. CANCELLED - Denotes that the campaign group has been permanently canceled and cannot be reactivated. Not a settable status. DRAFT - Denotes that the campaign group is in a preliminary state and should temporarily not be served. PAUSED - Denotes that the campaign group meets all requirements to be served, but temporarily should not be. PENDING_DELETION - Denotes that the campaign group has been requested to be deleted that is currently pending. REMOVED - Denoted that the campaign group was deleted, but must remain fetchable due to the existence of performance data.
STRING	type	TEXT_AD - Text-based ads that show up in the right column or top of the page on LinkedIn.SPONSORED_UPDATES - Native ads that promote a company's content updates in the LinkedIn feed.SPONSORED_INMAILS - Personalized messages with a call-to-action button delivered to a LinkedIn's member inbox.DYNAMIC - Ads that are dynamically personalized.
STRING	cost_type	CPM - Cost per thousand advertising impressions. If type=SPONSORED_INMAILS; cost per send(CPS) is measured as CPM x 1000.CPC- Cost per individual click on the associated link.CPV- Cost per view for video ads.
STRING	creative_selection	ROUND_ROBIN - Rotate through available creatives to serve them as evenly as possible.OPTIMIZED (default) - Bias selection taking into account such as expected performance. Not available for Message and Conversation Ads (type=SPONSORED_INMAILS).
DECIMAL	daily_budget_amount	Maximum amount to spend per day UTC. The amount of money as a real number string.
STRING	daily_budget_currency_code	ISO currency code. The currency must match that of the parent account.
DECIMAL	unit_cost_amount	This value is used as one of the following: amount to bid (for manual bidding), amount which is the target cost (for target cost bidding) per click, impression, or other event depending on the pricing model, or cost cap (for cost cap bidding). The amount of money as a real number string. The amount should be non-negative if the bidding strategy is manual, target cost, or cost cap bidding. The default is 0 with the currency code set to match that of the associated account.
STRING	unit_cost_currency_code	Amount to bid per click, impression, or other event depending on the pricing model. The default is 0 with the currency code set to match that of the associated account. ISO currency code.
STRING	currency	The ISO 4217 currency code of the account, such as 'USD' for United States Dollar (default).
STRING	format	The ad format on the campaign level. See https://docs.microsoft.com/en-us/linkedin/marketing/integrations/ads/campaign-formats?view=li-lms-2022-07
STRING	locale_country	Locale of the campaign. An uppercase two-letter country code as defined by ISO-3166.
STRING	locale_language	Locale of the campaign. A lowercase two-letter language code as defined by ISO-639.
STRING	objective_type	Campaign Objective type values. Click here for Campaign Objective descriptions. One of: - BRAND_AWARENESS - ENGAGEMENT - JOB_APPLICANTS - LEAD_GENERATION - WEBSITE_CONVERSIONS - WEBSITE_VISITS - VIDEO_VIEWS
STRING	optimization_target_type	Determines how this campaign is optimized for spending. If this is not set, there is no optimization. Refer to the documentation here. Default = 'NONE'.
BOOLEAN	is_audience_expansion_enabled	Boolean (default=false) representing whether Audience Expansion is enabled for the campaign provides query expansion for certain targeting criteria.
BOOLEAN	is_offsite_delivery_enabled	Boolean indicating if this campaign to allowed to be served on the LinkedIn Audience Network to extend the reach of your campaign by delivering ads beyond the LinkedIn feed to members on third-party apps and sites. (default will be "True" from June 30, 2022)
DATETIME	run_schedule_start_at	Scheduled date range to run associated creatives. The start date must be non-null. Represents the inclusive (greater than or equal to) value in which to start the range.
DATETIME	run_schedule_end_at	Scheduled date range to run associated creatives. The start date must be non-null. Represents the exclusive (strictly less than) value in which to end the range, if provided.
DATETIME	last_modified_at	The timestamp of when the version was updated.
DATETIME	created_at	The timestamp of when the campaign was created.
INTEGER	clicks	The count of chargeable clicks.
INTEGER	impressions	This is the count of "impressions" for Direct Ads and Sponsored Updates and "sends" for InMails.
INTEGER	cost	The cost of the ads in the local currency or USD.