LinkedIn Ads Data Export

What is LinkedIn Ads?

With LinkedIn Advertising Insights, you can track statistics about your campaigns using selected metrics that matter to you. Running performance reports gained from tracking statistics will help you make informed choices about advertising spend, ad and campaign performance.

How to add a LinkedIn Ads Source in Electrik.AI?

Follow these steps to connect your LinkedIn Ads account to Electrik.AI

Step 1: Ensure you have following prerequisites to create a LinkedIn Ads Connection in Electrik.AI

a. LinkedIn Ads Account User Id & Password.

Step 2: Sign-in into your Electrik.AI account.

Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard

Step 4: Select the Connections tab in the left most navigation bar & click on “Add” action button.

Select-the-Connections-tab-in-the-left-most-navigation-bar-click-on-Add-action-

Step 5: The Source default tab is selected just click on “LinkedIn Ads” connection.

Conn Step 5 The Source default tab is selected just click on “LinkedIn Pages” connection.

Step 6: Enter your LinkedIn Ads User Id and Password.

Step 6 Enter your LinkedIn Ads User Id and Password.

Step 7: Allow Electrik.AI to access your LinkedIn Ads account.

Step 7 Allow Electrik.AI to access your LinkedIn Ads account-ElectrikAI

Step 8: Select the LinkedIn Ads Account from the dropdown whose data you wish to export.

Step 9: Click on Save button on the top.

Conn Step 9 Click on Save button on the top.

Congratulations, you have now successfully created a LinkedIn Ads Connection in Electrik.AI.

Conn Congratulations, you have now successfully created a LinkedIn Ads Connection in Electrik.AI.

What are the supported Data Destinations?

Electrik.AI supports the following databases to export LinkedIn Ads Data. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI

How to export LinkedIn Ads Data?

Electrik.AI creates a data flow (or ETL process) that exports LinkedIn Ads Performance reports of your choice to a target database or data warehouse. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from LinkedIn Ads to Database

Step 1: Ensure you have the following prerequisites.
1. Access to LinkedIn Ads.
2. LinkedIn Ads Account User Id and Password.
3. Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)
4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password.
Step 2: Sign-in into your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard.

Step 4: Click on Add button to create a LinkedIn Ads Performance Data Extractor Flow.

Click on Add button to create a Flow

Step 5: Select LinkedIn Ads Connection present in the list of available sources.

Flow Step 5 Select LinkedIn Ads Connection present in the list of available sources.

Step 6: Select your existing LinkedIn Ads connection in Electrik.AI.

Flow Step 6 Select your existing LinkedIn Ads connection in Electrik.AI.

To Configure a new connection, refer to this link.

Step 7: Click on a destination of your choice from list of available destinations.
In this example we are choosing BigQuery.

Flow Step 7 Click on a destination of your choice from list of available destinations.

Step 8: Select your existing BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this link.

Flow Step 8 Select your existing BigQuery connection in Electrik.AI.

Step 9:
a. Choose the desired report to get the appropriate data. In this example we are choosing Account Performance.

Step 9a

b. Review the Data Source, Data Destination, Data Set, Report Name, Provide Success Notification Email, Failure Notification Email.
Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.
c. Click “Save and Proceed” to continue.

Step 9b

Note: By Default, Electrik.AI chooses an existing Data Set to load your LinkedIn Ads Report. You can create a new Dataset in your bucket by selecting the “Create Data Set” radio button.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

Flow Step 10 Please wait while you are redirected to Flow Details Screen.

Congratulations, you have now successfully setup LinkedIn Ads Performance Report to BigQuery flow in Electrik.AI.

Congratulations, you have now successfully setup LinkedIn Account Performance Report to BigQuery flow in Electrik.AI.

Your LinkedIn Ads data will start loading after 24 hours in your Data Set.

New-Your LinkedIn Ads data will start loading after 24 hours in your

LinkedIn Ads Data Schema

IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionaccount_idAccount Id505966632
2MetricactionclicksThe count of clicks on the action button of the Sponsored InMail.0
3Dimensionad_idAd Id91511174
4MetricadunitclicksThe count of clicks on the ad unit displayed alongside the Sponsored InMail.0
5Metricapproximateuni queimpressionsThe approximate reach of the campaign. The number of instances where a unique user viewed LinkedIn ad
6MetriccardclicksThe number of clicks for each card of a carousel ad.0
7MetriccardimpressionsThe number of impressions shown for each card of a carousel ad.0
8MetricclicksThe count of chargeable clicks, for example, clicks to view the landing page or company page0
9MetriccommentlikesThe count of likes of a comment.0
10MetriccommentsThe count of comments.0
11MetriccompanypageclicksThe count of clicks to view the company page.0
12Metricconversionvalu einlocalcurrencyValue of the conversions in the account’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.0
13Metriccostinlo calcurrencyCost in the account’s local currency based on the pivot and time Granularity. For example, this would be spend by member company size per month if the pivot is MEMBER_COMPANY_SIZE and timeGranularity is MONTHLY.0
14MetriccostinusdCost in USD based on the pivot and time Granularity. For example, this would be spend by campaign on a given day if the pivot is CAMPAIGN and time Granularity is DAILY.0
15Metricexternal websiteconversionsThe count of conversions indicated by pixel loads on an external advertiser website.0
16Metricexternalwebsite postclickconversionsThe count of post-click conversions indicated by pixel loads on an external advertiser website.0
17Metricexternalwebsitepost viewconversionsThe count of post-view conversions indicated by pixel loads on an external advertiser website.0
18MetricfollowsThe count of follows.0
19MetricfullscreenplaysThe count of taps on the video, going into video view mode.0
20MetricimpressionsThis is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.88
21MetriclandingpageclicksThe count of clicks which take the user to the creative landing page.0
22Metricleadgenerationmail contactinfosharesThe number of times users shared contact info through the One Click Lead Gen for Sponsored InMail.0
23Metricleadgeneration mailinterested clicksThe count of InMail recipients who clicked to demonstrate interest.0
24MetriclikesThe count of likes.0
25Metriconeclick leadformopensThe count of times users opened the lead form for a One Click Lead Gen campaign.0
26MetriconeclickleadsThe count of leads generated through One Click Lead Gen.0
27MetricopensThe count of opens of Sponsored InMail.0
28Metricother engagementsThe count of user interactions with the ad unit that do not fit into any other more specific category.0
29DimensionpivotPivot
30DimensionpivotvaluePivot Valueurn:li:spon soredCreative:91511174
31DimensionpivotvaluesThe value of the pivots for a specific record returned. For example, supplying pivots of CREATIVE and CONVERSION results in a list of records, one for each creative/conversion combination. The pivotValues contain serialized URNs for the specific
creative and conversion for a record.
[urn:li:sponsored Creative:91511174]
32MetricreactionsThe count of positive reactions on Sponsored Updates which can capture, like, interest, praise, and other responses.0
33MetricsendsThe count of sends of Sponsored InMail.0
34MetricsharesThe count of shares.0
35Metricsnapshot_dtSnapshot Date23-08-2020
36MetrictexturlclicksThe count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail.0
37Metrictotal engagementsThe count of all user interactions with the ad unit.0
38MetricvideocompletionsThe count of video ads that played 97-100% of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
39Metricvideofirst quartilecompletionsThe count of video ads that played through the first quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
40Metricvideomidpoint completionsThe count of video ads that played through the midpoint of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
41MetricvideostartsThe count of video ads that were started by users.0
42Metricvideothird quartilecompletionsThe count of video ads that played through the third quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
43MetricvideoviewsA video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to fullscreen mode) does not count as a view.0
44Metricviralca rdclicksThe number of viralClicks for each card of a carousel ad. The first viralCardClick of the carousel ad results in an immediate viralCardClick and viralClick, whereas scrolling to other cards and clicking will count as additional viralCardClick.0
45Metricviralcard impressionsThe number of viralImpressions shown for each card of a carousel ad. The first card of the carousel ad results in an immediate viralCardImpression and viralImpression, whereas scrolling to other cards will count as additional viralCardImpressions.0
46MetricviralclicksThe count of clicks on viral impressions.0
47MetricviralcommentlikesThe count of likes on comments from viral impressions for this activity.0
48MetricviralcommentsThe count of comments from viral impressions for this activity.0
49Metricviralcompany pageclicksThe count of clicks to view the company page from viral impressions for this activity.0
50Metricviralexternal websiteconversionsThe count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.0
51Metricviralexternal websitepostclick conversionsThe count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.0
52Metricviralexternalwebsite postviewconversionsThe count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.0
53MetricviralfollowsThe count of follows from viral impressions for this activity.0
54MetricviralfullscreenplaysThe count of taps on the video, going into video view mode.0
55MetricviralimpressionsThe count of viral impressions for this activity. Viral impressions are those resulting from users sharing a sponsored update to their own network of connections. Viral impressions are not counted as regular impressions.0
56Metricvirallanding pageclicksThe count of clicks on viral impressions to take the user to the creative landing page.0
57MetricvirallikesThe count of likes from viral impressions for this activity.0
58Metricviraloneclicklead formopensThe count of times users opened the lead form for viral impressions from a Lead Gen campaign.0
59Metricviralone clickleadsThe count of leads generated through One Click Lead Gen from viral impressions for this activity.0
60Metricviralothe rengagementsThe count of user interactions with viral impressions that do not fit into any other more specific category.0
61MetricviralreactionsThe count of positive reactions on viral Sponsored Updates which can capture like, interest, praise, and other responses.0
62MetricviralsharesThe count of shares from viral impressions for this activity.0
63MetricviraltotalengagementsThe count of all user interactions with a viral ad unit.0
64MetricviralvideocompletionsThe count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.0
65Metricviralvideofirst quartilecompletionsThe count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.0
66Metricviralvideomid pointcompletionsThe count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.0
67Metricviral videostartsThe count of viral video ads that were started by users. See viralImpressions definition. Since viral videos are automatically played for ON_SITE, this will be the same as viralImpressions if the servingLocation is ON_SITE.0
68Metricviralvideothird quartilecompletionsThe count of viral video ads that played through the third quartile of the video. This includes watches that skipped to this point.0
69MetricviralvideoviewsA viral video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to full screen mode) does not count as a view.0
70Electrik.AIsha_idHashed Primary Key59684f8c7436298bf41 c7b5917321db3f9cdf870e81 8e759cbc0cbbb759eb2f0
71Electrik.AIetl_orgOrganization IdORG000943
72Electrik.AIetl_projectProject IdPR000369
73Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2020-10-21 10:43 :40.189118 UTC
74Electrik.AIetl_update _utc_dttmRecord Update Timestamp in UTC2020-10-21 10:44:39.850888 UTC
75Electrik.AIetl_start _utc_dttmEAI Flow Start Timestamp in UTC2020-10-21 10:18:00.915044 UTC
76Electrik.AIetl_flow_nmEAI Flow CodeFL001925
77Electrik.AIetl_flow_ instance_idEAI Flow Execution Instance IdFL001925- 20201021101300033670
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionaccount_idAccount Id5.06E+08
2MetricactionclicksThe count of clicks on the action button of the Sponsored InMail.0
3MetricadunitclicksThe count of clicks on the ad unit displayed alongside the Sponsored InMail.0
4Metricapproximateun iqueimpressionsThe approximate reach of the campaign. The number of instances where a unique user viewed LinkedIn ad
5MetriccardclicksThe number of clicks for each card of a carousel ad.0
6MetriccardimpressionsThe number of impressions shown for each card of a carousel ad.0
7MetricclicksThe count of chargeable clicks, for example, clicks to view the landing page or company page10
8MetriccommentlikesThe count of likes of a comment.0
9MetriccommentsThe count of comments.0
10MetriccompanypageclicksThe count of clicks to view the company page.0
11Metricconversion valueinlocalcurrencyValue of the conversions in the account’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.0
12Metriccostinlo calcurrencyCost in the account’s local currency based on the pivot and time Granularity. For example, this would be spend by member company size per month if the pivot is MEMBER _COMPANY_SIZE and time Granularity is MONTHLY.7.95
13MetriccostinusdCost in USD based on the pivot and time Granularity. For example, this would be spend by campaign on a given day if the pivot is CAMPAIGN and timeGranularity is DAILY.7.95
14Metricexternalweb siteconversionsThe count of conversions indicated by pixel loads on an external advertiser website.0
15Metricexternalwebsitepost clickconversionsThe count of post-click conversions indicated by pixel loads on an external advertiser website.0
16Metricexternalwebsite postviewconversionsThe count of post-view conversions indicated by pixel loads on an external advertiser website.0
17MetricfollowsThe count of follows.0
18MetricfullscreenplaysThe count of taps on the video, going into video view mode.0
19MetricimpressionsThis is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.319
20MetriclandingpageclicksThe count of clicks which take the user to the creative landing page.0
21Metricleadgeneration mailcontactinfosharesThe number of times users shared contact info through the One Click Lead Gen for Sponsored InMail.0
22Metricleadgeneration mailinterestedclicksThe count of InMail recipients who clicked to demonstrate interest.0
23MetriclikesThe count of likes.0
24Metriconeclick leadformopensThe count of times users opened the lead form for a One Click Lead Gen campaign.0
25MetriconeclickleadsThe count of leads generated through One Click Lead Gen.0
26MetricopensThe count of opens of Sponsored InMail.10
27Metricotheren gagementsThe count of user interactions with the ad unit that do not fit into any other more specific category.0
28DimensionpivotPivotACCOUNT
29DimensionpivotvaluePivot Valueurn:li:sponsored Account:505966632
30DimensionpivotvaluesThe value of the pivots for a specific record returned. For example, supplying pivots of CREATIVE and CONVERSION results in a list of records, one for each creative/ conversion combination. The pivotValues contain serialized URNs for the specific
creative and conversion for a record.
[urn:li:spons oredAccount:505966632]
31MetricreactionsThe count of positive reactions on Sponsored Updates which can capture, like, interest, praise, and other responses.0
32MetricsendsThe count of sends of Sponsored InMail.17
33MetricsharesThe count of shares.0
34Metricsnapshot_dtSnapshot Date#########
35MetrictexturlclicksThe count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail.0
36MetrictotalengagementsThe count of all user interactions with the ad unit.10
37MetricvideocompletionsThe count of video ads that played 97-100% of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
38Metricvideofirstquartile completionsThe count of video ads that played through the first quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
39Metricvideomidpoint completionsThe count of video ads that played through the midpoint of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
40MetricvideostartsThe count of video ads that were started by users.0
41Metricvideothird quartilecompletionsThe count of video ads that played through the third quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
42MetricvideoviewsA video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to fullscreen mode) does not count as a view.0
43MetricviralcardclicksThe number of viralClicks for each card of a carousel ad. The first viralCardClick of the carousel ad results in an immediate viralCardClick and viralClick, whereas scrolling to other cards and clicking will count as additional viralCardClick.0
44Metricviralcard impressionsThe number of viralImpressions shown for each card of a carousel ad. The first card of the carousel ad results in an immediate viralCard Impression and viral Impression, whereas scrolling to other cards will count as additional viralCard Impressions.0
45MetricviralclicksThe count of clicks on viral impressions.0
46MetricviralcommentlikesThe count of likes on comments from viral impressions for this activity.0
47MetricviralcommentsThe count of comments from viral impressions for this activity.0
48Metricviralcompany pageclicksThe count of clicks to view the company page from viral impressions for this activity.0
49Metricviralexternal websiteconversionsThe count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.0
50Metricviralexternal websitepostclick conversionsThe count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.0
51Metricviralexternal websitepostview conversionsThe count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.0
52MetricviralfollowsThe count of follows from viral impressions for this activity.0
53Metricviralfull screenplaysThe count of taps on the video, going into video view mode.0
54MetricviralimpressionsThe count of viral impressions for this activity. Viral impressions are those resulting from users sharing a sponsored update to their own network of connections. Viral impressions are not counted as regular impressions.0
55Metricvirallanding pageclicksThe count of clicks on viral impressions to take the user to the creative landing page.0
56MetricvirallikesThe count of likes from viral impressions for this activity.0
57Metricviralone clickleadfor mopensThe count of times users opened the lead form for viral impressions from a Lead Gen campaign.0
58Metricviralone clickleadsThe count of leads generated through One Click Lead Gen from viral impressions for this activity.0
59Metricviralothe rengagementsThe count of user interactions with viral impressions that do not fit into any other more specific category.0
60MetricviralreactionsThe count of positive reactions on viral Sponsored Updates which can capture like, interest, praise, and other responses.0
61MetricviralsharesThe count of shares from viral impressions for this activity.0
62Metricviraltotal engagementsThe count of all user interactions with a viral ad unit.0
63Metricviralvideo completionsThe count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.0
64Metricviralvideo firstquartile completionsThe count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.0
65Metricviralvideomi dpointcompletionsThe count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.0
66Metricviral videostartsThe count of viral video ads that were started by users. See viralImpressions definition. Since viral videos are automatically played for ON_SITE, this will be the same as viralImpressions if the servingLocation is ON_SITE.0
67Metricviralvideo thirdquartile completionsThe count of viral video ads that played through the third quartile of the video. This includes watches that skipped to this point.0
68MetricviralvideoviewsA viral video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to full screen mode) does not count as a view.0
69Electrik.AIsha_idHashed Primary Key59684f8c7436298bf41 c7b5917321db3f9cdf870e81 8e759cbc0cbbb759eb2f0
70Electrik.AIetl_orgOrganization IdORG000943
71Electrik.AIetl_projectProject IdPR000369
72Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2020-10-21 10:43: 40.189118 UTC
73Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2020-10-21 10: 44:39.850888 UTC
74Electrik.AIetl_start_ utc_dttmEAI Flow Start Timestamp in UTC2020-10-21 10: 18:00.915044 UTC
75Electrik.AIetl_flow_nmEAI Flow CodeFL001925
76Electrik.AIetl_flow_ instance_idEAI Flow Execution Instance IdFL001925- 20201021101300033670
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionaccount_idAccount Id5E+08
2MetricactionclicksThe count of clicks on the action button of the Sponsored InMail.0
3MetricadunitclicksThe count of clicks on the ad unit displayed alongside the Sponsored InMail.0
4Metricapproximateun iqueimpressionsThe approximate reach of the campaign. The number of instances where a unique user viewed LinkedIn ad
5Dimensioncampaign_idCampaign Id2E+08
6MetriccardclicksThe number of clicks for each card of a carousel ad.0
7MetriccardimpressionsThe number of impressions shown for each card of a carousel ad.0
8MetricclicksThe count of chargeable clicks, for example, clicks to view the landing page or company page0
9MetriccommentlikesThe count of likes of a comment.0
10MetriccommentsThe count of comments.0
11MetriccompanypageclicksThe count of clicks to view the company page.0
12Metricconversionvalue inlocalcurrencyValue of the conversions in the account’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.0
13Metriccostinlo calcurrencyCost in the account’s local currency based on the pivot and timeGranularity. For example, this would be spend by member company size per month if the pivot is MEMBER_COMPANY _SIZE and timeGranularity is MONTHLY.0
14MetriccostinusdCost in USD based on the pivot and timeGranularity. For example, this would be spend by campaign on a given day if the pivot is CAMPAIGN and timeGranularity is DAILY.0
15Metricexternal websiteconversionsThe count of conversions indicated by pixel loads on an external advertiser website.0
16Metricexternalwebsite postclickconversionsThe count of post-click conversions indicated by pixel loads on an external advertiser website.0
17Metricexternalwebsite postviewconversionsThe count of post-view conversions indicated by pixel loads on an external advertiser website.0
18MetricfollowsThe count of follows.0
19MetricfullscreenplaysThe count of taps on the video, going into video view mode.0
20MetricimpressionsThis is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.12
21MetriclandingpageclicksThe count of clicks which take the user to the creative landing page.0
22Metricleadgenerationmail contactinfosharesThe number of times users shared contact info through the One Click Lead Gen for Sponsored InMail.0
23Metricleadgenerationmail interestedclicksThe count of InMail recipients who clicked to demonstrate interest.0
24MetriclikesThe count of likes.0
25Metriconeclicklead formopensThe count of times users opened the lead form for a One Click Lead Gen campaign.0
26MetriconeclickleadsThe count of leads generated through One Click Lead Gen.0
27MetricopensThe count of opens of Sponsored InMail.0
28MetricotherengagementsThe count of user interactions with the ad unit that do not fit into any other more specific category.0
29DimensionpivotPivotCAMPAIGN
30DimensionpivotvaluePivot Valueurn:li:sponsored Campaign:152832294
31DimensionpivotvaluesThe value of the pivots for a specific record returned. For example, supplying pivots of CREATIVE and CONVERSION results in a list of records, one for each creative/conversion combination. The pivotValues contain serialized URNs for the specific
creative and conversion for a record.
[urn:li:sponsored Campaign:152832294]
32MetricreactionsThe count of positive reactions on Sponsored Updates which can capture, like, interest, praise, and other responses.0
33MetricsendsThe count of sends of Sponsored InMail.0
34MetricsharesThe count of shares.0
35Metricsnapshot_dtSnapshot Date#####
36MetrictexturlclicksThe count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail.0
37MetrictotalengagementsThe count of all user interactions with the ad unit.0
38MetricvideocompletionsThe count of video ads that played 97-100% of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
39Metricvideofirstquartile completionsThe count of video ads that played through the first quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
40Metricvideomidpoint completionsThe count of video ads that played through the midpoint of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
41MetricvideostartsThe count of video ads that were started by users.0
42Metricvideothird quartilecompletionsThe count of video ads that played through the third quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
43MetricvideoviewsA video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to fullscreen mode) does not count as a view.0
44MetricviralcardclicksThe number of viralClicks for each card of a carousel ad. The first viralCardClick of the carousel ad results in an immediate viralCardClick and viralClick, whereas scrolling to other cards and clicking will count as additional viralCardClick.0
45Metricviralcard impressionsThe number of viralImpressions shown for each card of a carousel ad. The first card of the carousel ad results in an immediate viralCardImpression and viralImpression, whereas scrolling to other cards will count as additional viral CardImpressions.0
46MetricviralclicksThe count of clicks on viral impressions.0
47MetricviralcommentlikesThe count of likes on comments from viral impressions for this activity.0
48MetricviralcommentsThe count of comments from viral impressions for this activity.0
49MetricviralcompanypageclicksThe count of clicks to view the company page from viral impressions for this activity.0
50Metricviralexternal websiteconversionsThe count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.0
51Metricviralexternal websitepostclick conversionsThe count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.0
52Metricviralexternal websitepostview conversionsThe count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.0
53MetricviralfollowsThe count of follows from viral impressions for this activity.0
54MetricviralfullscreenplaysThe count of taps on the video, going into video view mode.0
55MetricviralimpressionsThe count of viral impressions for this activity. Viral impressions are those resulting from users sharing a sponsored update to their own network of connections. Viral impressions are not counted as regular impressions.0
56Metricvirallanding pageclicksThe count of clicks on viral impressions to take the user to the creative landing page.0
57MetricvirallikesThe count of likes from viral impressions for this activity.0
58Metricviraloneclick leadformopensThe count of times users opened the lead form for viral impressions from a Lead Gen campaign.0
59Metricviralone clickleadsThe count of leads generated through One Click Lead Gen from viral impressions for this activity.0
60Metricviralother engagementsThe count of user interactions with viral impressions that do not fit into any other more specific category.0
61MetricviralreactionsThe count of positive reactions on viral Sponsored Updates which can capture like, interest, praise, and other responses.0
62MetricviralsharesThe count of shares from viral impressions for this activity.0
63Metricviraltota lengagementsThe count of all user interactions with a viral ad unit.0
64Metricviralvideo completionsThe count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.0
65Metricviralvideofirst quartilecompletionsThe count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.0
66Metricviralvideomid pointcompletionsThe count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.0
67Metricviral videostartsThe count of viral video ads that were started by users. See viralImpressions definition. Since viral videos are automatically played for ON_SITE, this will be the same as viralImpressions if the servingLocation is ON_SITE.0
68Metricviralvideo thirdquartile completionsThe count of viral video ads that played through the third quartile of the video. This includes watches that skipped to this point.0
69MetricviralvideoviewsA viral video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to full screen mode) does not count as a view.0
70Electrik.AIsha_idHashed Primary Key59684f8c74362 98bf41c7b5917321db 3f9cdf870e818e759c bc0cbbb759eb2f0
71Electrik.AIetl_orgOrganization IdORG000943
72Electrik.AIetl_projectProject IdPR000369
73Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2020-10-21 10:43:40.189118 UTC
74Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2020-10-21 10: 44:39.850888 UTC
75Electrik.AIetl_start_ utc_dttmEAI Flow Start Timestamp in UTC2020-10-21 10:18:00.915044 UTC
76Electrik.AIetl_flow_nmEAI Flow CodeFL001925
77Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001925-20201 021101300033670
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionaccount_idAccount Id505966632
2MetricactionclicksThe count of clicks on the action button of the Sponsored InMail.0
3MetricadunitclicksThe count of clicks on the ad unit displayed alongside the Sponsored InMail.0
4Metricapproximate uniqueimpressionsThe approximate reach of the campaign. The number of instances where a unique user viewed LinkedIn ad
5Dimensioncampaign_group_idCampaign Group ID610967943
6MetriccardclicksThe number of clicks for each card of a carousel ad.
7MetriccardimpressionsThe number of impressions shown for each card of a carousel ad.
8MetricclicksThe count of chargeable clicks, for example, clicks to view the landing page or company page5
9MetriccommentlikesThe count of likes of a comment.
10MetriccommentsThe count of comments.0
11MetriccompanypageclicksThe count of clicks to view the company page.0
12Metricconversionvaluein localcurrencyValue of the conversions in the account’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.0
13MetriccostinlocalcurrencyCost in the account’s local currency based on the pivot and timeGranularity. For example, this would be spend by member company size per month if the pivot is MEMBER_COMPANY_SIZE and timeGranularity is MONTHLY.0
14MetriccostinusdCost in USD based on the pivot and timeGranularity. For example, this would be spend by campaign on a given day if the pivot is CAMPAIGN and timeGranularity is DAILY.0
15Metricexternalwebsite conversionsThe count of conversions indicated by pixel loads on an external advertiser website.0
16Metricexternalwebsitepost clickconversionsThe count of post- click conversions indicated by pixel loads on an external advertiser website.0
17Metricexternalwebsite postviewconversionsThe count of post-view conversions indicated by pixel loads on an external advertiser website.0
18MetricfollowsThe count of follows.0
19MetricfullscreenplaysThe count of taps on the video, going into video view mode.0
20MetricimpressionsThis is the count of “impressions” for Direct Ads and Sponsored Updates and “sends” for InMails.0
21MetriclandingpageclicksThe count of clicks which take the user to the creative landing page.0
22Metricleadgenerationmail contactinfosharesThe number of times users shared contact info through the One Click Lead Gen for Sponsored InMail.0
23Metricleadgeneration mailinterestedclicksThe count of InMail recipients who clicked to demonstrate interest.0
24MetriclikesThe count of likes.0
25MetriconeclickleadformopensThe count of times users opened the lead form for a One Click Lead Gen campaign.0
26MetriconeclickleadsThe count of leads generated through One Click Lead Gen.0
27MetricopensThe count of opens of Sponsored InMail.5
28MetricotherengagementsThe count of user interactions with the ad unit that do not fit into any other more specific category.0
29DimensionpivotPivot
30DimensionpivotvaluePivot Valueurn:li:sponsored CampaignGroup: 610967943
31DimensionpivotvaluesThe value of the pivots for a specific record returned. For example, supplying pivots of CREATIVE and CONVERSION results in a list of records, one for each creative/conversion combination. The pivotValues contain serialized URNs for the specific
creative and conversion for a record.
[urn:li:sponsored CampaignGroup: 610967943]
32MetricreactionsThe count of positive reactions on Sponsored Updates which can capture, like, interest, praise, and other responses.0
33MetricsendsThe count of sends of Sponsored InMail.0
34MetricsharesThe count of shares.0
35Metricsnapshot_dtSnapshot Date20-10-2020
36MetrictexturlclicksThe count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail.0
37MetrictotalengagementsThe count of all user interactions with the ad unit.5
38MetricvideocompletionsThe count of video ads that played 97-100% of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
39Metricvideofirstquartile completionsThe count of video ads that played through the first quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
40Metricvideomidpoint completionsThe count of video ads that played through the midpoint of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
41MetricvideostartsThe count of video ads that were started by users.0
42Metricvideothirdquartile completionsThe count of video ads that played through the third quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE.0
43MetricvideoviewsA video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to fullscreen mode) does not count as a view.
44MetricviralcardclicksThe number of viralClicks for each card of a carousel ad. The first viralCardClick of the carousel ad results in an immediate viralCardClick and viralClick, whereas scrolling to other cards and clicking will count as additional viral CardClick.
45Metricviralcard impressionsThe number of viralImpressions shown for each card of a carousel ad. The first card of the carousel ad results in an immediate viralCardImpression and viralImpression, whereas scrolling to other cards will count as additional viralCardImpressions.
46MetricviralclicksThe count of clicks on viral impressions.
47MetricviralcommentlikesThe count of likes on comments from viral impressions for this activity.
48MetricviralcommentsThe count of comments from viral impressions for this activity.
49MetricviralcompanypageclicksThe count of clicks to view the company page from viral impressions for this activity.
50Metricviralexternal websiteconversionsThe count of conversions indicated by pixel loads on an external advertiser website driven by a viral event.
51Metricviralexternal websitepostclick conversionsThe count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click.
52Metricviralexternal websitepostview conversionsThe count of post -view conversions indicated by pixel loads on an external advertiser website driven by a viral impression.
53MetricviralfollowsThe count of follows from viral impressions for this activity.
54Metricviralfull screenplaysThe count of taps on the video, going into video view mode.
55MetricviralimpressionsThe count of viral impressions for this activity. Viral impressions are those resulting from users sharing a sponsored update to their own network of connections. Viral impressions are not counted as regular impressions.
56Metricvirallanding pageclicksThe count of clicks on viral impressions to take the user to the creative landing page.
57MetricvirallikesThe count of likes from viral impressions for this activity.
58Metricviraloneclick leadformopensThe count of times users opened the lead form for viral impressions from a Lead Gen campaign.
59Metricviralone clickleadsThe count of leads generated through One Click Lead Gen from viral impressions for this activity.
60Metricviraloth erengagementsThe count of user interactions with viral impressions that do not fit into any other more specific category.
61MetricviralreactionsThe count of positive reactions on viral Sponsored Updates which can capture like, interest, praise, and other responses.
62MetricviralsharesThe count of shares from viral impressions for this activity.
63MetricviraltotalengagementsThe count of all user interactions with a viral ad unit.
64Metricviralvideo completionsThe count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point.
65Metricviralvideofirst quartilecompletionsThe count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point.
66Metricviralvideomid pointcompletionsThe count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point.
67Metricviralvideo startsThe count of viral video ads that were started by users. See viralImpressions definition. Since viral videos are automatically played for ON_SITE, this will be the same as viral Impressions if the servingLocation is ON_SITE.
68Metricviralvideothird quartilecompletionsThe count of viral video ads that played through the third quartile of the video. This includes watches that skipped to this point.
69Metricviral videoviewsA viral video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to full screen mode) does not count as a view.
70Electrik.AIsha_idHashed Primary Key5921993c397a7a e6bc54dfa655b6ef3ed 3898e5c70fe66aeef95 5a762c9aae65
71Electrik.AIetl_orgOrganization IdORG000943
72Electrik.AIetl_projectProject IdPR000369
73Electrik.AIetl_create_ utc_dttmRecord loaded/ created Timestamp in UTC2020-10-21 10: 43:40.189118 UTC
74Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2020-10-21 10: 44:39.850888 UTC
75Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2020-10-21 10: 18:00.915044 UTC
76Electrik.AIetl_flow_nmEAI Flow CodeFL001925
77Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001925-202010 21101300033670