Generate a table from Activity Log that list what links are clicked and what web page are visited?

[George_Yu]

Hi, I'd like to find out what are the topics of interest from a particular account, by looking at what emails they clicked, and what web page they visited. All of our web pages are linked to Marketo and our emails are blasted using Marketo.

So for instance, can I generate a table which looks like this?

What I am doing right now is to look through the lead's Activity Log one-by-one which is a tedious process considering that we have tons of subscribers from this particular company!

If this is possible, can I filter by location or a certain email address domain?

Message was edited by George Yu: I wanted to see a table see screen shot rather than a chart.

[Josh_Hill13]

No, you cannot.

If you have RCE, you can use the EA report or Program report to possibly get closer to this. You'd have to carefully setup every Page within an Offer Program. It won't be tied to the Email necessarily...but it might be possible to do this with the right Program statuses and setup.

You can use UTMs and paired fields to try to tag this more by lead or Program. You could also download data using the Bulk API to analyze in Tableau.

You can run Email Link Performance reports and then export the link data, but it wouldnt be tied to people.

[Dan_Stevens_ · Accepted solution]

As Josh said, using the EA report in RCE should get you close to what you're looking for (although you won't be able to include any "visits to landing page" activity as that would require a different type of report (Program Membership Analysis).  This is just one example - there are lots of other options depending on how you want to depict your data

[Ryan_Vong7]

Hi George,

I'm interested in the question you are trying to solve for several reasons. We actually have a tool that aggregates activity data and graphs it. I'm curious on what you are trying to graph based on the description. Is it mainly to see across all the emails you send out (email a,b,c,d,e)  the aggregate number of people that clicked on each one or the number of clicks on each email? I could click on email a 1K times and count those but it's only 1 person doing that.

For web page visit, is it something like this? The "visits" are counts of each time that url is seen in the activity log.

Check out: OMEGA – Automation Intelligence

[George_Yu]

"Is it mainly to see across all the emails you send out (email a,b,c,d,e)  the aggregate number of people that clicked", yes, I would like it to be tied to their emails.

Sorry, what I meant was a table rather than a chart. So the column will show their email address, and the rows will show the web page visited, and the email content clicked. Is that possible?