Can you find out (through a smart list or similiar) when the munchkin cookie was first dropped on a visitor? | Community
Skip to main content
S
Sarah_Hare
New Participant
July 31, 2017
Solved

Can you find out (through a smart list or similiar) when the munchkin cookie was first dropped on a visitor?

  • July 31, 2017
  • 2 replies
  • 3015 views

I'm wanting to look at and try and work out some typical client paths through our website for visitors and for those that went on to become clients.

Is it possible to reference a field in Marketo that will tell me the date someone first visited our site? Created seems to be the date they identified themselves to us rather than when they first visited...

Hoping someone can assist.

Thank you in advance.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

Is it possible to reference a field in Marketo that will tell me the date someone first visited our site?

Yes and no. You can create such a field, call it onSiteSinceDatetime, and fill it automatically going forward, but you would need to backfill your existing leads. You'd do this by extracting the Cookies field.

The key to the process is that the _mkto_trk cookie itself contains the millisecond timestamp you want.* So you can convert that to a Datetime and upsert it onto the lead. 

* Unless you're customizing the cookie, which is almost never done except for by crazy people like me.

2 replies

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
July 31, 2017

Is it possible to reference a field in Marketo that will tell me the date someone first visited our site?

Yes and no. You can create such a field, call it onSiteSinceDatetime, and fill it automatically going forward, but you would need to backfill your existing leads. You'd do this by extracting the Cookies field.

The key to the process is that the _mkto_trk cookie itself contains the millisecond timestamp you want.* So you can convert that to a Datetime and upsert it onto the lead. 

* Unless you're customizing the cookie, which is almost never done except for by crazy people like me.

Josh_Hill13
Josh_Hill13
New Participant
July 31, 2017

You can see Anonymous to Known info on the record usually because the log entries go further into the past than their Known or FOF date.

But you have to dig into that. I believe there is info in the Anonymous Tracking deprecation from 2016.

You may be able to use the munchkin API to better manage the data to be visible for you. The bulk API could extract this data and let you analyze it.

SanfordWhiteman
SanfordWhiteman
New Participant
July 31, 2017

The bulk API could extract this data and let you analyze it.

Lotta work to go back years just for this.

Terms & ConditionsAccessibility statement

Loading footer...