LinkedIn Ads data reference

A per-tab list of every column SyncRange can export, with a short description of what each one contains. Use this page when picking columns in the export builder, or when you need to know exactly what a value represents in BigQuery or Google Sheets.

Each tab below notes whether it uses the export date range or always exports a full current snapshot when that applies.

For configuration steps see Configuring LinkedIn Ads exports.

Campaigns

One row per campaign, including budget settings and performance metrics for the selected date range / time granularity.

ColumnDescription
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
StatusStatus.
Account URNAccount URN.
Campaign Group URNCampaign Group URN.
Objective TypeObjective Type.
Campaign TypeCampaign Type.
FormatFormat.
Daily Budget AmountDaily Budget Amount in the row currency unless noted otherwise.
Daily Budget CurrencyDaily Budget Currency (ISO 4217 when applicable).
Unit Cost AmountUnit Cost Amount in the row currency unless noted otherwise.
Unit Cost CurrencyUnit Cost Currency (ISO 4217 when applicable).
Cost TypeCost Type in the row currency unless noted otherwise.
Pacing StrategyPacing Strategy.
Optimization TargetOptimization Target.
Creative SelectionCreative Selection.
Audience Expansion EnabledAudience Expansion Enabled.
Test CampaignTest Campaign.
Connected TV OnlyConnected TV Only.
Offsite Delivery EnabledOffsite Delivery Enabled.
Campaign Start DateCampaign Start Date.
Campaign End DateCampaign End Date.
Serving StatusesServing Statuses.
Created TimeCreated Time.
Last Modified TimeLast Modified Time.
Date StartDate Start.
Date StopDate Stop.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
Cost (USD)Cost (USD) for the row period.
CTRClick-through rate.
CPCCost per click.
CPMCost per thousand impressions.
Total EngagementsTotal Engagements in the row currency unless noted otherwise.
LikesLikes.
CommentsComments.
SharesShares.
FollowsFollows.
Video ViewsVideo Views.
Landing Page ClicksLanding Page Clicks.
One Click LeadsOne Click Leads.
ConversionsConversions.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Campaign Groups

One row per campaign group with budget and schedule fields.

ColumnDescription
Campaign Group IDCampaign Group ID from the source platform.
Campaign Group NameCampaign Group Name.
StatusStatus.
Account URNAccount URN.
Total Budget AmountTotal Budget Amount in the row currency unless noted otherwise.
Total Budget CurrencyTotal Budget Currency (ISO 4217 when applicable).
Start DateStart Date.
End DateEnd Date.
Created TimeCreated Time.
Last Modified TimeLast Modified Time.
Date StartDate Start.
Date StopDate Stop.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
Cost (USD)Cost (USD) for the row period.
CTRClick-through rate.
CPCCost per click.
CPMCost per thousand impressions.
Total EngagementsTotal Engagements in the row currency unless noted otherwise.
LikesLikes.
CommentsComments.
SharesShares.
FollowsFollows.
Video ViewsVideo Views.
Landing Page ClicksLanding Page Clicks.
One Click LeadsOne Click Leads.
ConversionsConversions.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Creatives

One row per creative with performance metrics for the selected window.

ColumnDescription
Creative IDCreative ID from the source platform.
Creative NameCreative Name.
StatusStatus.
Account URNAccount URN.
Campaign URNCampaign URN.
Creative TypeCreative Type.
FormatFormat.
Media TypeMedia Type.
Created TimeCreated Time.
Last Modified TimeLast Modified Time.
Date StartDate Start.
Date StopDate Stop.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
Cost (USD)Cost (USD) for the row period.
CTRClick-through rate.
CPCCost per click.
CPMCost per thousand impressions.
Total EngagementsTotal Engagements in the row currency unless noted otherwise.
LikesLikes.
CommentsComments.
SharesShares.
FollowsFollows.
Video ViewsVideo Views.
Landing Page ClicksLanding Page Clicks.
One Click LeadsOne Click Leads.
ConversionsConversions.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Shares

