Skip to content

Instantly share code, notes, and snippets.

@naveenvm93
Created October 11, 2019 09:23
Show Gist options
  • Save naveenvm93/dbf9efe88e2d0a0e2d3128173b763cf3 to your computer and use it in GitHub Desktop.
Save naveenvm93/dbf9efe88e2d0a0e2d3128173b763cf3 to your computer and use it in GitHub Desktop.
This is used to track Journey Emails from Google Sheets
<script runat="server">
Platform.Load("Core", "1.1.1");
try {
var paramtskey = Request.GetQueryStringParameter("tskey");
var parammetric = Request.GetQueryStringParameter("metric");
if (parammetric === "all") {
var tsd = TriggeredSend.Init(paramtskey);
var triggerSendTracking = tsd.Tracking.Retrieve();
var tsTracking = Stringify(triggerSendTracking);
if (tsTracking.length > 2) {
var outputmetric = Stringify(triggerSendTracking);
} else {
var outputmetric = '{"CustomerKey":"' + paramtskey + '"}';
}
}
else {
var outputmetric = '{"Name":"0","Unique":"0"}';
}
Write(outputmetric);
} catch (ex) {
Write("error message: " + ex);
}
</script>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment