14 Replies Latest reply on Oct 23, 2013 7:06 AM by Joshua Milligan

    Combining multiple Google Analytics sources on one sheet and adding Source Name as a dimension

    anna.lobanova

      Hello community,

       

      I am struggling with the following:

       

      How can I create an extra dimension with the source names when connecting the same measures for the same date range from multiple Google Analytics (GA) sources on one sheet? 

       

      This is what I have:

       

      GA Data Sources:

      GA apples

      GA pears

      GA oranges

      Dimensions:

      Date

      Measures:

      Pageviews

      Visits

       

      This is what I get when I create relations between the GA sources:

      weekpageviewspageviews
      week 191030
      week 182052
      week 16936
      week 151442
      week 141323

       

      What I need to have is another dimension with the name of the source like this:

       

      weekpageviews

      OrangesApples
      week 191030
      week 182052
      week 17936
      week 161442
      week 151323
      week 14

       

       

      Thank you in advance for any tips.

      Anna