Consider the following as a text representation of your original database source table.
ID EmailAddress FirstName LastName 1 bobsmith@yourdomain.com Bob Smith 2 janehooper@yourdomain.com Jane Hooper To insert information into a new table use an insert statement, the built-in merge fields that can be used for Click-Throughs include: {CAMPAIGNID},{UNIQUEID}, {CLICKTHRUNUMBER}, {REMOTEADDRESS} and {EMAILADDRESS}. Sample Syntax: INSERT INTO ClickThroughInfo (CAMPAIGNID,UNIQUEID,Event,CLICKTHRUNUMBER,REMOTEADDRESS,EMAILADDRESS) VALUES ({CAMPAIGNID},{UNIQUEID},'Click',{CLICKTHRUNUMBER},'{REMOTEADDRESS}','{EMAILADDRESS}') ClickThroughInfo Table - Before Bob Smith or Jane Hooper have clicked on a click through. CAMPAIGNID UNIQUEID Event CLICKTHRUNUMBER REMOTEADDRESS EMAILADDRESS ClickThroughInfo Table - After Bob Smith clicked on a click through number 1 from campaign number 7, and click through number 3 from campaign number 2, and Jane Hooper clicked on click through number 11 for campaign number 5. CAMPAIGNID UNIQUEID Event CLICKTHRUNUMBER REMOTEADDRESS EMAILADDRESS 7 1 Click 1 200.235.68.74 bobsmith@yourdomain.com 5 2 Click 11 12.45.74.1 janehooper@yourdomain.com 2 1 Click 3 200.235.68.74 bobsmith@yourdomain.com Click-Through Tracking Stored Procedure To run a stored procedure each time a click through is recorded, create the stored procedure on the database, then execute the stored procedure from the stored procedure field for open tracking. Example: EXECUTE dbo.ClickthroughSP You can now also use the {URL} merge field to pass the URL for the click through back to some field in your table.
0 Comments
Leave a Reply. |
Archives
December 2017
Categories
All
|