Marketing Intelligence components are SSIS components from SSIS Productivity Pack which facilitate codeless integration with various digital marketing services.

The SSIS Productivity Pack currently supports connecting to and retrieving and writing data to Bing Ads and supports connecting to and retrieving data from Google Analytics, Google Ads, and YouTube Analytics.

Google Ads Components

  • Google Ads Connection Manager
    • Facilitates connecting to a Google Ads customer account through the Google Ads REST API. 
  • Google Ads Source
    • Facilitates retrieving Google Ads data from specified Report Type, Date Range, and other user-defined filters and variables.

Google Analytics Components

Bing Ads Components

YouTube Analytics Components

Video Resources

Youtube Video - Getting started with SSIS Productivity Pack - Google Analytics

Youtube Video - Getting started with SSIS Productivity Pack - Google AdWords