Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Avatar
Boost 5
Level 2
daniel_schulz
Level 2

Likes

12 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
daniel_schulz
Level 2

Likes

12 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
daniel_schulz
Level 2

29-08-2013

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