LinkedIn Ads

LinkedIn Ads is a powerful advertising platform provided by LinkedIn, the professional social networking platform. It allows businesses and advertisers to create and manage targeted ad campaigns to reach a specific audience of professionals.

Feature nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrueAvailable only for the ad_analytics_* tables
Custom dataFalse
HistoryFalse
ReSyncTrueTable level
TemplatesTrue

Data Schema

T
- Table
S
- Sub table

πŸ”§ Setup Guide

Step 1 - Begin Configuration

  1. In the connector setup form, enter the destination schema name of your choice.
  2. Click Authorize to allow Weld to access your LinkedIn account using OAuth.

Step 2 - Approve and finalize

  1. Approve Weld to access your LinkedIn account.
  2. When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.

Step 3 - Connection Settings

  1. Select all the LinkedIn accounts that you would to sync data from.
  2. Limit historical data to only sync data after the selected date to only include that data in the initial sync.

Step 4 - Data To Sync

  1. Select the pre-built reports you wish to include in the sync.
    You can view the schema, remove columns or hash sensitive information.

Step 5 - Configure Sync

  1. Select how often you would like the data to sync.
  2. Provide a unique destination table name.

Weld will take over from here and commence syncing data from your LinkedIn Ads account.


πŸ“ˆ Data Modelling

  1. Access Data Post-Sync: Once the initial synchronization is complete, your LinkedIn Ads data is available for querying in the SQL editor by clicking Transform.
  2. Find LinkedIn Ad Tables: In Transform, expand the LinkedIn Ad folder under data sources to see available tables.
  3. Explore Table Schema: Click on a table to view its schema and understand the structure and type of data.
  4. Create SQL Queries: Begin a new page in Transform to start crafting your SQL queries.
  5. Utilize AI Assistance: For help with queries, click the icon to talk to Ed Logo Ed, our AI Assistant, and input details about your querying needs.
  6. Save and Organize Queries: Save your refined queries in a specific folder for future reference.

For additional information on data Transform or SQL tips, you can refer to our SQL Tutorial.

πŸ“‚ Table Summary

Weld supports data replication of both object and report LinkedIn Ads data.

  • Objects

    • Description: Objects represent the structural and operational setup of an advertising entity. This includes configurations, targeting settings, and relationships with other entities in the advertising ecosystem.
    • Example: ad_group
  • Reports

    • Description: Reports focus on the performance metrics and results of the entity. They provide detailed data about how well the entity is performing on a daily basis.
    • Example: ad_group_report

Objects Overview

  • Core Entities: Essential to LinkedIn Ads, representing foundational data. Provides information on what the entity is and how it is set up
    • Advertisers
    • Campaign
    • Ad Group
    • Ad

Reports Overview

  • Performance Metrics: Includes detailed metrics and statistics for reporting on Ads, Ad Groups, and Campaigns. Indicate how well the entity is performing, based on various performance metrics.
  • Granularity: Data availability is detailed, offered on a daily and hourly basis.
  • Additional Reporting Dimensions: Reports can also be created based on Country, Language, Age, Gender, and Platform.

πŸ“Š SQL Templates

Get started with LinkedIn Ads SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for LinkedIn Ads.


πŸ“ˆ Marketing Core Metrics

You can integrate the following connectors with your LinkedIn Ads data to create a comprehensive marketing dashboard using Weld and our Marketing Core Metrics:

To use these prebuilt models, simply click on any of these connectors in the Data Sources section of your account, and select Marketing Metrics.


𝌭 Staging Models

linkedin_ads_account_report
linkedin_ads_campaign_group_report
linkedin_ads_campaign_report
linkedin_ads_creative_report

Was this page helpful?