Linkedin Ads: Url Report

Description

• Each record in this table represents the daily performance of ads at the url 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.
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	base_url	The base URL of the ad, extracted from the click_uri.
STRING	url_host	The URL host of the ad, extracted from the click_uri.
STRING	url_path	The URL path of the ad, extracted from the click_uri.
STRING	utm_source	The utm_source parameter of the ad, extracted from the click_uri.
STRING	utm_medium	The utm_medium parameter of the ad, extracted from the click_uri.
STRING	utm_campaign	The utm_campaign parameter of the ad, extracted from the click_uri.
STRING	utm_content	The utm_content parameter of the ad, extracted from the click_uri.
STRING	utm_term	The utm_term parameter of the ad, extracted from the click_uri.
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	currency	The ISO 4217 currency code of the account, such as 'USD' for United States Dollar (default).
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.