2 Replies Latest reply on Oct 20, 2016 5:18 PM by Jay Patel

    Data Blending Help

    Jay Patel

      Running into a problem when trying to blend two data sets together by date.

       

      One data set is top line historical data that we've been collecting in Adobe Analytics, and I've just dumped out needed data by date into Excel. Second data set is top line data from Google Analytics (live connection).

       

      End goal is to blend these data sets together so that i can do YoY comps, for example comparing traffic July 2015 from Adobe v. July 2016 data from google.

       

      The dates in both data sets are formatted exactly the same and I'm able to link them, but when i try to create a calculated metric that combines unique visitors + users I'm left with no results prior to July 2016.