• Jeff Moden - Wednesday, January 17, 2018 6:50 AM

    Sergiy - Tuesday, January 16, 2018 7:48 PM

    Online shopping leaves number of traces.Which can be used in police investigation in case of a fraud.In Australia till now a stranger could enter a shop, present probably stolen or lost credit card and leave the shop packed to the rafters with no security checks in the process. Except for the signature, which nobody verifies too thourouly.Life is quite relaxed over there.

    I'll say.  I used to work for a company that used feeds from DoubleClick.Net.  It's amazing that they can trace from the time that you see an ad, through all of the clicks you made to get to the purchase site, the clicks you made on the purchase site, and what your purchase eventually was.  It's actually one of the keys to prove that screen ads worked and what the cost of the ad and the payment to the site the ad was carried by should be.

    Google adwords works much the same. We use it quite extensively at our work. It is scary. We pay some money to show up in the ad section for certain keywords and they can track it all the way through the completed transaction. Truly amazing but it does require us to have some code in place on our side of things to help feed the data.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/