Create workspace project which contains segment and prop data in one form

Within our Adobe Analytics, we have created the following data within the reports to be tracked:

pageurl (prop7)

pageurl (evar7)

These contain all URLs which were clicked to access the tracked website.

Now, I have also created a segment (in table below called "Short-URLs") which contains all short URLs which make then a redirect to the target URL.

Example: The segment contains http://www.abc.com/promotedproduct and https://www.abc.com/promotedproduct (which then redirects to www.abc.com/products/overview/productarea/promotedproduct.html)

We only want to know how often our promoted short URLs are clicked.

Unfortunately, when creating a project in the workspace with this segment, I get no results. I have tried to combine it with the pageurl (prop7), but I couldn't find any set up possibility to get results which can be then sent automatically every month

I'd like to have a table like this:

I prefer the workspace more than the data warehouse because the sent reports are much prettier.

EDIT: When I combine my segment with occurences, I can only see the total number for all clicked URLs within this segments, but no details for each URL.