Scribd
Upload
5 views1 page

Triggered Email Tracking Code

The document contains AMPscript code that retrieves rows from a data extension based on specific criteria related to email sending. If matching rows are found, it extracts certain fields to construct an image URL for tracking purposes. If no rows are found, the script ends without performing any actions.

Uploaded by

Vikas Srivastava
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
5 views1 page

Triggered Email Tracking Code

The document contains AMPscript code that retrieves rows from a data extension based on specific criteria related to email sending. If matching rows are found, it extracts certain fields to construct an image URL for tracking purposes. If no rows are found, the script ends without performing any actions.

Uploaded by

Vikas Srivastava
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

%%[

Set @trigsendrows = LookupRows("DomainAffinity_DayWise_Trig","FromEmail",


@fromemail , "SentDate", FormatDate(SystemDateToLocalDate(Now()), "yyyy-mm-dd"))

Set @numtrigsendrows = RowCount(@trigsendrows)


if @numtrigsendrows > 0 then

Set @trigsendrow = Row(@trigsendrows, 1)


Set @trigextkey = Field(@trigsendrow, "Trig1ExternalKey")
Set @trighpcid = Field(@trigsendrow, "Trig1CID")

]%%

<img src="[Link]
%=Substring(replyemailaddress,Add(IndexOf(replyemailaddress,'@'),1))=%%/v6/[Link]?
key=%%=v(@trigextkey)=%%&orig_jobid=%%jobid%%&orig_jobid_date=%%=Format(@sentdate,
"yyyy-MM-dd HH:mm:ss tt")=%%&orig_acct=et4b&orig_hpcid=%%=v(@hpcid)=%%&source=%
%source%%&email=%%emailaddr%%&hash=%%=MD5(emailaddr)=%%&first_name=%%first_name%
%&last_name=%%last_name%%&address1=%%address1%%&city=%%city%%&state=%%state%%&zip=%
%zip%%&car_year=%%caryear%%&carmake=%%carmake%%&carmodel=%%carmodel%%&usedcar=%
%usedcar%%&credit_rating=%%credit_rating%%&loan_type=%%loan_type%%&va_eligible=%
%va_eligible%%&ip=%%ip%%&hpcid=%%=v(@trighpcid)=%
%&trig_type=prodopen&acctname=et4b&accttype=et" height="1" width="1" />

%%[ else
endif ]%%

_ssimg

-MainT

[Link]
[Link]
[Link]
[Link]
[Link]

You might also like