SSIS Google Analytics Source
Read Google Analytics data into SSIS without coding against the Google Analytics API.
Build a query from the UI by picking dimensions, metrics, filters, sort order, segment and date range, start from a predefined report template, or supply a direct query URL (with a request body for GA4). Read several profiles or accounts in one step, control sampling level, and sign in with OAuth 2.0 or a service account.
The trial includes Google Analytics Source and every other PowerPack component
- Data Flow Source in SSIS
- Runs in your environment
- Also runs in Azure Data Factory
- Fully functional 30-day trial
At a glance
What Google Analytics Source can do
Google Analytics Source reads Google Analytics report data into the SSIS data flow through three query modes: build from the UI, report templates or a direct query URL.
Three query modes
Query Google Analytics data three ways, without learning complex APIs.
- Build the query from the UI
- Use a built-in report template
- Supply a direct query URL (and request body for GA4)
Built-in report templates
Start from predefined reports and metadata lists.
- Web traffic, paid traffic, referral, channel, page speed and keyword reports
- Ecommerce sales and transactions; AdWords campaign and keyword performance
- Metadata: accounts, views, dimensions and metrics, segments
Dimensions, metrics & filters
Pick dimensions, metrics, filters, sort order and segment for your report.
Dimensions,Metrics,Filters,SortBy,Segment- Custom dimensions and metrics are supported
Multiple profiles in one step
Read data from multiple profiles, trackers or accounts in a single step.
ProfileId: a list of IDs- Filter accounts, trackers or profiles by name with
regex:
Flexible date ranges
Choose a predefined date range or a custom one.
DateRangeType: Today, Yesterday, Last 7/30 days, Month to date and more- Custom
ReportStartDate/ReportEndDate(e.g.NdaysAgo)
Sampling & row limits
Control sampling level and how many rows are fetched.
SamplingLevel: DEFAULT, FASTER or HIGHER_PRECISIONMaxResults(batch size) andMaxRows
OAuth or service account
Authenticate with OAuth 2.0 or a Google service account.
- Service account with a *.p12 certificate (or JSON key) file
- Proxy server support
SQL Server 2012–2025 & ADF
Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.
- SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
- Azure Data Factory (SSIS IR)
- Design packages in Visual Studio 2017, 2019, 2022, or 2026
- Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025
Dynamic queries & preview
Supply dimensions, metrics, segments, filters and sort fields at runtime, and preview live at design time.
See all features
- Intuitive user interface for Google Analytics data integration without complex APIs or scripting
- OAuth 2.0 authentication and Google service account (*.p12 certificate file)
- Read data from multiple profiles, trackers or accounts in a single step (looping feature)
- Proxy server support
- Three ways to query: build query from UI, built-in query templates, or direct query
- Dynamic dimensions, metrics, segments, filters and sortby fields (supplied at runtime)
- Live preview support at design time
- Predefined date ranges or custom start / end dates
- Sampling level control (DEFAULT, FASTER, HIGHER_PRECISION)
- Custom dimensions and metrics
- Support for AdWords, AdSense, Ad Exchange and DoubleClick for Publisher (DFP)
Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory
SQL Server 2012–2025
How it works
From the toolbox to your first run.
Connect, pick a profile and a query mode, choose dimensions and metrics, then load the rows.
Connect with OAuth 2.0 or a service account.
Create a Google Data connection. OAuth 2.0 (default) signs in with a Google account and needs user interaction once to get a token. A service account with a *.p12 certificate needs no user interaction and does not share your Google credentials, but requires an API project and the certificate kept in a safe place on the server.
- The account needs access to the Google Analytics data
- Proxy server support
Start from a predefined report.
Set Query Mode to Report template and pick a template such as traffic by date, traffic by channel or referral, page speed, keyword analysis, ecommerce sales or transactions, AdWords campaign performance, or a metadata list (accounts, views, dimensions and metrics, segments). Click Preview to see the rows.
- No need to know dimension or metric names
- Metadata templates list accounts, views and segments
Build your own query from the UI.
In Automatic mode, select the web profile, a date range (predefined or custom start and end dates, which can come from SSIS variables), up to 7 dimensions and up to 7 metrics, then optional filters, sort order and segment. Custom dimensions and metrics can be typed in by ID.
- Several profiles in one step via
ProfileIdlist orregex: SamplingLevelDEFAULT, FASTER or HIGHER_PRECISION
Load Google Analytics data into SQL Server.
Connect Google Analytics Source to a SQL Server destination and run the package. Use MaxRows to cap the rows and MaxResults to set the batch size.
- Live preview at design time
- Dynamic dimensions, metrics, filters and segments at runtime
Inside the UI
Key settings, as they appear in SSDT.
Real screens from the Google Analytics Source product page. Step through them, or open any shot at full size.
Google Data Connection UI – Create a new Google Data connection
Create a new Google Data connection; OAuth 2.0 is the default authentication method.
Articles
Worked examples that use Google Analytics Source.
Compatibility and requirements
Designed to stay inside your SSIS runtime.
- SQL Server 2012 through 2025, 32-bit and 64-bit
- Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
- Azure Data Factory SSIS Integration Runtime
- Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
- Fully functional 30-day trial of SSIS PowerPack
FAQ
Questions teams ask before they drop Google Analytics Source on the canvas.
What is Google Analytics Source?
Google Analytics Source is an SSIS data flow source that reads Google Analytics report data without coding against the API. You can build the query in the UI, use a predefined report template, or supply a direct query URL.
Should I use OAuth 2.0 or a service account?
OAuth 2.0 is the easiest: sign in with a Google account that has access to the data (user interaction is needed once). A service account with a *.p12 certificate needs no user interaction and does not share your Google credentials, but needs an API project and the certificate stored securely on the server.
Can I read several profiles or accounts at once?
Yes. Put a comma-separated list of profile IDs in ProfileId, or filter accounts, trackers or profiles by name with regex:, for example profiles=regex:(blogs|help|test).
How do I reduce sampled data?
Set SamplingLevel to HIGHER_PRECISION and narrow the date range (for example day by day). See 3 ways to get unsampled data.
Which SQL Server versions can I run it on?
SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.
What customers say
Start your free trial today
Install SSIS PowerPack and drag Google Analytics Source onto the Data Flow.
Pull Google Analytics reports into SQL Server or any SSIS destination without writing API code.
- Data Flow Source in SSISGoogle Analytics Source appears in the toolbox after you install PowerPack.
- Fully functional 30-day trialSSIS PowerPack, running in your environment.
- Live supportHelp during your trial and after purchase.
Open Help FileBrowse all SSIS PowerPack tasks
New purchases may be eligible for refund review within 30 days. See the refund policy.
Talk to an engineer before or during your trial.