Skip to main content
LinkedIn Ads is a powerful tool for B2B marketers, offering unique targeting capabilities to reach a professional audience. With various ad formats and robust analytics, it helps businesses achieve their marketing objectives, from lead generation to brand awareness.

​
Configuring LinkedIn Ads as a Source

In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the LinkedIn Ads option from the list of connectors. Click Next and you’ll be prompted to add your access.

​
1. Add account access

You’ll need your LinkedIn Ads OAuth credentials for this connection. You can generate these in your LinkedIn Developer portal. Once you have them, add the account access, then click Next.
  • Authorization: Log in with a Linkedin account that has proper access to the LinkedIn Ads account you want to extract data from.
  • Account ID: The ID for the LinkedIn Ads account you want to extract data from. This can be found on https://www.linkedin.com/campaignmanager right below the organization name on the left-side panel.
  • Start Date: The earliest record date to sync.
Linkedin only returns up to 1-year of historical data for daily performance reports.

​
2. Select streams

Choose which data streams you want to sync - you can select all streams or pick specific ones that matter most to you.
Tip: The stream can be found more easily by typing its name.
Select the streams and click Next.

​
3. Configure data streams

Customize how you want your data to appear in your catalog. Select a name for each table (which will contain the fetched data) and the type of sync.
  • Table name: we suggest a name, but feel free to customize it. You have the option to add a prefix and make this process faster!
  • Sync Type: you can choose between INCREMENTAL and FULL_TABLE.
    • Incremental: every time the extraction happens, we’ll get only the new data - which is good if, for example, you want to keep every record ever fetched.
    • Full table: every time the extraction happens, we’ll get the current state of the data - which is good if, for example, you don’t want to have deleted data in your catalog.
Once you are done configuring, click Next.

​
4. Configure data source

Describe your data source for easy identification within your organization, not exceeding 140 characters. To define your Trigger, consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, or only at specific times). Optionally, you can determine when to execute a full sync. This will complement the incremental data extractions, ensuring that your data is completely synchronized with your source every once in a while. Once you are ready, click Next to finalize the setup.

​
5. Check your new source

You can view your new source on the Sources page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.
For you to be able to see it on your Catalog, you need at least one successful source run.

​
Streams and Fields

Below you’ll find all available data streams from LinkedIn Ads and their corresponding fields:
Stream for fetching ad accounts information.Key Fields:
  • id: The account ID.
  • name: The account name.
  • type: The account type.
  • status: Current status of the account.
  • currency: The account’s currency.
  • reference: The LinkedIn organization reference URN.
  • changeAuditStamps: Audit timestamps for account creation and modification, including creator, modifier, and timestamps.
  • notifiedOnCampaignOptimization: Whether notifications are enabled for campaign optimization.
  • notifiedOnCreativeApproval: Whether notifications are enabled for creative approvals.
  • notifiedOnCreativeRejection: Whether notifications are enabled for creative rejections.
  • notifiedOnEndOfCampaign: Whether notifications are enabled for campaign end.
  • servingStatuses: List of serving statuses for the account.
  • test: Whether this is a test account.
  • version: Version information for the account.
Stream for fetching campaign groups.Key Fields:
  • id: Unique identifier for the campaign group.
  • name: Name of the campaign group.
  • status: Current status of the campaign group.
  • account: The ad account this campaign group belongs to.
  • runSchedule: Run schedule for the campaign group, including start and end times.
  • changeAuditStamps: Timestamps for creation and last modification.
  • test: Whether the campaign group is a test.
  • servingStatuses: Serving statuses for the campaign group.
  • allowedCampaignTypes: Allowed campaign types within this group.
  • backfilled: Whether the campaign group has been backfilled.
Stream for fetching campaigns.Key Fields:
  • id: Unique identifier for the campaign.
  • name: Name of the campaign.
  • status: Current status of the campaign.
  • type: Type of campaign (e.g. SPONSORED_UPDATES).
  • account: URN of the associated advertising account.
  • campaignGroup: URN of the campaign group.
  • servingStatuses: Current serving status of the campaign.
  • locale: Locale settings for the campaign, including country and language.
  • version: Version information for the campaign.
  • associatedEntity: URN of the associated LinkedIn organization.
  • test: Whether this is a test campaign.
  • runSchedule: Campaign schedule information, including start and end timestamps.
  • targeting: Targeting settings for the campaign.
  • optimizationPreference: Campaign optimization preferences.
  • optimizationTargetType: Target type for campaign optimization.
  • changeAuditStamps: Audit timestamps for campaign creation and last modification.
  • dailyBudget: Daily budget settings, including amount and currency code.
  • unitCost: Cost per unit settings, including amount and currency code.
  • creativeSelection: Creative selection method (e.g. OPTIMIZED).
  • costType: Cost type for the campaign (e.g. CPC).
  • offsiteDeliveryEnabled: Whether offsite delivery is enabled.
  • audienceExpansionEnabled: Whether audience expansion is enabled.
Stream for fetching creatives.Key Fields:
  • id: Unique identifier for the creative.
  • status: Current status of the creative.
  • campaign: URN of the associated campaign.
  • account: URN of the associated account.
  • createdAt: Timestamp when the creative was created.
  • servingHoldReasons: List of reasons why the creative is not serving.
  • lastModifiedAt: Timestamp when the creative was last modified.
  • isTest: Whether this is a test creative.
  • createdBy: URN of the user who created the creative.
  • isServing: Whether the creative is currently serving.
  • lastModifiedBy: URN of the user who last modified the creative.
  • intendedStatus: Intended status of the creative.
  • content: URN reference to the creative content.
Stream for fetching aggregated analytics per campaign.Key Fields:
  • _id: Unique identifier for the analytics data.
  • account_id: Account ID.
  • campaign_id: Campaign ID.
  • date: Date of the analytics data.
  • impressions: Number of impressions served.
  • clicks: Number of clicks received.
  • totalEngagements: Total engagements (clicks, likes, shares, etc.).
  • costInLocalCurrency: Total cost in local currency.
  • oneClickLeads: Number of one-click leads.
  • externalWebsitePostClickConversions: Post-click conversions on external websites.
  • externalWebsitePostViewConversions: Post-view conversions on external websites.
  • videoViews: Number of video views.
  • videoCompletions: Number of completed video views.
  • likes: Number of likes.
  • shares: Number of shares.
  • follows: Number of follows.
  • comments: Number of comments.
  • reactions: Number of reactions.
  • landingPageClicks: Clicks to landing page.
  • companyPageClicks: Clicks to company page.
  • sends: Number of messages sent.
  • opens: Number of messages opened.
Stream for fetching creative analytics.Key Fields:
  • _id: Unique identifier for the analytics data.
  • account_id: Account ID.
  • creative_id: Creative ID.
  • date: Date of the analytics data.
  • impressions: Number of impressions served.
  • clicks: Number of clicks received.
  • totalEngagements: Total engagements (clicks, likes, shares, etc.).
  • costInLocalCurrency: Total cost in local currency.
  • oneClickLeads: Number of one-click leads.
  • externalWebsitePostClickConversions: Post-click conversions on external websites.
  • externalWebsitePostViewConversions: Post-view conversions on external websites.
  • videoViews: Number of video views.
  • videoCompletions: Number of completed video views.
  • likes: Number of likes.
  • shares: Number of shares.
  • follows: Number of follows.
  • comments: Number of comments.
  • reactions: Number of reactions.
  • landingPageClicks: Clicks to landing page.
  • companyPageClicks: Clicks to company page.
  • sends: Number of messages sent.
  • opens: Number of messages opened.