Dynamic visit segment based on campaign - Report Builder

[theerookie]

Hey guys,

Is it possible (in report builder) to run a report for page views, uvs etc, based on a campaign segment which gets the campaign number from a cell in Excel? That way instead of needing to create multiple segments for each campaign you want to report on, you can just enter the new campaign number in Excel and refresh the query.

Cheers

[brian_au · Accepted solution]

Hi,

You can build a data block for campaign tracking dimensions that reference an Excel cell that then filters the full request. So it depends on the specifics of the type of data block you want to build, but that may be sufficient and certainly provides a dynamic way to adjust a data block via one cell look up.

https://marketing.adobe.com/resources/help/en_US/arb/options.html

>>>

Interprets a typed value in a filter control as a cell location before considering it a filter expression.

For example if you create a Top 10 Page request, using a filter shoes, the request would display a cell containing something similar to:

Filter: Top 1-10 Page, Page contains Shoes

Best,

Brian