Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Reportbuilder: using wildcards in Excel cells, when selecting data "From range of cells"

Avatar

Level 2

8/29/13

Hello! In Ad Hoc Analysis (Reportbuilder), we create often reports, where content of  "Dimensions" is placed in Excel cells. When the content is unique (for example special LinkIDs), it is very comfortable with Ad Hoc Analysis. In case having a list with content, where unique content is not needed / desired and working with wildcards (LinkID "contains" for example the channel-information) would be sufficient to subsume data, it is currently not possible to point to a list in Excel.

 

Example "Dimension 'Linktracking'": we would like to track the clicks on a LinkID named "hd.mainnav.abc"; in this example, the same LinkID has several channel-characteristics ...

 

FP|www.example.de||AC:lead.hd.mainnav.abc
FP|www.example.de||lead:def.hd.mainnav.abc
FP|www.example.de||PS:def.hd.mainnav.abc

 

 

To subsume the clicks just on the LinkID and not on spreaded on differenct channel-characteristics, we would like to insert just this information in an Excel cell:

 

FP|www.example.de||*hd.mainnav.abc

 

 

This improvement would be very helpful, when we use a huge list of expressions with wildcards.

 

Best regards

Daniel Schulz