CJA Workspace -Create Calculated Metric to Assign Page Name to a few URLs | Community
Skip to main content
New Participant
March 25, 2025
Solved

CJA Workspace -Create Calculated Metric to Assign Page Name to a few URLs

  • March 25, 2025
  • 1 reply
  • 469 views

Hi,

I'm very new to reporting in CJA and AA. I'm a developer, not an Analyst. My issue is, I ran a page name report and there were a few with "No Values" This was due to a change in the logic that creates the page names. Most page names were ok but there are ten that I need to include that didn't have their page names reported. I have the URLs and page names in an excel so I know what page names correspond to which URLs. I need to create a calculated metric that assigns the page name to the URL in the Page Name report. I know I have to create some type of calculated metric using functions but I'm currently struggling on how to do this. Can anyone please help me through this.

 

Thanks!

Best answer by Ankit_Chaudhary

Hi @michaeljo13 

 

You can try creating a derived field in the Data View > Component settings using case when logic based on page URL dimension.

Check this for more details Derived Fields in CJA

1 reply

Ankit_Chaudhary
Ankit_ChaudharyAccepted solution
New Participant
March 26, 2025

Hi @michaeljo13 

 

You can try creating a derived field in the Data View > Component settings using case when logic based on page URL dimension.

Check this for more details Derived Fields in CJA

New Participant
March 26, 2025

Hi,

That worked! Thank you!