Creating the data source
Requirements
- For ad data:
- The ad accounts used must run ads for company pages (Organizations), not for personal pages
- Make sure you have the proper access to the desired ad accounts here: https://www.linkedin.com/campaignmanager/accounts
- For organic data (pages/organizations and posts):
- You must have super admin access to the organization pages
Instructions
- Access the Kondado platform and click on CREATE + > Connector > Select the LinkedIn connector
- Click Sign in with LinkedIn
- Enter your login information and click Sign in
- You will be directed to a permissions screen, where you should click Allow
- Once redirected back to the Kondado page, simply give the connector a name and save it
Pipelines
Summary
Relationship chart
Click to expand
Ad accounts
Advertising account registry summarizing status, currency, billing settings, and notification preferences.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Unique internal ID representing the account |
|
|
text |
[en] ACTIVE - Account is active; this is the default state; CANCELED - Account has been permanently canceled; DRAFT - Account is in draft status, meaning it's not yet fully set up and it is not serving; PENDING_DELETION - Denotes that the account has been requested to be deleted that is currently pending; REMOVED - Denotes that the account was deleted, but must remain fetchable due to the existence of performance data. |
|
|
text |
[en] The entity on whose behalf the account is advertised. Must either be in the format urn:li:person:{id} (for persons) or urn:li:organization:{id} (for organizations). Only organization ad accounts are supported |
|
|
boolean |
[en] Indicates if the creative contact is notified when a creative has been rejected due to content |
|
|
text |
[en] The 3 character standard currency code such as USD for United States Dollar. Note: Advertisers selecting Brazilian Real (BRL) as a currency see their account budget, advertising bids, and spend in BRL, but their account is billed in USD. |
|
|
float |
[en] Last modification timestamp stored in epoch milliseconds. |
|
|
float |
[en] Creation timestamp stored in epoch milliseconds. |
|
|
text |
[en] Human-readable name of the record. |
|
|
boolean |
[en] Indicates if the campaign contact is notified when an associated campaign has been completed |
|
|
float |
[en] Internal version number incremented every time the account is updated. |
|
|
boolean |
[en] Indicates if the campaign contact is notified about campaign optimization opportunities |
|
|
text |
[en] An array of enums with information about the account's system serving statuses. If an account is eligible for serving, then the array has a single element: RUNNABLE. Otherwise, the array contains one or more reasons why the account is not servable: STOPPED, BILLING_HOLD, ACCOUNT_TOTAL_BUDGET_HOLD, ACCOUNT_END_DATE_HOLD, RESTRICTED_HOLD |
|
|
boolean |
[en] Indicates if the creative contact is notified when a creative has been reviewed and approved |
|
|
text |
[en] Category type for the recorded item. |
Ad performance
Replication type: Incremental with update window
Parameters:
- Read start date (Savepoint): Initial date for data replication
- Update window (days): How many days previous to the savepoint the data can still be refreshed
- Accounts: Filther which accounts to be replicated or leave it empty to replicate them all
Relationships:
Ad performance metrics by account, campaign, creative, and date, including impressions, clicks, views, and spend.
| Campo | Tipo | |
|---|---|---|
|
date |
[en] Date of the metric, in UTC. |
|
|
text |
[en] Numeric identifier of the associated ad account. |
|
|
text |
||
|
text |
||
|
text |
[en] Name of the creative. |
|
|
text |
||
|
text |
[en] Numeric identifier of the campaign related to the record. |
|
|
text |
[en] Name of the campaign. |
|
|
text |
||
|
text |
||
|
text |
[en] Name of the campaign group. |
|
|
text |
[en] Value of the conversions in the accounts local currency based on rules defined by the advertiser. Conversion value is set by the advertiser at a per conversion level, and aggregated across the query time range |
|
|
float |
[en] The count of positive reactions on Sponsored Content which can capture, like, interest, praise, and other responses |
|
|
float |
[en] The count of likes. Sponsored Content only |
|
|
float |
[en] The count of opens of Sponsored Messaging ads. Sponsored Messaging ads only |
|
|
float |
[en] Total number of times users took a desired action after clicking on your ad. When conversions cannot be attributed to individual users, group level attribution or estimation may be used |
|
|
float |
[en] The number of times users shared contact info through the One Click Lead Gen for Sponsored Messaging ads. Sponsored Messaging ads only |
|
|
float |
[en] Total number of times users took a desired action after seeing your ad. When conversions cannot be attributed to individual users, group level attribution or estimation may be used |
|
|
float |
[en] The count of user interactions with the ad unit that do not fit into any other more specific category |
|
|
float |
[en] The count of follows. Sponsored Content and Follower ads only |
|
|
float |
[en] The count of leads generated through One Click Lead Gen |
|
|
float |
[en] The count of sends of Sponsored Messaging ads. Sponsored Messaging ads only |
|
|
float |
[en] This is the count of impressions for Sponsored Content and sends for Sponsored Messaging |
|
|
float |
[en] The count of comments. Sponsored Content only |
|
|
float |
[en] The count of shares. Sponsored Content only |
|
|
float |
[en] The count of chargeable clicks. Despite not charging for clicks for CPM campaigns, this field still represents those clicks for which we would otherwise charge advertisers based on objective (for example, clicks to view the landing page or company page) |
|
|
float |
[en] Total number of times users took a desired action after clicking on or seeing your ad. When conversions cannot be attributed to individual users, group level attribution or estimation may be used |
|
|
float |
[en] The count of all user interactions with the ad unit |
|
|
float |
[en] Cost in the accounts local currency based on the given date and broken down by campaign, campaign group, and creative. Cost is not adjusted for overdelivery |
|
|
float |
[en] The count of times users opened the lead form for a One Click Lead Gen campaign |
|
|
float |
[en] The count of clicks on the action button of the Sponsored Messaging ad. |
|
|
float |
[en] The count of clicks on the ad unit displayed alongside the Sponsored Messaging ad. |
|
|
float |
[en] The estimated number of unique member accounts with at least one impression. Only for non-demographic pivots and max 92-day range. |
|
|
float |
[en] Number of clicks for each card in a carousel ad. Only for non-demographic pivots. |
|
|
float |
[en] Number of impressions shown for each card in a carousel ad. Only for non-demographic pivots. |
|
|
float |
[en] Count of likes on comments. Sponsored Content only. |
|
|
float |
[en] Clicks to view the company page. |
|
|
text |
[en] Cost in USD based on pivot and time granularity. |
|
|
float |
[en] Users who reached 100% of the document ad length. |
|
|
float |
[en] Users who reached 25% of the document ad. |
|
|
float |
[en] Users who reached 50% of the document ad. |
|
|
float |
[en] Users who reached 75% of the document ad. |
|
|
float |
[en] Clicks on the download icon in supported ad formats. |
|
|
float |
[en] Users entering full screen mode on video ads. |
|
|
float |
[en] Clicks on the headline of conversation ads. |
|
|
float |
[en] Impressions for the headline of conversation ads. |
|
|
float |
[en] Clicks leading to the landing page. |
|
|
float |
[en] Indications of interest in Sponsored Messaging. |
|
|
float |
[en] Clicks to subscribe to content like newsletters. |
|
|
float |
[en] Clicks on body links in Sponsored Messaging. |
|
|
float |
[en] Leads with verified non-personal emails. |
|
|
float |
[en] Videos watched to 97-100% duration. |
|
|
float |
[en] Video views reaching 25%. |
|
|
float |
[en] Video views reaching 50%. |
|
|
float |
[en] Video playback starts. |
|
|
float |
[en] Video views reaching 75%. |
|
|
float |
[en] 2+ sec video views (50% in view) or CTA click. |
|
|
float |
[en] The number of viral clicks for each card of a carousel ad. Includes initial and subsequent card interactions. Non-demographic pivots only. |
|
|
float |
[en] The number of viral impressions shown for each card of a carousel ad. Non-demographic pivots only. |
|
|
float |
[en] The count of clicks on viral impressions. Sponsored Content only. |
|
|
float |
[en] The count of likes on comments from viral impressions for this activity. Sponsored Content only. |
|
|
float |
[en] The count of comments from viral impressions for this activity. Sponsored Content only. |
|
|
float |
[en] The count of clicks to view the company page from viral impressions. Sponsored Content only. |
|
|
float |
[en] The number of times users reached 100% of the document\u2019s length on a viral post, including those that skipped to this point. Document ads only. |
|
|
float |
[en] The number of times users reached the first quartile of the document\u2019s length on a viral post. Document ads only. |
|
|
float |
[en] The number of times users reached the second quartile of the document\u2019s length on a viral post. Document ads only. |
|
|
float |
[en] The number of times users reached the third quartile of the document\u2019s length on a viral post. Document ads only. |
|
|
float |
[en] The number of times users indicated intent to download media in a viral ad by clicking the download icon. May not result in actual downloads. |
|
|
float |
[en] The count of follows from viral impressions for this activity. Sponsored Content only. |
|
|
float |
[en] Number of times members clicked to view viral video ads in full screen. Includes mobile taps and fullscreen button. |
|
|
float |
[en] The count of viral impressions for this activity. Viral impressions are those resulting from users sharing sponsored content to their own network of connections. |
|
|
float |
[en] The count of clicks on viral impressions that directed users to the creative's landing page. Sponsored Content only. |
|
|
float |
[en] The count of likes from viral impressions for this activity. Sponsored Content only. |
|
|
float |
[en] The count of times users opened the lead form for viral impressions from a One Click Lead Gen campaign. |
|
|
float |
[en] The count of leads generated through One Click Lead Gen from viral impressions for this activity. |
|
|
float |
[en] The count of user interactions with viral impressions that do not fit into any other specific category. Sponsored Content only. |
|
|
float |
[en] The count of positive reactions on viral Sponsored Content which can capture like, interest, praise, and other responses. |
|
|
float |
[en] The count of shares from viral impressions for this activity. Sponsored Content only. |
|
|
float |
[en] The count of viral clicks to subscribe to a series, such as a newsletter. Sponsored Content only. |
|
|
float |
[en] The count of all user interactions with a viral ad unit. Sponsored Content only. |
|
|
float |
[en] The count of viral video ads that played 97\u2013100% of the video. Includes watches that skipped to this point. |
|
|
float |
[en] The count of viral video ads that played through the first quartile. Includes watches that skipped to this point. |
|
|
float |
[en] The count of viral video ads that played through the midpoint. Includes watches that skipped to this point. |
|
|
float |
[en] The count of viral video ads that were started by users. This will be the same as viralImpressions if the serving location is ON_SITE. |
|
|
float |
[en] The count of viral video ads that played through the third quartile. Includes watches that skipped to this point. |
|
|
float |
[en] A viral video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. |
Campaign metadata
This pipeline is free
Replication type: Full
Parameters:
- Accounts: Filter which accounts to be replicated or leave it empty to replicate them all
Relationships:
Campaign-level details covering budgets, objectives, targeting choices, and pacing settings.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Campaign ID |
|
|
text |
[en] Human-readable name of the record. |
|
|
text |
[en] Numeric identifier of the associated ad account. |
|
|
text |
[en] An URN identifying the intended beneficiary of the advertising campaign such as a specific company or member |
|
|
text |
[en] An ID identifying the intended beneficiary of the advertising campaign such as a specific company or member - calculated by Kondado from API field associatedEntity |
|
|
text |
[en] URN identifying the campaign group associated with the campaign |
|
|
text |
[en] ID identifying the campaign group associated with the campaign - calculated by Kondado from API field campaignGroup |
|
|
boolean |
[en] Enable Audience Expansion for the campaign provides query expansion for certain targeting criteria |
|
|
timestamp |
[en] Creation timestamp stored in epoch milliseconds. |
|
|
timestamp |
[en] Last modification timestamp stored in epoch milliseconds. |
|
|
text |
[en] *CPM*: Cost per thousand advertising impressions. If type=SPONSORED_INMAILS, cost per send (CPS) is measured as CPM x 1000; *CPC*: Cost per individual click on the associated link; *CPV*: Cost per view for video ads. |
|
|
text |
[en] *ROUND_ROBIN*: Rotate through available creatives to serve them as evenly as possible; *OPTIMIZED*: Bias selection taking into account such as expected performance. Not available for Message and Conversation Ads (type=SPONSORED_INMAILS) |
|
|
text |
[en] The ad format on campaign level. Read more: https://docs.microsoft.com/en-us/linkedin/marketing/integrations/ads/campaign-formats |
|
|
text |
[en] Locale of the campaign. An uppercase two-letter country code as defined by ISO-3166. |
|
|
text |
[en] Locale of the campaign. A lowercase two-letter language code as defined by ISO-3166. |
|
|
text |
[en] Campaign Objective type values. Read more: https://docs.microsoft.com/en-us/linkedin/marketing/integrations/ads-reporting/ad-budget-pricing-type-combinations |
|
|
boolean |
[en] Indicates whether offsite placements are enabled for the campaign. |
|
|
text |
[en] Determines how this campaign is optimized for spending. If this is not set, there is no optimization. Read more: https://docs.microsoft.com/en-us/linkedin/marketing/integrations/ads/account-structure/create-and-manage-campaigns?tabs=http#campaign-types-schema |
|
|
text |
[en] Identifies the pacing option used for the campaign. Possible values: *LIFETIME*: Lifetime pacing that optimizes campaign budget delivery throughout campaign`s lifetime |
|
|
timestamp |
[en] Scheduled date range to run associated creatives. Represents the exclusive (strictly less than) value in which to end the range. This field is optional. An unset field indicates an open range |
|
|
timestamp |
[en] Scheduled date range to run associated creatives. The start date must be non-None. Represents the inclusive (greater than or equal to) value in which to start the range |
|
|
text |
[en] Listing of values that determine whether or not a campaign may be served; unlike status, which is user-managed, the values are controlled by the service. This is a read-only field. Possible values are *RUNNABLE*: Campaign is eligible for serving; *STOPPED*: Campaign is currently not servable for reasons other than billing information, budgetary constraints, or termination dates. For instance, an campaign will be STOPPED if it has been PAUSED by the user; *ACCOUNT_TOTAL_BUDGET_HOLD*: Parent account total budget has been reached; *ACCOUNT_END_DATE_HOLD*: Parent account end date has been reached; *CAMPAIGN_START_DATE_HOLD*: Campaign start date is in the future; *CAMPAIGN_END_DATE_HOLD*: Campaign end date has been reached; *CAMPAIGN_TOTAL_BUDGET_HOLD*: Campaign total budget has been reached; *CAMPAIGN_AUDIENCE_COUNT_HOLD*: Campaign is on hold because it has an audience count lower than the threshold; *CAMPAIGN_GROUP_START_DATE_HOLD*: Campaign group start date is in the future; *CAMPAIGN_GROUP_END_DATE_HOLD*: Campaign Group end date is in the past; *CAMPAIGN_GROUP_TOTAL_BUDGET_HOLD*: Campaign group total budget has been reached; *CAMPAIGN_GROUP_STATUS_HOLD*: Campaign group status is on hold; *ACCOUNT_SERVING_HOLD*: Parent account is on hold and not eligible for serving; |
|
|
text |
[en] *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 |
|
|
boolean |
[en] Indicates whether story placements are enabled. |
|
|
boolean |
[en] Flags that the element belongs to an internal test scenario. |
|
|
float |
[en] Maximum amount to spend over the life of the campaign |
|
|
text |
[en] ISO currency code |
|
|
float |
[en] Maximum amount to spend per day |
|
|
text |
[en] ISO currency code |
|
|
text |
[en] Category type for the recorded item. |
|
|
float |
[en] Amount to bid (for manual bidding) or amount which is the target cost (for target cost bidding) per click, impression, or other event depending on the pricing model. The amount of money as a real number string. The amount should be non-negative if the bidding strategy is manual bidding or target cost bidding. The default is 0 with the currency code set to match that of the associated account |
|
|
text |
[en] Amount to bid per click, impression, or other event depending on the pricing model. The default is 0 with the currency code set to match that of the associated account. ISO currency code |
|
|
text |
[en] Each entity has a version tag associated with it. The version tag is initiated to 1 when the entity is created. Each single update to the entity increases its version tag by 1 |
Campaign group metadata
This pipeline is free
Replication type: Full
Parameters:
- Accounts: Filter which accounts to be replicated or leave it empty to replicate them all
Relationships:
Campaign group information describing objectives, scheduling, and serving controls.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Campaign Group ID |
|
|
text |
[en] URN identifying the advertising account associated with the Campaign Group |
|
|
text |
[en] Numeric identifier of the associated ad account. |
|
|
boolean |
[en] Flag that denotes whether the Campaign Group was created organically or was created to backfill existing campaigns. This is a system controlled field |
|
|
timestamp |
[en] Creation timestamp stored in epoch milliseconds. |
|
|
timestamp |
[en] Last modification timestamp stored in epoch milliseconds. |
|
|
text |
[en] Human-readable name of the record. |
|
|
timestamp |
[en] Represents the inclusive (greater than or equal to) value in which to start the range. This field is mandatory |
|
|
timestamp |
[en] Scheduled date range to run associated objects. The start date must be non-None. Represents the exclusive (strictly less than) value in which to end the range. This field is optional. An unset field here indicates an open range |
|
|
text |
[en] Listing of values that determine whether or not a campaign within the campaign group may be served; unlike status, which is user-managed, the values are controlled by the service. This is a read-only field. Possible values are: *RUNNABLE*: Campaign group is currently active. Billing information, budgetary constraints, or start and end dates are valid; *STOPPED*: Campaign group is currently not eligible for serving for reasons other than billing information, budgetary constraints, or termination dates. For instance, a campaign group will be STOPPED if it has been canceled by the user, or it is marked as spam; *BILLING_HOLD*: Parent account is on billing hold; *ACCOUNT_TOTAL_BUDGET_HOLD*: Parent account total budget has been reached; *ACCOUNT_END_DATE_HOLD*: Parent account end date has been reached; *CAMPAIGN_GROUP_TOTAL_BUDGET_HOLD*: Campaign group total budget has been reached; *CAMPAIGN_GROUP_START_DATE_HOLD*: Campaign group start date is in the future; *CAMPAIGN_GROUP_END_DATE_HOLD*: Campaign group end date has been reached |
|
|
text |
[en] *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; *CANCELED*: Denotes that the Campaign Group has been permanently canceled and cannot be reactivated; *DRAFT*: Denotes 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 |
|
|
boolean |
[en] Flags that the element belongs to an internal test scenario. |
Conversion details
Replication type: Full
Parameters:
- Accounts: Filter which accounts to be replicated or leave it empty to replicate them all
Relationships:
Main object
Catalog of conversion rules with settings such as attribution windows, type, and expected values.
| Campo | Tipo | |
|---|---|---|
|
float |
||
|
text |
[en] Numeric identifier of the associated ad account. |
|
|
text |
[en] URN reference of the associated ad account. |
|
|
text |
[en] Attribution type assigned to the conversion. |
|
|
text |
[en] Image pixel URN associated with the conversion tracking. |
|
|
text |
[en] Unique identifier for the record. |
|
|
text |
[en] Human-readable name of the record. |
|
|
float |
[en] Timestamp when the record was created. |
|
|
float |
[en] Timestamp when the record was last modified. |
|
|
boolean |
[en] Indicates whether the item is enabled. |
|
|
text |
[en] Currency code applied to the attributed value. |
|
|
float |
[en] Numeric amount associated with the conversion. |
|
|
float |
[en] Window in days considered for post-click attribution. |
|
|
float |
[en] Window in days considered for view-through attribution. |
|
|
text |
[en] Category type for the recorded item. |
linkedin_conversion_metadata__associatedCampaigns
Links between conversion rules and the campaigns connected to them.
| Campo | Tipo | |
|---|---|---|
|
text |
||
|
float |
[en] Timestamp when the campaign was associated with the conversion rule. |
|
|
text |
[en] URN of the conversion linked to the campaign. |
|
|
text |
[en] URN of the associated campaign. |
Conversion performance
Replication type: Incremental with update window
Parameters:
- Read start date (Savepoint): Initial date for data replication
- Update window (days): How many days previous to the savepoint the data can still be refreshed
- Accounts: Filther which accounts to be replicated or leave it empty to replicate them all
Relationships:
Attributed conversion results by rule, campaign, account, and date, including completed events, value, and cost indicators.
| Campo | Tipo | |
|---|---|---|
|
date |
[en] Date of the metric, in UTC. |
|
|
text |
[en] Value of the conversions in the accoun`s local currency based on rules defined by the advertiser. Conversion value is set by the advertiser at a per conversion level, and aggregated across the query time range. |
|
|
text |
[en] Numeric identifier of the associated ad account. |
|
|
float |
[en] The count of post-view conversions that are attributed to your ads driven by a viral impression |
|
|
float |
[en] The count of post-click conversions that are attributed to your ads driven by a viral click |
|
|
float |
[en] The count of post-view conversions that are attributed to your ads driven by a viral impression |
|
|
text |
||
|
text |
[en] Numeric identifier of the campaign related to the record. |
|
|
text |
[en] Name of the campaign. |
|
|
text |
||
|
text |
||
|
float |
[en] The count of conversions that are attributed to your ads driven by a viral event |
|
|
float |
[en] The count of post-click conversions that are attributed to your ads driven by a viral click |
|
|
float |
[en] Total number of times users took a desired action after clicking on or seeing your ad. When conversions cannot be attributed to individual users, group level attribution or estimation may be used |
|
|
text |
||
|
text |
||
|
text |
[en] Name of the creative. |
|
|
float |
[en] The count of clicks on the action button of the Sponsored Messaging ad. |
|
|
float |
[en] The count of clicks on the ad unit displayed alongside the Sponsored Messaging ad. |
|
|
float |
[en] The estimated number of unique member accounts with at least one impression. Only for non-demographic pivots and max 92-day range. |
|
|
float |
[en] Number of clicks for each card in a carousel ad. Only for non-demographic pivots. |
|
|
float |
[en] Number of impressions shown for each card in a carousel ad. Only for non-demographic pivots. |
|
|
float |
[en] Count of likes on comments. Sponsored Content only. |
|
|
float |
[en] Clicks to view the company page. |
|
|
text |
[en] Cost in USD based on pivot and time granularity. |
|
|
float |
[en] Users who reached 100% of the document ad length. |
|
|
float |
[en] Users who reached 25% of the document ad. |
|
|
float |
[en] Users who reached 50% of the document ad. |
|
|
float |
[en] Users who reached 75% of the document ad. |
|
|
float |
[en] Clicks on the download icon in supported ad formats. |
|
|
float |
[en] Users entering full screen mode on video ads. |
|
|
float |
[en] Clicks on the headline of conversation ads. |
|
|
float |
[en] Impressions for the headline of conversation ads. |
|
|
float |
[en] Clicks leading to the landing page. |
|
|
float |
[en] Indications of interest in Sponsored Messaging. |
|
|
float |
[en] Clicks to subscribe to content like newsletters. |
|
|
float |
[en] Clicks on body links in Sponsored Messaging. |
|
|
float |
[en] Leads with verified non-personal emails. |
|
|
float |
[en] Videos watched to 97-100% duration. |
|
|
float |
[en] Video views reaching 25%. |
|
|
float |
[en] Video views reaching 50%. |
|
|
float |
[en] Video playback starts. |
|
|
float |
[en] Video views reaching 75%. |
|
|
float |
[en] 2+ sec video views (50% in view) or CTA click. |
|
|
float |
[en] The number of viral clicks for each card of a carousel ad. Includes initial and subsequent card interactions. Non-demographic pivots only. |
|
|
float |
[en] The number of viral impressions shown for each card of a carousel ad. Non-demographic pivots only. |
|
|
float |
[en] The count of clicks on viral impressions. Sponsored Content only. |
|
|
float |
[en] The count of likes on comments from viral impressions for this activity. Sponsored Content only. |
|
|
float |
[en] The count of comments from viral impressions for this activity. Sponsored Content only. |
|
|
float |
[en] The count of clicks to view the company page from viral impressions. Sponsored Content only. |
|
|
float |
[en] The number of times users reached 100% of the document\u2019s length on a viral post, including those that skipped to this point. Document ads only. |
|
|
float |
[en] The number of times users reached the first quartile of the document\u2019s length on a viral post. Document ads only. |
|
|
float |
[en] The number of times users reached the second quartile of the document\u2019s length on a viral post. Document ads only. |
|
|
float |
[en] The number of times users reached the third quartile of the document\u2019s length on a viral post. Document ads only. |
|
|
float |
[en] The number of times users indicated intent to download media in a viral ad by clicking the download icon. May not result in actual downloads. |
|
|
float |
[en] The count of follows from viral impressions for this activity. Sponsored Content only. |
|
|
float |
[en] Number of times members clicked to view viral video ads in full screen. Includes mobile taps and fullscreen button. |
|
|
float |
[en] The count of viral impressions for this activity. Viral impressions are those resulting from users sharing sponsored content to their own network of connections. |
|
|
float |
[en] The count of clicks on viral impressions that directed users to the creative's landing page. Sponsored Content only. |
|
|
float |
[en] The count of likes from viral impressions for this activity. Sponsored Content only. |
|
|
float |
[en] The count of times users opened the lead form for viral impressions from a One Click Lead Gen campaign. |
|
|
float |
[en] The count of leads generated through One Click Lead Gen from viral impressions for this activity. |
|
|
float |
[en] The count of user interactions with viral impressions that do not fit into any other specific category. Sponsored Content only. |
|
|
float |
[en] The count of positive reactions on viral Sponsored Content which can capture like, interest, praise, and other responses. |
|
|
float |
[en] The count of shares from viral impressions for this activity. Sponsored Content only. |
|
|
float |
[en] The count of viral clicks to subscribe to a series, such as a newsletter. Sponsored Content only. |
|
|
float |
[en] The count of all user interactions with a viral ad unit. Sponsored Content only. |
|
|
float |
[en] The count of viral video ads that played 97\u2013100% of the video. Includes watches that skipped to this point. |
|
|
float |
[en] The count of viral video ads that played through the first quartile. Includes watches that skipped to this point. |
|
|
float |
[en] The count of viral video ads that played through the midpoint. Includes watches that skipped to this point. |
|
|
float |
[en] The count of viral video ads that were started by users. This will be the same as viralImpressions if the serving location is ON_SITE. |
|
|
float |
[en] The count of viral video ads that played through the third quartile. Includes watches that skipped to this point. |
|
|
float |
[en] A viral video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. |
Creative metadata
This pipeline is free
Replication type: Full
Parameters:
- Accounts: Filter which accounts to be replicated or leave it empty to replicate them all
Relationships:
Creative records for ads including format, rendered message, and serving status.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Unique ID for a creative |
|
|
text |
[en] Human-readable name of the record. |
|
|
text |
[en] Numeric identifier of the associated ad account. |
|
|
text |
[en] URN reference of the associated ad account. |
|
|
text |
[en] URN of the campaign related to the record. |
|
|
text |
[en] Numeric identifier of the campaign related to the record. |
|
|
timestamp |
[en] Creation time |
|
|
timestamp |
[en] Time at which the creative was last modified |
|
|
text |
[en] A reference URN for this object to an external system, with semantics varying based on the creative type. SSU creative must contain a valid activity/share reference. If the activity/share has an associated company actor, it must match the parent campaign`s reference. SSU creative reference cannot be modified after creation. Reference is not applicable and is not set for text ad creative |
|
|
text |
[en] Creative review status. The review is absent (None) when the creative is in DRAFT state |
|
|
boolean |
[en] This indicates whether the creative is currently being served or not |
|
|
text |
[en] Creative user intended status. The creative intended status is set independently from parent entity status, but parent entity status overrides creative intended status in effect. For example, parent entity status may be PAUSED while creative status is ACTIVE, in which case the creative`s effective status is PAUSED, and not served. [ACTIVE] - Creative development is complete and the creative is available for review and can be served; [PAUSED] - Creative development is complete and the creative is current, but should temporarily not be served; [DRAFT] - Creative development is incomplete and may still be edited; [ARCHIVED] - Creative development is complete, but creative should not be served and should be separated from non-archived creatives in any UI; [CANCELLED] - The creative is permanently cancelled; [PENDING_DELETION] - Denotes that the creative has been requested to be deleted that is currently pending; [REMOVED] - Denotes that the creative was deleted, but must remain fetchable due to the existence of performance data. |
|
|
boolean |
[en] Indicates whether the item belongs to a test context. |
Organization pages
Due to LinkedIn API limitations, the maximum query period for daily statistics data is 1 year (365 days). This integration only supports company pages, not showcases
The download and display links for images and videos expire after being accessed. Therefore, you can also use this integration with full replication. In this case, the savepoint and update window parameters will have no effect
Replication type: Incremental
Parameters:
- Organizations: Filter the organizations or leave it empty to read all
- Period: The period breakdown
Daily time series of organization page statistics showing views, followers, and engagement by date.
| Campo | Tipo | |
|---|---|---|
|
date |
[en] Date of the metric, in UTC. |
|
|
text |
[en] URN of the related organization. |
|
|
text |
[en] Name of the related organization. |
|
|
float |
[en] Organic follower gain for the period. |
|
|
float |
[en] Paid follower gain for the period. |
|
|
float |
[en] Number of unique impressions |
|
|
float |
[en] Number of shares |
|
|
float |
[en] Number of organic clicks, likes, comments, and shares over impressions |
|
|
float |
[en] Number of clicks |
|
|
float |
[en] Number of likes. This field can become negative when members who liked a sponsored share later unlike it. The like is not counted since it is not organic, but the unlike is counted as organic |
|
|
float |
[en] Number of impressions |
|
|
float |
[en] Number of comments |
|
|
float |
[en] Custom button clicks on mobile. |
|
|
float |
[en] Custom button clicks on desktop. |
|
|
float |
[en] Job clicks on the Careers page on mobile. |
|
|
float |
[en] Promo link clicks on the Careers page on mobile. |
|
|
float |
[en] Featured employee clicks on the Careers page on mobile. |
|
|
float |
[en] Promo link clicks on the Careers page (all platforms). |
|
|
float |
[en] Banner promo clicks on the Careers page. |
|
|
float |
[en] Job clicks on the Careers page (all platforms). |
|
|
float |
[en] Featured employee clicks on the Careers page (all platforms). |
|
|
float |
[en] Page views of the Products page on mobile. |
|
|
float |
[en] Unique page views of the Products page on mobile. |
|
|
float |
[en] Total page views on desktop across all sections. |
|
|
float |
[en] Total unique page views on desktop across all sections. |
|
|
float |
[en] Page views of the Insights page. |
|
|
float |
[en] Unique page views of the Insights page. |
|
|
float |
[en] Page views of the About page on mobile. |
|
|
float |
[en] Unique page views of the About page on mobile. |
|
|
float |
[en] Total page views on mobile across all sections. |
|
|
float |
[en] Total unique page views on mobile across all sections. |
|
|
float |
[en] Page views of the Products page on desktop. |
|
|
float |
[en] Unique page views of the Products page on desktop. |
|
|
float |
[en] Page views of the Products page. |
|
|
float |
[en] Unique page views of the Products page. |
|
|
float |
[en] Page views of the Jobs page. |
|
|
float |
[en] Unique page views of the Jobs page. |
|
|
float |
[en] Page views of the People page. |
|
|
float |
[en] Unique page views of the People page. |
|
|
float |
[en] Page views of the Overview page. |
|
|
float |
[en] Unique page views of the Overview page. |
|
|
float |
[en] Page views of the Overview page on mobile. |
|
|
float |
[en] Unique page views of the Overview page on mobile. |
|
|
float |
[en] Page views of the Life at Company page. |
|
|
float |
[en] Unique page views of the Life at Company page. |
|
|
float |
[en] Page views of the Overview page on desktop. |
|
|
float |
[en] Unique page views of the Overview page on desktop. |
|
|
float |
[en] Page views of the Careers page on mobile. |
|
|
float |
[en] Unique page views of the Careers page on mobile. |
|
|
float |
[en] Total page views for the organization (all sources). |
|
|
float |
[en] Total unique page views for the organization (all sources). |
|
|
float |
[en] Page views of the Jobs page on mobile. |
|
|
float |
[en] Unique page views of the Jobs page on mobile. |
|
|
float |
[en] Page views of the Careers page. |
|
|
float |
[en] Unique page views of the Careers page. |
|
|
float |
[en] Page views of the Life at Company page on mobile. |
|
|
float |
[en] Unique page views of the Life at Company page on mobile. |
|
|
float |
[en] Page views of the Jobs page on desktop. |
|
|
float |
[en] Unique page views of the Jobs page on desktop. |
|
|
float |
[en] Page views of the People page on desktop. |
|
|
float |
[en] Unique page views of the People page on desktop. |
|
|
float |
[en] Page views of the About page. |
|
|
float |
[en] Unique page views of the About page. |
|
|
float |
[en] Page views of the About page on desktop. |
|
|
float |
[en] Unique page views of the About page on desktop. |
|
|
float |
[en] Page views of the People page on mobile. |
|
|
float |
[en] Unique page views of the People page on mobile. |
|
|
float |
[en] Page views of the Insights page on desktop. |
|
|
float |
[en] Unique page views of the Insights page on desktop. |
|
|
float |
[en] Page views of the Careers page on desktop. |
|
|
float |
[en] Unique page views of the Careers page on desktop. |
|
|
float |
[en] Page views of the Life at Company page on desktop. |
|
|
float |
[en] Unique page views of the Life at Company page on desktop. |
|
|
float |
[en] Page views of the Insights page on mobile. |
|
|
float |
[en] Unique page views of the Insights page on mobile. |
Organization posts
Due to LinkedIn API limitations, the maximum query period for data is 1 year (365 days) for the daily period. Therefore, when creating your integration, this will be the initial savepoint. This integration only supports company pages, not showcases
Replication type: Incremental with update window
Parameters:
- Read start date (Savepoint): The initial date to replicate data
- Update window (days): How many days previous to the post update their data can still be replicated
- Keep metrics history: Indicates whether a daily history of main table (with post statistics) should be stored. Track it through the metric_date field
- Organizations: Filter the organizations to be replicated or leave it empty to use all
Relationships:
Main object
Organization posts with content metadata and lifetime engagement metrics.
| Campo | Tipo | |
|---|---|---|
|
date |
[en] Date on which the data was read (UTC). Available only if the pipeline is configured to keep history |
|
|
text |
[en] Unique identifier for the record. |
|
|
text |
[en] URN of the related organization. |
|
|
text |
[en] The state of the content. The following values can be returned in responses: DRAFT - Represents content that is accessible only to the author and is not yet published; PUBLISHED - Represents content that is accessible to all entities. This is the only accepted field during creation; PUBLISH_REQUESTED - Represents content that has been submitted for publishing but is not yet ready for rendering; PUBLISH_FAILED - Represents content that has been submitted for publishing but was not processed. An edit is required in order to re-attempt publishing; |
|
|
text |
[en] Visibility restrictions on content. Type of MemberNetworkVisibility which has the values of: CONNECTIONS - Represents 1st degree network of owner. PUBLIC - Anyone can view this. LOGGED_IN - Viewable by logged in members only. CONTAINER - Visibility is delegated to the owner of the container entity. For example, posts within a group are delegated to the groups authorization API for visibility authorization. |
|
|
timestamp |
[en] The time at which this content was published |
|
|
timestamp |
[en] Time at which the resource was last modified |
|
|
text |
[en] Specifies the feeds distributed to within LinkedIn. NONE-Do not distribute within LinkedIn via feed. MAIN_FEED-Distribute to the flagship feed, and container entity feed if applicable |
|
|
text |
[en] The user generated commentary for the post |
|
|
boolean |
[en] Indicates whether the author edited the content after publishing. |
|
|
text |
[en] The content type of the post, based on https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/posts-api?view=li-lms-2023-11&tabs=curl#content [Calculated by Kondado and added of other event types]. Can be: text, media_image, media_video, media_other, poll, multi_image, article, carousel, job, liveVideo, event, unknown |
|
|
text |
[en] If content_type is media_image or media_video, shows the media URN |
|
|
text |
[en] If content_type is media_image or media_video, shows the media title (if provided) |
|
|
text |
[en] If content_type is media_image, shows the media URL. Requires the user to have permissions to read images [ https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/images-api?view=li-lms-2023-02&tabs=http#permissions ]. Empty if the user doens`t have enough permissions. The download URL expires, so if you need it to always be refreshed, use integral replication for the pipeline |
|
|
text |
[en] [Present if content_type=media_image and user has permission to read images https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/images-api?view=li-lms-2023-02&tabs=http#permissions] The URN of the entity that owns this asset. It can be a person(urn:li:person:123), organization(urn:li:organization:123) or sponsoredAccount(urn:li:sponsoredAccount:123) URN |
|
|
timestamp |
[en] [Present if content_type=media_image and user has permission to read images https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/images-api?view=li-lms-2023-02&tabs=http#permissions] Shows when content_media_image_download_url expires. If not present, it might never expire but there`s no guarantee. Unless the use case has a security+legal exception, all URLs have an expiration time. If they don't, they can still expire because URLs are signed, and the sign keys might be rotated. If a non expiring URL was signed with a key that gets invalidated, it essentially expires |
|
|
text |
[en] [Present if content_type=media_image] PROCESSING Asset is processing to generate missing artifacts. PROCESSING_FAILED - Processing failed due to client error such as file size too large, unsupported file format, internal error (e.g., performance issue, database error, network failure), or other issue. AVAILABLE - All of the recipe`s required artifacts are ready. The asset is available to be served. WAITING_UPLOAD Waiting for client to upload source file or uploading process to be completed. FORBIDDEN - The asset could not be read due to user`s lacking permissions |
|
|
float |
[en] [Present if content_type=media_video and user has permission to read videos https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/videos-api?view=li-lms-2023-02&tabs=http#permissions] The length of the video in milliseconds. It is empty if the media asset isn`t available, failed processing, or there is another issue. |
|
|
float |
[en] [Present if content_type=media_video and user has permission to read videos https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/videos-api?view=li-lms-2023-02&tabs=http#permissions] Aspect ratio width of the media. For media with a 16:9 ratio, it is 16. There might be decimal values for high density displays for a greater degree of precision. aspectRatioHeight and aspectRatioWidth would either both be present or both be None. It is empty if the media asset isn't available, failed processing, or there is another issue |
|
|
float |
[en] [Present if content_type=media_video and user has permission to read videos https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/videos-api?view=li-lms-2023-02&tabs=http#permissions] Media aspect ratio height. For media with a 16:9 ratio, it is a 9. There might be decimal values for high density displays for a greater degree of precision. aspectRatioHeight and aspectRatioWidth would either both be present or both be None. It is empty if the media asset isn't available, failed processing, or there is another issue |
|
|
text |
[en] [Present if content_type=media_video and user has permission to read videos https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/videos-api?view=li-lms-2023-02&tabs=http#permissions] URL to retrieve the thumbnail file. This URL expires. So use integral replication if you need it to be available more often |
|
|
text |
[en] [Present if content_type=media_video and user has permission to read videos https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/videos-api?view=li-lms-2023-02&tabs=http#permissions] Public URL to download/view the media asset. It will be empty if the media asset isn't available, failed processing, or there is another issue. This URL expires. So use integral replication if you need it to be available more often |
|
|
timestamp |
[en] [Present if content_type=media_video and user has permission to read videos https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/videos-api?view=li-lms-2023-02&tabs=http#permissions] when the identifier expires. If it is not present, it may never expire. Unless the use case has a security and legal exception, all URLs have an expiration time. If they don't, they can still expire because URLs are signed, and the sign keys may be rotated. If a non expiring URL was signed with a key that gets invalidated, it expires |
|
|
text |
[en] [Present if content_type=media_video and user has permission to read videos https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/videos-api?view=li-lms-2023-02&tabs=http#permissions] URN of the entity that owns this asset. Can be a person(urn:li:person:123), or organization(urn:li:organization:123) URN |
|
|
text |
[en] [Present if content_type=media_video] PROCESSING Asset is processing to generate missing artifacts. PROCESSING_FAILED Processing failed due to client error such as file size too large, unsupported file format, internal error (e.g., performance issue, database error, network failure), or other issue. AVAILABLE All of the recipe's required artifacts are ready. The asset is available to be served. WAITING_UPLOAD Waiting for client to upload source file or uploading process to be completed. FORBIDDEN: video info not be fetched due to lack of permissions (https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/videos-api?view=li-lms-2023-02&tabs=http#permissions) |
|
|
text |
[en] [Present if content_type=poll] The selection type of votes on the poll. SINGLE_VOTE - Single-select vote. MULTIPLE_VOTE - Multiple-select vote (To be supported later in future) |
|
|
text |
[en] [Present if content_type=poll] Duration of poll being open for votes. It will close after the specified duration from creation time: ONE_DAY - Poll is open for 1 day; THREE_DAYS - Poll is open for 3 days; SEVEN_DAYS - Poll is open for 7 days; FOURTEEN_DAYS - Poll is open for 14 days |
|
|
boolean |
[en] [Present if content_type=poll] Poll author’s visibility to voters. Defaults to TRUE. Currently, FALSE is not supported |
|
|
float |
[en] [Present if content_type=poll] Number of unique voters on the poll |
|
|
text |
[en] [Present if content_type=poll] Question for the poll |
|
|
text |
[en] [Present if content_type=article] Custom or saved description of the article. If empty, there is none |
|
|
text |
[en] [Present if content_type=article] Custom or saved title of the article |
|
|
text |
[en] [Present if content_type=article] A URL of the article. Typically the URL that was ingested to maintain URL parameters. |
|
|
text |
[en] [Present if content_type=article] Alt text for the custom thumbnail. If empty, there is none |
|
|
text |
[en] [Present if content_type=article] Custom or saved thumbnail for the article. If empty, there is none |
|
|
text |
[en] [Present if content_type=article] Image of the thumbnail. Requires the user to have permissions to read images [ https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/images-api?view=li-lms-2023-02&tabs=http#permissions ]. Empty if the user doens`t have enough permissions. The download URL expires, so if you need it to always be refreshed, use integral replication for the pipeline |
|
|
float |
[en] Lifetime number of unique impressions |
|
|
float |
[en] Lifetime number of shares |
|
|
float |
[en] Lifetime number of organic clicks, likes, comments, and shares over impressions |
|
|
float |
[en] Lifetime number of clicks |
|
|
float |
[en] Lifetime number of likes. This field can become negative when members who liked a sponsored share later unlike it. The like is not counted since it is not organic, but the unlike is counted as organic |
|
|
float |
[en] Lifetime number of impressions |
|
|
float |
[en] Lifetime number of comments |
linkedin_posts_hashtags
Hashtags associated with each organization post.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Unique identifier for the record. |
|
|
text |
[en] URN of the related organization. |
|
|
text |
[en] The hashtag |
linkedin_posts_commentary_mentions
Mentions captured from post commentary text, identifying tagged entities.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Unique identifier for the record. |
|
|
text |
[en] URN of the related organization. |
|
|
text |
[en] Text to be rendered and displayed |
|
|
text |
[en] URN representing the entity to be mentioned. Can be a Person or Organization URN |
linkedin_posts_poll_options
Poll options from organization posts with display text, vote counts, and interaction indicators.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Unique identifier for the record. |
|
|
text |
[en] URN of the related organization. |
|
|
text |
[en] [Available if content_type = poll] Text describing the option |
|
|
boolean |
[en] [Available if content_type = poll] Whether the viewer [data source user] voted this poll option |
|
|
float |
[en] [Available if content_type = poll] Vote counts of the poll option. Missing if the viewer [data source user] of the poll is not allowed to view votes count on individual options based on visibility rules (e.g. viewer has not already voted on the poll) |
linkedin_posts_carousel_cards
Published carousel cards with title, description, links, and related media assets.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Unique identifier for the record. |
|
|
text |
[en] URN of the related organization. |
|
|
text |
[en] [Available if content_type = carousel] The web page that can be associated with the content and is opened when the member clicks on the content. For example, if the content is an image and the landing page is a web page then clicking on the image will take the member to the web page. If empty, then there is no landing page associated with the content |
|
|
text |
[en] [Available if content_type = carousel] The id of the media contained in the card |
|
|
text |
[en] [Available if content_type = carousel] The title of the media contained in the card |
|
|
text |
[en] [Available if content_type = carousel] Url to view the media contained in the card. Requires the user to have permissions to read images [ https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/images-api?view=li-lms-2023-02&tabs=http#permissions ]. Empty if the user doens`t have enough permissions. The download URL expires, so if you need it to always be refreshed, use integral replication for the pipeline |
linkedin_posts_content_multi_image
Additional images used in multi-image posts, providing URLs, status, and metadata for each asset.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Unique identifier for the record. |
|
|
text |
[en] URN of the related organization. |
|
|
text |
[en] If content_type is multi_image, shows the image_id |
|
|
text |
[en] If content_type is multi_image, shows the image title (if provided) |
|
|
text |
[en] If content_type is multi_image, shows the media URL. Requires the user to have permissions to read images [ https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/images-api?view=li-lms-2023-02&tabs=http#permissions ]. Empty if the user doens`t have enough permissions. The download URL expires, so if you need it to always be refreshed, use integral replication for the pipeline |
|
|
text |
[en] [Present if content_type=multi_image and user has permission to read images https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/images-api?view=li-lms-2023-02&tabs=http#permissions] The URN of the entity that owns this asset. It can be a person(urn:li:person:123), organization(urn:li:organization:123) or sponsoredAccount(urn:li:sponsoredAccount:123) URN |
|
|
timestamp |
[en] [Present if content_type=multi_image and user has permission to read images https://learn.microsoft.com/en-us/linkedin/marketing/integrations/community-management/shares/images-api?view=li-lms-2023-02&tabs=http#permissions] Shows when content_media_image_download_url expires. If not present, it might never expire but there`s no guarantee. Unless the use case has a security+legal exception, all URLs have an expiration time. If they don't, they can still expire because URLs are signed, and the sign keys might be rotated. If a non expiring URL was signed with a key that gets invalidated, it essentially expires |
|
|
text |
[en] [Present if content_type=multi_image] PROCESSING Asset is processing to generate missing artifacts. PROCESSING_FAILED - Processing failed due to client error such as file size too large, unsupported file format, internal error (e.g., performance issue, database error, network failure), or other issue. AVAILABLE - All of the recipe`s required artifacts are ready. The asset is available to be served. WAITING_UPLOAD Waiting for client to upload source file or uploading process to be completed. FORBIDDEN - The asset could not be read due to user`s lacking permissions |
Notes
- Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information


