Dynamic visit segment based on campaign - Report Builder | Community
Skip to main content
October 16, 2015
Solved

Dynamic visit segment based on campaign - Report Builder

  • October 16, 2015
  • 1 reply
  • 737 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by BrianAu1

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

1 reply

BrianAu1Adobe EmployeeAccepted solution
Adobe Employee
October 16, 2015

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