Calculated Metric Builder | Community
Skip to main content
J
Jamie8989
February 24, 2023
Solved

Calculated Metric Builder

  • February 24, 2023
  • 1 reply
  • 1601 views

Hi there, 

 

Apologies if this has been asked before.

 

I'm looking for a way to add date ranges into a metric I am trying to calculate - When I try to natively go straight into "Metrics it doesn't offer date ranges"

 

Does that mean I will need to great a segment first to include the date range there and then pull that into the metric 

 

I.e Vists (today) - Visits (Yesterday) = number

 

Thanks in advance

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

Is your page ID an eVar? Is it being set on Actions as well as Page Views?

 

I just tested this.. I used both standard page dimension and yesterday, AND my 'page name' eVar and Yesterday, the values match for me in both cases... 

 

BUT, did you try just creating a segment that is just date based? Then stack with your dimension?

 

 

 

However, if you are always comparing Today vs Yesterday; why don't you just create this:

 

 

Then select those two columns, right click, "Create metric from selection"

 

 

Then select "Divide" or "Percent Change"

 

 

To end up with this:

 

 

 

Though, I will caution the use of comparing "Today" with anything else; since "Today" (unless you are checking at the data right before midnight) will always be a partial day of data, so the comparison will always look bad... (full day vs partial day). You might be better off testing "Yesterday" with "2 Days Ago" so you are at least comparing a full set of data...

 

 

There are reasons to have date logic built into calculated metrics, I am not sure if this scenario needs it....

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
February 24, 2023

That is currently how I do it... since you are correct... Date Ranges don't appear to be available directly in calculated metrics

J
Jamie8989Author
February 24, 2023

Thank you for the clarity on thie Jennifer, one observation you may be able to help answer, for what ever reason when I pull in the Page_ID and the date i.e. Yesterday and 2 Days Ago to create two seperate segments, the number I am given on this new segment differs by to the original Page_ID (if I were to just create a view in a blank panel with Page_ID(Name) in the Dimension section and (Visits and Yesterday) in the Metric section - Does this make sense and any reason for this behaviour?

 

i.e. if i manually pull the number for Page_ID (Name) with Visits and Yesterday i Get 11,000

but 

If I make a segment for the same thing (excluding visits as it already has that added in the segment break down) I get 10,900

 

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
February 24, 2023

Is your page ID an eVar? Is it being set on Actions as well as Page Views?

 

I just tested this.. I used both standard page dimension and yesterday, AND my 'page name' eVar and Yesterday, the values match for me in both cases... 

 

BUT, did you try just creating a segment that is just date based? Then stack with your dimension?

 

 

 

However, if you are always comparing Today vs Yesterday; why don't you just create this:

 

 

Then select those two columns, right click, "Create metric from selection"

 

 

Then select "Divide" or "Percent Change"

 

 

To end up with this:

 

 

 

Though, I will caution the use of comparing "Today" with anything else; since "Today" (unless you are checking at the data right before midnight) will always be a partial day of data, so the comparison will always look bad... (full day vs partial day). You might be better off testing "Yesterday" with "2 Days Ago" so you are at least comparing a full set of data...

 

 

There are reasons to have date logic built into calculated metrics, I am not sure if this scenario needs it....

Terms & ConditionsAccessibility statement

Loading footer...