Remove Metrics Remove PPC Remove SQL
article thumbnail

Multichannel Analytics: Tracking Offline Conversions. 7 Best Practices, Bonus Tips

Occam's Razor

This means we can join the two tables with simple sql and understand which online shoppers ended up making a purchase offline (and what keyword they used to arrive on your site): Boom! The two tables above have something in common, a primary key (Geek ID). Nice ain't it?

Analytics 116
article thumbnail

Empowering Analysis Ninjas? 12 Signs To Identify A Data Driven Culture

Occam's Razor

An example is: "We should add these 80 keywords to our PPC portfolio with a max bid of $14." They are generic mash-ups that tailor to almost no one's needs, and more often than not contain awful things like nine not-really-thought out metrics for one dimension in a report. " Kisses. Angels singing! Time on Site!

Analytics 142
article thumbnail

How Machine Learning Can Finally Solve “(direct)/(none)”

ConversionXL

Train your model: I share sample SQL code in my prior article that covers, for example, how to train a model on users’ probability to buy in the next seven days. You can test this via “model evaluation ,” which uses ROC/AUC metrics. Fold in contextual data, like user device, region, screen resolution, etc.