How to get the goal name or goal ID from Google Analytics in SSIS?

user_17843695 0
Viewed 92

Is it possible to get the goal name or goal ID from the Google Analytics Source task (ZappySys) in SSIS?

I've been searching for it for a long time now and I just can't find it in the Dimensions or Metrics from the task.

I also tried to use the eventAction Dimension from the task, but the goalCompletionAll is not showing the same results from the website.

The Dimensions I've been using to compare are Source, eventAction and the Metric goalCompletionsAll.

google-analytics-api google-analytics ssis visual-studio sql-server
1 Answers

You cannot get the name of the goal, but you can get the specific goal value through its id (that you can see in the panel) using ga:goalXXCompletions.

Also, you cannot compare event actions and goals because they are different scopes, the first is at the hit level while the second is at the session level, for this reason you get different numbers.

user_56402000
Related