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-ElectrikAI

Step 4: Select the Connections Icon in the left most panel and Click on “Add” button the top.

Step 4 Select the Connections Icon in the left most panel-ElectrikAI

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

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

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

Step 6 Enter your LinkedIn Ads User Id and Password-ElectrikAI

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 8 Select the LinkedIn Ads Account from the dropdown-ElectrikAI

Step 9: Click on Save button on the top.

Step 9 Click on Save button on the top-ElectrikAI

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

Congratulations, you have now successfully created a LinkedIn Ads Connection-ElectrikAI

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.

Select IO in Electrik.AI dashboard-ElectrikAI

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

Step 4 Flow Add Button-ElectrikAI

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

Step 5 Select LinkedIn Ads Connection present in the list of available sources-ElectrikAI

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

Step 6 Select your existing LinkedIn Ads connection-ElectrikAI

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.

Step 7 Click on a destination of your choice from list-ElectrikAI

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

Step 8 Select your existing BigQuery connection in ElectrikAI

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

Step 9a Choose the desired report to get the appropriate data-ElectrikAI

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 9c Save and Proceed-ElectrikAI

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.

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

Flow Details Screen-ElectrikAI

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

Successfully setup LinkedIn Ads-ElectrikAI

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

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