SSIS Google Analytics Source – Custom Dimension and Metrics

Introduction

Custom Dimensions and Metrics pretty powerful feature in Google Analytics. In this post we will learn how you can use them in SSIS Google Analytics Source

Find Dimension ID or Metric ID

SSIS Google Analytics Source dimension / metric browser doesn’t list custom Dimensions or Custom Metrics so you have to do few extra steps.

First step is to find out custom Dimension / Metric ID  (not the name). ID is usually in sequence e.g. dimension1, dimension2…. dimensionN  or metric1, metric2… metricN just confirm which ID maps to which name. Perform following steps.

1. Goto Google Analytics Admin Section.
2. Click on Admin Section (gear icon) > Select Account  > Select Property > Click on Definitions > Under that Click on Custom Dimension or Custom Metrics
3. Select desired custom dimension or metric and click to edit
4. See JavaScript code it may have ID somewhere (e.g. dimension1 or metric1).
5. Copy that ID to use it in SSIS

Google Analytics Custom Dimension / Metric – Create new, edit existing or view to obtain ID

Set Custom Dimension and Metric in SSIS Google Analytics Source UI

Browse desired Dimensions or Metrics from the UI and once that’s done then enter Custom Dimension or Metric manually. Note that you have to prefix ga::YOUR-DIMENSION

SSIS Google Analytics Source – Using Custom Dimensions / Custom Metrics