Answers.Body: <p>This will be possible with SearchKit soon. Mail clicks was just added to APIv4 and SearchKit last week: <a href="https://github.com/civicrm/civicrm-core/pull/26016" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/26016</a></p>
  <p>So you won't be able to use it yet, but it will be possible soon.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-04-16T19:56:53.560Z
Answers.LastActivityDate: 2023-04-16T19:56:53.560Z
Answers.UserDisplayName: Lars SG
Body: <p>Here is the scenario: We send daily news updates, they are all assigned the same campaign. I want to be able to see what was the most clicked URL for a given campaign.</p>
  <p>Currently I have to export the mail clickthrough report and use the countif and unique functions in excel but that comes with its challenges.</p>
  <p>Is there a built in or extension report that I can build something like this?</p>
  <p>Wordpress 6.2 and CiviCRM 5.59</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-04-05T19:55:58.900Z
Comments.Text: Have you looked at SearchKit which is fast becoming the answer to many 'is it possible' type questions :-)
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-04-07T16:19:44.840Z
Comments.Text: I did - but what would I be searching for? There does not seem to be an option for tracked URLs in emails.
Comments.UserDisplayName: themak
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-04-07T19:55:05.743Z
Comments.Text: i really don't know. looks like there are these couple of tables involved: civicrm_mailing_event_trackable_url_open and civicrm_mailing_trackable_url
Comments.UserDisplayName: petednz - fuzion
Tags: <civimail><civireport><urls><links><tracked-links>
Title: How Do You Generate a Report for Number of Mail Clickthroughs and What The Most Popular Links Were For a Campaign
ThreadText: # How Do You Generate a Report for Number of Mail Clickthroughs and What The Most Popular Links Were For a Campaign
  
  (Asked by: username_0 on 2023-04-05)
  
  Here is the scenario: We send daily news updates, they are all assigned the same campaign. I want to be able to see what was the most clicked URL for a given campaign.
  
  Currently I have to export the mail clickthrough report and use the countif and unique functions in excel but that comes with its challenges.
  
  Is there a built in or extension report that I can build something like this?
  
  Wordpress 6.2 and CiviCRM 5.59
  
  **Tags:** civimail, civireport, urls, links, tracked-links
  
  > **Comments:**
  > **username_1**: Have you looked at SearchKit which is fast becoming the answer to many 'is it possible' type questions :-)  
  > **username_0**: I did - but what would I be searching for? There does not seem to be an option for tracked URLs in emails.  
  > **username_1**: i really don't know. looks like there are these couple of tables involved: civicrm_mailing_event_trackable_url_open and civicrm_mailing_trackable_url  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2023-04-16. Score: 2 | Accepted answer
  
  This will be possible with SearchKit soon. Mail clicks was just added to APIv4 and SearchKit last week: <https://github.com/civicrm/civicrm-core/pull/26016>
  
  So you won't be able to use it yet, but it will be possible soon.
  
  
  ---
  
  