Hi! I'm looking to see if there is a way I can pull a report of web page visits during a certain time frame. Our VP is looking for webpage visits from yesterday between 11am and 12pm ET- is there a way to do this?
Dominique, I just came across your discussion and you can get a list of leads with web page visits in an hour by using a Visited Web Page filter with an 'Date of Activity: in past xx hours' constraint and a Not Visited Web Page filter with a with an 'Date of Activity: in past xx hours'.
A few caveats:
The list will exclude anyone that visited the page during the hour, but also visited at a later time. The further away in time you are from the evaluation period, the more inaccurate the report will be, so the ideal time to run it is immediately after the evaluation period. You can get a more accurate report by replacing the Not Visited Web page filter with a Visited Web Page filter and using the 'Date of Activity: [date]' constraints, but that only works if you want to see everyone that visited the page that day starting at noon for example.
You'll need to run the smart list / report on the start of the hour since the Date of Activity constraint doesn't allow for fractional hours.
Unless your're good at mental math, create a formula in Excel that calculates the number of hours between two different dates/times.