Is full length page URL available in data warehouse | Community
Skip to main content
A
angela003
Level 2
August 31, 2021
Solved

Is full length page URL available in data warehouse

  • August 31, 2021
  • 2 replies
  • 1976 views

I understand that you have to setup an eVar or prop to capture page URL in Analytics.  However, there is character limits on eVar and props and my page URLs could be super long. (I've already captured page names, but I need full length page URL as well). 

 

Isn't full Page URL supposed to be available in data warehouse without character limits?  I can't find any adobe documentation on this point.  I had a data warehouse report that used to have full page URL but that same report no longer has full page URL any more when I ran it recently.  Did I accidentally change something along the way somewhere?  I though the Page URL dimension in data warehouse is an out of box implementation.

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 angela003

The short answer is that full page URL with no character limit was available in data warehouse prior to 6/17/21.  Below is the full answer from Customer Care: 

 

From June 17, 2021, onward all report suites were updated to have Same-as-SiteCatalyst VISTA Processing set to ON in a phased manner. This change impacts Data Warehouse reporting by processing the data to match processing rules.
 
With this setting disabled the DW use to look at pre columns of raw data, i.e. at unprocessed data. However, with this enabled it looks at the post_ columns that have data after Analytics reporting logic is applied. That's why the characters from Page URL are now truncated beyond 255 char.
 
We recommend having this setting turned on to have matching numbers/consistent data between UI reports and data warehouse.
 
Here is the link to release document that mentions about this change: https://experienceleague.adobe.com/docs/release-notes/experience-cloud/previous/2021/06172021.html?lang=en

2 replies

A
AnbazhaganCTS
Level 2
August 31, 2021

Page URL in data warehouse will capture only 255 bytes. I recently run a report from data warehouse, but all are cut off at 255 using the out of the box Page URL dimension.

A
angela003Author
Level 2
August 31, 2021

I have an older report that has 400+ characters......I wonder what changed.....

A
angela003AuthorAccepted solution
Level 2
September 16, 2021

The short answer is that full page URL with no character limit was available in data warehouse prior to 6/17/21.  Below is the full answer from Customer Care: 

 

From June 17, 2021, onward all report suites were updated to have Same-as-SiteCatalyst VISTA Processing set to ON in a phased manner. This change impacts Data Warehouse reporting by processing the data to match processing rules.
 
With this setting disabled the DW use to look at pre columns of raw data, i.e. at unprocessed data. However, with this enabled it looks at the post_ columns that have data after Analytics reporting logic is applied. That's why the characters from Page URL are now truncated beyond 255 char.
 
We recommend having this setting turned on to have matching numbers/consistent data between UI reports and data warehouse.
 
Here is the link to release document that mentions about this change: https://experienceleague.adobe.com/docs/release-notes/experience-cloud/previous/2021/06172021.html?lang=en
Terms & ConditionsAccessibility statement

Loading footer...