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

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

  • March 25, 2025
  • 1 reply
  • 472 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!

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 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
Community Advisor
Ankit_ChaudharyCommunity AdvisorAccepted solution
Community Advisor
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

Level 4
March 26, 2025

Hi,

That worked! Thank you!