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 name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | True | Field level |
| Incremental | True | Available only for the ad_analytics_* tables |
| Custom data | False | |
| History | False | |
| ReSync | True | Table level |
| Templates | True |
Data Schema
Setup Guide
Step 1 - Create the connection
- In Weld, click Data Sources in the sidebar, then Add Data Source, and choose LinkedIn Ads. If the account is already connected, choose Use existing connection and go to Step 2.
- Check the connection Name (1). It's filled in for you, and you can change it.
- Click Authorize (3) and sign in to LinkedIn. Approve Weld's access, and you're taken back to the setup.
If someone else owns the LinkedIn account, for example a client, click Share Authorization Link (2) instead and send them the link. They sign in and grant access without a Weld login. See Authorization links.
Step 2 - Connection Settings
On Connection Settings, choose:
- Ad Accounts: the LinkedIn ad accounts to sync.
- Limit historical data: sync only data after a date you choose. Leave it empty to sync all the history the API offers.
Click Next.
Step 3 - Data to sync
Tick the tables you want. Each table shows whether it syncs in full or incrementally, and you can expand it to remove or hash columns. See Tables below for what each kind holds.
Step 4 - Configure sync
Choose how often to sync, check the Destination schema name, which is where the tables land in your warehouse, and click Start Initial Sync.
Query your data
When the first sync finishes, the tables are in your warehouse under the destination schema. In Transform, find them under Data Sources in the sidebar, then write a model on top of them or ask Ed to write one. See Data models.
Tables
Account and campaigns. How your account is set up, synced in full:
account,account_usercampaign_group,campaign,creative,post
Performance. Daily metrics, synced incrementally:
ad_analytics_by_campaign: per campaign.ad_analytics_by_creative: per creative.
Join the analytics tables to the objects on their IDs, for example ad_analytics_by_campaign to campaign.