I am currently experimenting with the Supermetric connector in Google Spreadsheets to extract data from Piwik. However, I encountered some problems trying to work with segments here. Supermetrics can add a segment id to the query but nowhere in Piwik did I something corresponding. Is there such a thing as a segment id and where can I find it?
As a workaround I have already tried to recreate the segments in Supermetrics by entering the criteria from the segments as filter dimensions. However, this is very cumbersome and only produced meaningful numbers in 50% of the cases.