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

[MichaelJo13]

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!

[Ankit_Chaudhary · Accepted solution]

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

[MichaelJo13]

Hi,

That worked! Thank you!