Report Builder - Using Cell Ranges as Filters

[edward_finn]

Hello All,

I'm building a Report Builder request which requires that a filter for campaign ids be constantly updated. One of my proposed solutions to having ongoing campaign tag parameters included was to make the report builder event refer to a range of cells using the 'contains one of' filter of continually add campaign parameters to the column I had chosen.

When attempting to do this I have found that Report Builder is unable to accept a range of cells. Single cells work, but there's no way to fit this volume of campaign tags in a single cell.

Has anyone managed to reference a range of cells as a 'contains one of' filter?

[brian_au]

Hi Edward,

At this time Adobe Report Builder only accepts a single cell filter reference for a given data block. A workaround would be you could create many duplicate versions of the same data block in Excel with single references and then do combination work in Excel to accomplish the goal of having multiple filters. If you have feedback/ideas to improve cell filtering I would encourage voting or entering a post in the Adobe Idea Exchange.

Best,

Brian

[JillsMatthew · Accepted solution]

You can include a SAINT classification for your tracking codes and create an auto classification rule to group all your required campaign ids with a unique name. (e.g. if campaign_id contains xyz, set the value of SAINT field = 'Repor Builder Group').

Once this is set up, you can use the SAINT field to create your segments or filter values