I had the exact same issue, Here is what you can do. If you are trying to use your personal MS office suite/ laptop then you can just install it as a add on from the excel add-ons However if companies suite/laptop you would have restrictions that might not let you add an add-on that easily. You need...

The “Average Time on Site (Total)” value (e.g., 00:09:16) is not the average of the visible line item values. Instead, Adobe calculates this value by dividing the total time spent (sum of time between hits across visits) by the number of visits where time could be calculated — i.e., excluding bounce...

Its hard to determine where this could be happening. But its good to check the following - Confirm eVar1 = xyz.com is sent in the actual hit to Adobe Analytics (via debugger).Ensure the rule setting eVar1 runs on every relevant page/event.Check for other rules or custom code that may overwrite eVar1...

The new connection map interface has nice UI and easy review. Eagerly waiting to play with the commenting feature. 

I am trying to track exit links in websdk but even though I have enabled everything I am not able to see it.  Please let me know what else needs to be done 

Agreed!  definitely some limitations. It totally depends on the use case and character limit and which implementation style you wanna do, so Trying different approaches could work. 

Why dont you map the evar from adobe analytics to the equivalent one to schema in custom code? 

the max number of rows you can download is 400 at a time or use data warehouse. But datawarehouse might be tricky if you are using calculated metrics/segments. Sometimes it wont be available. You can also do it through datafeed setup. But unless its a one time thing I would rather do the 1st approac...

Instead of eVars why dont you use props ? Props (traffic variables) are hit-based, so they record the value exactly at the time the page loads. This makes them ideal for your use case: tracking how many page views had filters like color, size, price, etc. applied.s.prop10 = 'color|size';Split the st...

As far I have seen, You cannot migrate calculated metrics. However you can map the underlying segment/metric with adobe to CJA and then recreate it in Sharedmetrics in CJA. Let me know if this works.