This cheat sheet explains how Fivetran’s LinkedIn Ads Analytics connector helps track and optimize ad performance. It offers features like priority first sync for historical campaign and creative analytics, universal column masking for sensitive data protection, and a dbt package to roll up spend, clicks, and impressions across platforms. The connector supports granular queries across accounts, campaigns, and ads, with customizable attribution windows. Key tables include CAMPAIGN_HISTORY, AD_ANALYTICS_BY_CAMPAIGN, and AD_ANALYTICS_BY_CREATIVE for metrics like clicks, costs, and shares. Metadata tables add context, while combined reporting enables cross-platform marketing analysis.

Join for free to read