CiviCRM Community Forums (archive)

Is this something that's remotely possible? I'm not seeing any criteria that would allow us to filter the clicks by date range. For example, if I have an email I sent out in 2014, and ONLY want to show me the metrics contained within that year, I am unable to do that. I can see ALL the clicks that have ever happened for that mailing since I sent it out to "Today's" date (ie, the date I ran the report) - which is helpful in the larger sense, but not if I want to see how click patterns progress over time. I've tried just extracting the following tables:
civicrm_mailing
civicrm_mailing_job (<-- this table may be unnecessary)
civicrm_mailing_trackable_url
civicrm_mailing_event_trackable_url_open (<-- this at least timestamps each click)

Any direction on this would be GREATLY appreciated.