LinkedIn Ads Connector

**Sync your full-funnel LinkedIn Ads data directly into Snowflake — structured, refreshed, and query-ready.**<br/>Windsor.ai’s Snowflake Native App makes it easy to analyze campaign, ad group, creative, and audience performance from LinkedIn Ads using only SQL. No more CSV exports, API scripts, or waiting for dashboards to update.

What it does

- Connects to **LinkedIn Marketing Solutions** (Campaign Manager API)
- Streams data from **campaigns, creatives, audience segments, lead gen forms, video views, conversions**
- Supports **hundreds of metrics & dimensions**, including spend, impressions, clicks, leads, conversions, engagement, and demographic breakdowns
- Delivers **fully typed Snowflake tables** — no JSON blobs or nested fields
- Runs **entirely inside your Snowflake account** — secure, scalable, and compliant
- Handles **incremental syncs, schema evolution, and error recovery automatically**

## Sample tables & fields

**LI_CAMPAIGN_STATS_DAILY** — date, campaign_id, campaign_name, objective_type, status, account_id, impressions, clicks, spend, leads, conversions, ctr, cpc, cost_per_lead<br/>**LI_ADS_STATS_DAILY** — ad_id, ad_name, campaign_id, format_type, impressions, video_views, likes, comments, shares, follows, total_engagements<br/>**LI_AUDIENCE_METRICS** — campaign_id, audience_segment, industry, job_title, company_size, location, impressions, clicks, conversions, spend<br/>**LI_LEAD_GEN_FORMS** — form_id, campaign_id, campaign_name, submissions, open_rate, completion_rate, total_leads, created_time

## Use cases

- Multi-account LinkedIn Ads performance reporting in BI tools
- Lead gen form conversion tracking and funnel attribution
- Cross-channel ROI analysis by joining with CRM, revenue, and website data
- Campaign and creative A/B testing with downstream impact analysis
- Real-time marketing ops dashboards without relying on native UI

## Why choose Windsor.ai

- **Fully Snowflake-native** — secure and scalable with your existing roles & policies
- **No pipeline maintenance** — schema changes, backfills, and retries managed for you
- **Works with 325+ sources** — including HubSpot, Salesforce, GA4, Facebook, Google Ads
- **Typed & documented schema** — ready for Looker, Tableau, Power BI
- **Usage-based pricing** — no per-seat or per-property fees

原始信息汇总

LinkedIn Ads Connector 数据集概述

数据集提供商

• Windsor.ai

数据集特点

• 免费访问
• 无限访问权限

数据集功能

• 将完整的LinkedIn Ads数据直接同步到Snowflake
• 结构化、定期刷新、可直接查询
• 支持通过SQL分析LinkedIn Ads中的活动、广告组、创意和受众表现

数据内容

• 连接至LinkedIn Marketing Solutions (Campaign Manager API)
• 流式传输来自活动、创意、受众细分、潜在客户生成表单、视频观看和转化的数据
• 支持数百个指标和维度，包括支出、展示次数、点击次数、潜在客户、转化、参与度和人口统计细分
• 提供完全类型化的Snowflake表

示例表及字段

• LI_CAMPAIGN_STATS_DAILY: 日期、活动ID、活动名称、目标类型、状态、账户ID、展示次数、点击次数、支出、潜在客户、转化、CTR、CPC、每潜在客户成本
• LI_ADS_STATS_DAILY: 广告ID、广告名称、活动ID、格式类型、展示次数、视频观看次数、点赞、评论、分享、关注、总参与度
• LI_AUDIENCE_METRICS: 活动ID、受众细分、行业、职位名称、公司规模、位置、展示次数、点击次数、转化、支出
• LI_LEAD_GEN_FORMS: 表单ID、活动ID、活动名称、提交、开放率、完成率、总潜在客户、创建时间

使用案例

• 在BI工具中进行多账户LinkedIn Ads性能报告
• 潜在客户生成表单转化跟踪和漏斗归因
• 通过与CRM、收入和网站数据结合进行跨渠道ROI分析
• 活动与创意A/B测试及下游影响分析
• 实时营销运营仪表板

安全特性

• 完全在Snowflake账户内运行
• 自动处理增量同步、模式演变和错误恢复
• 通过Snowflake基于角色的访问控制保护数据