Can I retrieve metrics for articles published in the last week (or month)? | Community
Skip to main content
pats60904623
July 8, 2022
Solved

Can I retrieve metrics for articles published in the last week (or month)?

  • July 8, 2022
  • 1 reply
  • 1418 views

My organization publishes multiple articles every day. Is it possible to set up a search or dashboard to see metrics only on articles published in the last 7 days, or the last month?

 

Thanks for any suggestions.

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 Jennifer_Dungan

Lol, yeah, that is similar to our manual hier rules that I mentioned... since our "pubdate" prop also includes a timestamp (using ISO standardized datetime formatting - so that our data team can process the information more easily), I could try to use a bunch of "contains" instead of equals like you have, or use the hier which is locked into year, month and day values.

 

Very similar solutions, but both completely manual... 

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 8, 2022

This is tricky since dimensions are text based, meaning you can't really pass a publication date as a "date" and use before/after logic....

 

I'm in a similar situation... Right now, I do track a publication date timestamp in a prop, this is more useful to our data lake that can process this as a timestamp.

 

But I also use one of our hierarchy variables in this format:

year|month|day|article title

 

I still can't create a "rolling" report using this, but I can use segments to pull out content based on the year, month and day to pull out content published within a certain window.

 

So if I wanted to pull out last 7 days right now, I would look for hier level 1 (year) equals "2022", and hier level 2 (month) equals "07" and hier level 3 (day) in "01,02,03,04,05,06,07"

 

If the date range rolls over a month, I use sub-containers to look for month "06" and day in "28,29,30" OR month "07" and day in "01,02,03...."

 

If you don't have a data lake, if your pubdate dimension uses a standard date format, you could use Excel Report Builder, and cast that text field to data and create a rolling report in Excel. You can use Excel's build in data formulas to determine the range based on today's date, and once the text field is cast as a date do comparisons to check if it falls inside the range.

pats60904623
July 11, 2022

Thanks for answering my question, Jennifer. I appreciate your taking the time.

 

A colleague had a different approach. She created a segment (that must be manually updated) that displays metrics for articles published in the past week. Here's a screenshot.

 

Not elegant, but it gets the job done!

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
July 11, 2022

Lol, yeah, that is similar to our manual hier rules that I mentioned... since our "pubdate" prop also includes a timestamp (using ISO standardized datetime formatting - so that our data team can process the information more easily), I could try to use a bunch of "contains" instead of equals like you have, or use the hier which is locked into year, month and day values.

 

Very similar solutions, but both completely manual...