Combine or summarize Facebook URLs traffic to a single Row. | Community
Skip to main content
JohnRog
JohnRog
Level 2
May 11, 2021
Solved

Combine or summarize Facebook URLs traffic to a single Row.

  • May 11, 2021
  • 2 replies
  • 2123 views

Is there a way to customize a free form table to summarize/combine a group of URLs with parameters such as Facebook and show them as one entry? I want to be able to do this within Adobe Analytics workspace area and not have to export the data. Is using Page name the only other option?

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 brentrad

You can set up a classification for the variable in your report suite and then use Classification Rule Builder, as the moderator has indicated.

An alternative is to create a segment in which the value of the variable includes a particular parameter. For example, a visit segment in which the entry variable (e.g. Page Name, if an s.prop) contains "facebook" (see screenshot for an example of how you could set this up).

Next, you can drop this segment into a blank freeform table, just as you would a dimension (see screenshot below).

The drawback here is that you cannot combine segments and dimensions in the same table axis, so if you wanted to compare Page Names that included "Facebook" to pages that did not or pages that included other text, you'd need to create additional segments. You'd face a similar issue with the classification approach in that any variable value that doesn't meet the requirements for your Facebook RegEx will be labeled as "Unspecified" in the table.

2 replies

PratheepArunRaj
Community Advisor and Adobe Champion
PratheepArunRajCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
May 11, 2021

Dear John,

1. Yes, Page Name is the best option to use when your want to remove the Query String Parameter.

2. If Page Name is something you need to configure newly, then you can use Classification Rule builder to extract the URLs without the Query String Parameter. 

Regex : ^(.+)\?(.+)$ 

Value : $1

After applying the rule, you can use the Classification value.

2. You can create segments, but you need to create unlimited segments and thus it is not a feasible option.

Thank You, Pratheep Arun Raj B | Xerago | Terryn Winter Analytics

Thank You, Pratheep Arun Raj B (Arun) | Xerago | Terryn Winter Analytics
B
brentradAccepted solution
Level 5
May 11, 2021

You can set up a classification for the variable in your report suite and then use Classification Rule Builder, as the moderator has indicated.

An alternative is to create a segment in which the value of the variable includes a particular parameter. For example, a visit segment in which the entry variable (e.g. Page Name, if an s.prop) contains "facebook" (see screenshot for an example of how you could set this up).

Next, you can drop this segment into a blank freeform table, just as you would a dimension (see screenshot below).

The drawback here is that you cannot combine segments and dimensions in the same table axis, so if you wanted to compare Page Names that included "Facebook" to pages that did not or pages that included other text, you'd need to create additional segments. You'd face a similar issue with the classification approach in that any variable value that doesn't meet the requirements for your Facebook RegEx will be labeled as "Unspecified" in the table.

    JohnRog
    JohnRogAuthor
    Level 2
    May 13, 2021
    I did not have admin access to use classifications so I opted for creating segments. This was very helpful and I greatly appreciate it!
    Terms & ConditionsAccessibility statement

    Loading footer...