microsoft / r-server-campaign-optimization

Campaign optimization solution with SQL Server ML Services

Campaign Optimization - Predicting How and When to Contact Leads

Being able to optimize when and how to contact potential customers improves success rates and customer experience.
This is an important scenario in many industries, including Retail, Services and Finance. This solution provides a way to optimize marketing campaigns targeting leads.

Deploy to Azure on SQL Server

More samples and information

Discover more examples at Microsoft Machine Learning Server

For all documentation, visit the Campaign Optimization website.

NOTE: Please don't use "Download ZIP" to get this repository, as it will change the line endings in the data files. Use "git clone" to get a local copy of this repository.

Contributing

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

r-server-campaign-optimization's Issues

Which Category field does the ML model use?

The Product and Campaign_Detail tables have a Category field. It seems that the Campaign_Detail one is used, at this SQL statement during the merge phase: (

r-server-campaign-optimization/SQLR/step1_data_processing.sql

Line 24 in 7c378f2

SELECT Campaign_Detail.*, Term, No_Of_People_Covered, Payment_Frequency, Net_Amt_Insured, Amt_On_Maturity_Bin,

)

Campaign_Detail.Category value is always 'Acquisition'... Is it adding a constant value to the machine learning model?

What do I get wrong here?

Thanks,
G.

This repo is missing important files

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Error while executing SQLR\Campaign_Optimization.ps1

I tried to execute the powershell script SQLR\Campaign_Optimization.ps1 on MSSQL 2017. In the step 3b, I'm getting this error

Invoke-Sqlcmd : A 'R' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004.
An external script error occurred:
During startup - Warning message:
In setJsonDatabasePath(system.file("extdata/capabilities.json", :
bytecode version mismatch; using eval
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
Could not open data source.
Error in doTryCatch(return(expr), name, parentenv, handler) :
Could not open data source.
Calls: source ... tryCatch -> tryCatchList -> tryCatchOne -> doTryCatch -> .Call
Error in execution. Check the output for more information.
Error in eval(expr, envir, enclos) :
Error in execution. Check the output for more information.
Calls: source -> withVisible -> eval -> eval -> .Call
Execution halted
STDOUT message(s) from external script:
[Microsoft][ODBC Driver Manager] Connection not open
ODBC Error in SQLDisconnect
At D:\mssql-r\r-server-campaign-optimization\SQLR\Campaign_Optimization.ps1:79 char:5

• Invoke-Sqlcmd -ServerInstance $ServerName  -Database $DBName -Use ...
  

• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlPowerShellSqlExecutionException
  • FullyQualifiedErrorId : SqlError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

The user I used for this execution is the DB owner and I granted script execution permissions as mentioned here
https://docs.microsoft.com/en-us/sql/advanced-analytics/security/user-permission?view=sql-server-ver15

Can you help me with a work around ?

Unable to Train Random Forest model

Hi all,

I'm having in invalid object CM_AD1 when training the RandomForest model.

cheers

This repo is missing a LICENSE file

This repository is currently missing a LICENSE file.

A license helps users understand how to use your project in a compliant manner. You can find the standard MIT license Microsoft uses at: https://github.com/microsoft/repo-templates/blob/main/shared/LICENSE.

If you would like to learn more about open source licenses, please visit the document at https://aka.ms/license (Microsoft-internal guidance).