0

I need to a create a report that shows me by date at Subscriber level what links have been clicked in emails.

I can see that it's possible to produce reports to show click activity, but this isn't at Subscriber level.

I can also see that it's possible to produce a Subscriber level report that shows the number of clicks for a Subscriber, but not what they've clicked on.

Thanks in advance.

1 Answer 1

3

You can create an SQL query and get this data from the _Click Data View.

Create a Data Extension first with the required fields, and then automate the query to run daily or weekly, per your requirements.

Here's an example query:

SELECT EventDate, SubscriberKey, URL, LinkName
FROM _Click

You can also run this ad hoc in Query Studio.


Here are the fields available in the _Click Data View. Follow this link to get all the details such as data types, etc: https://help.salesforce.com/articleView?id=mc_as_data_view_click.htm&type=5

SubscriberID
SubscriberKey
AccountID
OYBAccountID
JobID
ListID
BatchID
EventDate
Domain
TriggererSendDefinitionObjectID
URL
TriggeredSendCustomerKey
LinkName
LinkContent
IsUnique

You can also download a visual representation of all Data Views here.

7
  • 1
    Quick draw @Zuzannamj strikes again! Nov 19, 2019 at 15:06
  • 1
    @zuzannamj - please leave some questions for the rest of us! Nov 19, 2019 at 15:16
  • Perfect, thank you Nov 19, 2019 at 15:17
  • all right @LukasLunow ;-)
    – zuzannamj
    Nov 19, 2019 at 15:24
  • One more question actually. Do Salesforce have anywhere a dictionary of all of the column headers one can use in an email performance report? URL, LinkName etc. I can't find one anywhere Nov 19, 2019 at 15:30

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .