Getting your data into Snowflake

Windsor.ai and Snowflake allow you to

• Connect all your marketing, sales, and CRM data (e.g. Facebook Ads, Google Ads, Google Analytics, Salesforce)
• Apply data-driven attribution on the conversion journeys to understand the contribution each touchpoint has on a channel, campaign, ad level
• Join in the costs of all the connected channels to understand the cost per acquisition (CPA) or return on ad spend (ROAS)
• Make decisions

Follow the instructions in Setting up your data sources

Follow the instructions in Setting up multitouch attribution

Follow the instructions in Adding data sources

Follow the instructions below on getting your data into Snowflake and you are ready to make decisions based on multitouch attribution insights

1. Create a Windsor.ai account and connect all the sources which you would like to stream to Snowflake.
2. Use this tutorial to grant access to your Snowflake account.
   1. Create the WINDOSR_UPLOAD role (name has no importance)
   2. Create a user and add the previously created role to that user
   3. Grant rights to the DATABASE to the created user
   4. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
      1. Get the username
      2. Get the password
      3. Get the account
      4. Get the warehouse
      5. Get the database
      6. Get the schema
3. In 2. Select Destination select Snowflake as destination
   
4. Enter all the credentials required and click Save
   
5. Your data will now be streamed to Snowflake. In case there is an error you will be notified.

Check our connector documentation for all the fields available