Import data from LinkedIn Ads to your data warehouse

How to setup LinkedIn Ads Integration

This integration will allow you to connect with LinkedIn Ads and start collecting your data. It is a matter of minutes to send your billing data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting LinkedIn Ads
  2. Set the Replication Frequency
  3. Load your LinkedIn Ads data into your data warehouse
  4. LinkedIn Ads expected Data Model and schema
  5. LinkedIn Ads Integration FAQ

Getting Started – Setup LinkedIn Ads integration at Blendo

1. To add this integration, go to Blendo dashboard. Click Add a Source.

2. Click on LinkedIn Ads icon.

Settings you need from LinkedIn Ads

3. In the new Setup your LinkedIn Ads source screen your LinkedIn profile credentials are needed to Connect with LinkedIn Ads.

 

4. Then to Connect your data source choose the configuration from the drop down menus as needed:

and then click Next

5. Add a Table Prefix if you want and click Next.

 

6. In the next screen, you may select the resources you need to sync from LinkedIn Ads. After finishing click Create.

7. Then you will return back to the home dashboard. Click on your new LinkedIn Ads data source.

Set the Replication Frequency

This configuration controls how often Blendo will pull data from your LinkedIn Ads integration. Loading to your data warehouse could take a little bit longer.

8. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

9. In the next pop-up select one of the options available and click Apply.

Load your LinkedIn Ads data into your data warehouse

Blendo will queue your sync request and start syncing on its schedule. If you want to trigger it on your own here is how to start loading your LinkedIn Ads data into your data warehouse:

LinkedIn Ads Data Model & Schema Information

Blendo will now connect to your LinkedIn Ads data source. It will sync your historical data and all the future updates into your destination data warehouse. You will get analytics ready tables and syncs that make sure you will get recent and consistent data.

Let’s see:

  1. How Blendo syncs LinkedIn Ads data
  2. The tables with LinkedIn Ads data that we create in your destination data warehouse

How Blendo syncs LinkedIn Ads data

Historical Data

When Blendo first connects to LinkedIn Ads Data source, will pull all your historical data.

Sync Schedule

Blendo syncs LinkedIn Ads data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your LinkedIn Ads data performs a full replication. Then your LinkedIn Ads data is replicated incrementally. Note that Blendo will only read your data.

LinkedIn Ads API Limits & Replication Frequency

LinkedIn Ads’ API does not support any filtering to a date that we could use to fetch incremental data for any of their endpoints. The only exception to that rule is the Deals resource which supports fetching incremental data. For more information visit LinkedIn Ads doc here.

After you finish the integration with LinkedIn Ads, you might see its status as Importing from sourceExporting to the destination, or Completed.

What LinkedIn Ads data do I have available?

Blendo creates analytics ready tables with recent and consistent data. Bellow is a diagram of the schema and you may also find a CSV with all the columns and fields in more detail.

Expected LinkedIn Ads Data Model & Schema Information >>

Questions? Contact us!

in Connecting SaaS Data Sources