Linkedin Ads: Creative Report

Description

• Each record in this table represents the daily performance of ads at the creative 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	creative_id	Unique internal ID representing the creative.
INTEGER	campaign_id	Unique internal ID representing the creative's campaign.
STRING	campaign_name	A label for the creative's 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	click_uri	Required when creative type is TEXT_AD. Maximum character limit of 500 after URL encoding all special characters. Limit does not include the "https://" prefix.
STRING	creative_status	ACTIVE - Creative creation is complete and creative is available for review and serve.PAUSED - Creative creation is complete and creative is current, but should temporarily not be served. This status is not valid upon creation.DRAFT - Creative creation is incomplete and may still be edited.ARCHIVED - Creative creation is complete, but creative should not be served and should be separated from non-archived creatives in any UI.CANCELED - Creative is permanently canceled.
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	currency	The ISO 4217 currency code of the account, such as 'USD' for United States Dollar (default).
DATETIME	last_modified_at	The timestamp of when the version was updated.
DATETIME	created_at	The timestamp of when the creative 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.