Linkedin Ads: Account Report

Description

• Each record in this table represents the daily performance of ads at the account 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	account_id	Unique internal ID representing the account.
STRING	account_name	A label for the account.
INTEGER	version_tag	An integer representation of the version of the account.
STRING	currency	The ISO 4217 currency code of the account, such as 'USD' for United States Dollar (default).
STRING	status	ACTIVE - Account is active; this is the default stateCANCELLED - Account has been permanently cancelledDRAFT - Account is in draft status, meaning it's not yet fully set up and it is not servingPENDING_DELETION - Denotes that the account has been requested to be deleted that is currently pendingREMOVED - Denotes that the account was deleted, but must remain fetchable due to the existence of performance data.
STRING	type	BUSINESS - This is the only value allowed when creating accounts through the API.ENTERPRISE - This value cannot be used to create accounts through the API and is reserved for accounts created by LinkedIn's internal ad operations systems.
DATETIME	last_modified_at	The timestamp of when the version was updated.
DATETIME	created_at	The timestamp of when the account 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.