Anyone pull off an 'Multi-Touch Attribution Analysis? '
Hi All
Can anyone point me to an example, preferably SQL Server-generated of an Multi-Touch Attribution Analysis? For example...
I've pulled off a couple of SSRS reports to the effect of 'for any given event (like Purchase), count all of the other events, and give counts/%ages'.
A writeup is here. I pulled off the Cohort Analysis in an earlier question with Brian Crowe's SQL, now moving on to attribution.
I'm aware that Google Analytics has this capability, but my company's forking over 150 large isn't going to happen anytime soon.
Thanks.
Jim
Can anyone point me to an example, preferably SQL Server-generated of an Multi-Touch Attribution Analysis? For example...
For a given event, like product purchase,
Look at the past history of those customers that made a purchase, such as clicked on an email, clicked on a Facebook ad/Twitter tweet, page views, product searches, etc. All of these I'm currently sucking into a SQL database.
then look at the history of those customers that have not made a purchase,
and make inferences based on what events most lead to a purchase?
I've pulled off a couple of SSRS reports to the effect of 'for any given event (like Purchase), count all of the other events, and give counts/%ages'.
A writeup is here. I pulled off the Cohort Analysis in an earlier question with Brian Crowe's SQL, now moving on to attribution.
I'm aware that Google Analytics has this capability, but my company's forking over 150 large isn't going to happen anytime soon.
Thanks.
Jim
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
I just left the gig where this was in play, and it's not actionable to me anymore, so I'm going to share the wealth and close the question.
Thanks.
Jim