Click report by Click activity (SMC)

Question

everyone! I have another question and hope for your assistance.

Intro: Our SMC platform has a "Tracking" section where we can view analytics for campaign sends. In this analytics, we can download a table showing the counts of unique clicks on the email (in Overview). We find the analytics we need in the "Click Activity" section, but I am unsure how to download it along with the required data.

Question: Are there any methods(SQL queries) to create a Data Extension (DE) that contains all the data from "Click Activity" related to clicks, including the Subscriber key, email, click time,id, link, total and unique clicks in the table?

Answer 1

What you are looking for is most probably _Click Data View. It holds all clicks made by your subscribers across all emails. You can join this with the _Job Data View, to identify jobs which sent specific emails, if you want to limit the clicks to only those coming from some of your emails.

The last use case can be achieved with a query similar to this:

SELECT
c.*
FROM _Click c
INNER JOIN (
    SELECT 
    JobID
    ,EmailName
    FROM _Job 
) j ON j.JobID = c.JobID
WHERE j.EmailName = 'Email Name'

Remember, _Job Data View is the only data view that is specific to a particular Business Unit.