Answers.Body: <p>There is currently no date filter on the mailing reports.</p>
  
  <p>Adding date filters to the mailing reports and submitting a patch back to core would be one way to solve your problem. <a href="https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Mailing/Clicks.php" rel="nofollow">https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Mailing/Clicks.php</a> shows the code that generates the clickthrough report. Adding a date filter to that <em>might</em> not be too difficult to do.</p>
  
  <p>It would end up being similar to the date time filter in the activity report: like the <a href="https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Activity.php#L261" rel="nofollow">https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Activity.php#L261</a> but from the looks of things you'd have to do a bit more playing around with the Report class than just adding it.</p>
  
  <p>The mysql tables you are looking for are <code>civicrm_mailing_event_trackable_url_open</code> (which has a timestap) and <code>civicrm_mailing_trackable_url</code></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-31T21:40:48.450Z
Answers.LastActivityDate: 2016-10-31T21:40:48.450Z
Answers.UserDisplayName: michaelmcandrew
Body: <p>long time user of civicrm. Have 4.7.6 installed on Drupal 7 in a linux environment and I'd like to look at an old email's metrics. I see I pull up specific URL click-through metrics, but it shows me ALL the clicks since I sent out the email to-date. I'd like to filter those results to only include a specific date range, but am having difficulty in finding how to do this. I would even be comfortable exporting all the results myself and then filtering in excel, but the export doesn't include dates at all. Am I the only one who needs this kind of thing? If I have to go into the DB tables to find what I'm looking for, where can I find it?</p>
  
Tags: <civimail><reports><dates><click-through>
Title: How can I filter click-through reports by date range?
ThreadText: # How can I filter click-through reports by date range?
  
  (Asked by: username_0 on 2016-08-18)
  
  long time user of civicrm. Have 4.7.6 installed on Drupal 7 in a linux environment and I'd like to look at an old email's metrics. I see I pull up specific URL click-through metrics, but it shows me ALL the clicks since I sent out the email to-date. I'd like to filter those results to only include a specific date range, but am having difficulty in finding how to do this. I would even be comfortable exporting all the results myself and then filtering in excel, but the export doesn't include dates at all. Am I the only one who needs this kind of thing? If I have to go into the DB tables to find what I'm looking for, where can I find it?
  
  **Tags:** civimail, reports, dates, click-through
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-10-31. Score: 1
  
  There is currently no date filter on the mailing reports.
  
  Adding date filters to the mailing reports and submitting a patch back to core would be one way to solve your problem. <https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Mailing/Clicks.php> shows the code that generates the clickthrough report. Adding a date filter to that *might* not be too difficult to do.
  
  It would end up being similar to the date time filter in the activity report: like the <https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Activity.php#L261> but from the looks of things you'd have to do a bit more playing around with the Report class than just adding it.
  
  The mysql tables you are looking for are `civicrm_mailing_event_trackable_url_open` (which has a timestap) and `civicrm_mailing_trackable_url`
  
  
  ---
  
  