One row per organic share / post analytics row when available.

ColumnDescription
Share IDShare ID from the source platform.
Share NameShare Name.
StatusStatus.
Account URNAccount URN.
Campaign URNCampaign URN.
Share TypeShare Type.
FormatFormat.
Media TypeMedia Type.
Share Reference URNShare Reference URN.
Direct Sponsored ContentDirect Sponsored Content.
Serving StatusesServing Statuses.
Test FlagTest Flag.
Creative IDCreative ID from the source platform.
Created TimeCreated Time.
Last Modified TimeLast Modified Time.
Date StartDate Start.
Date StopDate Stop.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
Cost (USD)Cost (USD) for the row period.
CTRClick-through rate.
CPCCost per click.
CPMCost per thousand impressions.
Total EngagementsTotal Engagements in the row currency unless noted otherwise.
LikesLikes.
CommentsComments.
SharesShares.
FollowsFollows.
Video ViewsVideo Views.
Landing Page ClicksLanding Page Clicks.
One Click LeadsOne Click Leads.
ConversionsConversions.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Video Ads

One row per video ad with video-specific metrics.

ColumnDescription
Video Ad IDVideo Ad ID from the source platform.
Video Ad NameVideo Ad Name.
StatusStatus.
Account URNAccount URN.
Campaign URNCampaign URN.
Video Ad TypeVideo Ad Type.
FormatFormat.
Media TypeMedia Type.
Video DurationVideo Duration.
Video URLVideo URL.
Thumbnail URLThumbnail URL.
Created TimeCreated Time.
Last Modified TimeLast Modified Time.
Date StartDate Start.
Date StopDate Stop.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
Cost (USD)Cost (USD) for the row period.
CTRClick-through rate.
CPCCost per click.
CPMCost per thousand impressions.
Total EngagementsTotal Engagements in the row currency unless noted otherwise.
LikesLikes.
CommentsComments.
SharesShares.
FollowsFollows.
Video ViewsVideo Views.
Video StartsVideo Starts.
Video CompletionsVideo Completions.
Landing Page ClicksLanding Page Clicks.
One Click LeadsOne Click Leads.
ConversionsConversions.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Accounts

One row per ad account. Snapshot of account settings.

ColumnDescription
Account IDAccount ID from the source platform.
Account NameAccount Name.
Account StatusAccount Status.
Test AccountTest Account.
Account Created AtAccount Created At.
Account Last Modified AtAccount Last Modified At.
CurrencyCurrency (ISO 4217 when applicable).
CountryCountry.
Account TypeAccount Type.
Account ReferenceAccount Reference.
Serving StatusesServing Statuses.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Audiences

One row per audience / segment definition.

ColumnDescription
Audience IDAudience ID from the source platform.
Audience NameAudience Name.
Audience TypeAudience Type.
Audience SizeAudience Size.
Account URNAccount URN.
StatusStatus.
DescriptionDescription.
Created AtCreated At.
Last Modified AtLast Modified At.
Audience TypeAudience Type.
Audience DefinitionAudience Definition.
Targeting CriteriaTargeting Criteria.
Date StartDate Start.
Date StopDate Stop.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Conversions

One row per conversion rule / conversion analytics row.

ColumnDescription
Conversion IDConversion ID from the source platform.
Conversion NameConversion Name.
Conversion TypeConversion Type.
Conversion CategoryConversion Category.
Account URNAccount URN.
StatusStatus.
DescriptionDescription.
Created AtCreated At.
Last Modified AtLast Modified At.
Conversion TypeConversion Type.
Conversion CategoryConversion Category.
Attribution ModelAttribution Model.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
Cost (USD)Cost (USD) for the row period.
ConversionsConversions.
Conversion RateConversion Rate.
Cost Per ConversionCost Per Conversion in the row currency unless noted otherwise.
Date StartDate Start.
Date StopDate Stop.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Related documentation

Something missing on this page? Email [email protected]

Start syncing your ecommerce data in minutes Start free today. No credit card required.