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
• 结构化数据：数据已结构化、刷新并准备好查询

主要功能

• 连接到LinkedIn Marketing Solutions（Campaign Manager API）
• 从以下方面流式传输数据：
  • 广告活动
  • 创意
  • 受众细分
  • 潜在客户生成表单
  • 视频观看
  • 转化
• 支持数百种指标和维度，包括：
  • 花费
  • 展示次数
  • 点击次数
  • 潜在客户
  • 转化
  • 参与度
  • 人口统计细分
• 提供完全类型化的Snowflake表
• 完全在Snowflake账户内运行
• 自动处理增量同步、模式演变和错误恢复

示例表及字段

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

使用案例

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

安全特性

• 符合Native Apps Framework安全要求
• 基于角色的访问控制
• 推荐授予的权限：
  • 账户级别权限
  • 对象权限
  • 连接权限
  • 应用事件权限

提供商其他产品

• Multitouch Attribution Data in Snowflake
• Instagram Connector
• Google Ads Connector
• Facebook Ads Connector
• Google Analytics 4 Connector

地理覆盖范围

• 全球
• 按地区/大陆

云区域可用性

• AWS：
  • Africa (Cape Town)
  • Asia Pacific (Jakarta)
  • Asia Pacific (Mumbai)
  • Asia Pacific (Osaka)
  • 45 More

法律条款

• 标准条款

关于提供商

Windsor.ai帮助用户连接所有营销、分析、销售和CRM平台，并将数据流式传输到Snowflake。在Snowflake中，数据可以被修改、连接并在用户选择的BI平台中可视化。