Not getting values in AvgSessionDuration Metric field using Google Analytics CodePlex Plugin

Oct 9, 2015 at 8:21 AM
Hi All,

Using CodePlex Google Analytics Plugin(SSIS GoogleAnalytics Source 2014.msi) I am not getting data in few metric fields like AvgSessionDuration, AvgTimeOnPage and TimeOnPage. There fields are getting only blank values(NULL).

I have checked on my website directly that these fields are having values in time datatype format like 00:19:53. I got data for many dimensions and metrics fields but facing challenge with these fields only.

I will appreciate if someone can help here.

Thanks,
Sachin
Oct 9, 2015 at 4:59 PM
Edited Oct 9, 2015 at 5:07 PM
Well, i am replying to my own thread. The issue was with the Metric.xml i had. These columns are defined as DT_WSTR with no length. Length is something which is missing and caused the issue. I had to just modified the length to 255 and it worked fine.

<Length>255</Length>