Tracking Variable Data in Email - Best Way to Track Who Was Shown What? | Community
Skip to main content
N
nhabischWings
New Participant
April 20, 2023
Solved

Tracking Variable Data in Email - Best Way to Track Who Was Shown What?

  • April 20, 2023
  • 2 replies
  • 2667 views

Hello,

Our analytics team is setting up a "Campaign Tracker" that takes activity output from the Marketo API and stores in in their system.

We have some emails that use variable data based off a Lead's record (products, etc) basically if they have A show B and if they don't have A show A type of thing. The analytics team wants to be able to track who was shown what variable data with the email.

-- Person A sees content block A
-- Person B sees content block B

Since we use Custom Object data, is there even a way to track what someone was received without making multiple variants of the email? Would it require almost a Custom Activity setup in order to push it to the activity tracking being pulled down?

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

As Darshil says, you might store copies of your Custom Objects in your data lake/analytics db and query them using the same logic that’s expressed in Velocity.

 

And in theory, rather than translating Velocity into another language, you could paste the token code as-is and use the Velocity interpreter to re-generate the output! (Not suggesting this is easy, but all else being equal, if you’re already a Java shop it’s easier than having to port all the logic to another language.)

 

I can’t see another way to reconstitute the content of an email at scale, because the Get Full Content endpoint can’t be called for everyone who received the email — you’d quickly consume all your API calls.

2 replies

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
April 21, 2023

As Darshil says, you might store copies of your Custom Objects in your data lake/analytics db and query them using the same logic that’s expressed in Velocity.

 

And in theory, rather than translating Velocity into another language, you could paste the token code as-is and use the Velocity interpreter to re-generate the output! (Not suggesting this is easy, but all else being equal, if you’re already a Java shop it’s easier than having to port all the logic to another language.)

 

I can’t see another way to reconstitute the content of an email at scale, because the Get Full Content endpoint can’t be called for everyone who received the email — you’d quickly consume all your API calls.

N
nhabischWingsAuthor
New Participant
April 21, 2023

Got it, thank you and @darshil_shah1 for the responses. I figured it wouldn't be inherently easy since tracking clicks is one thing, but tracking content on load is another.

Got some ideas to think about!

Darshil_Shah1
Darshil_Shah1
Community Manager
April 20, 2023

One way could be to extract the CO data and mimic the same VTL logic you have for content display in the analytics platform too in order to anticipate the content that a person would have received (assuming that the CO data wouldn't have updated b/w the email was sent and you pulling the CO data out of Marketo). Additionally, for the click engagements, you can use the UTMs to track the content engagements (and also anticipate what content was shown to the person based off of that!) Keen to hear if there's a simpler way to pull this off accurately as well.

 

Terms & ConditionsAccessibility statement

Loading footer...