Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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


===== Expected workflow =====

==== Connect all your marketing, sales and CRM data =====
Follow the instructions in [[adding_data_sources|Setting up your data sources]]

==== Apply data driven attribution on the conversion journeys to understand the contribution each touchpoint has on a channel, campaign, ad level =====
Follow the instructions in [[setting_up_multitouch_attribution|Setting up multitouch attribution]]

==== Join in the costs of all the connected channels to understand the cost per acquisition (CPA) or return on ad spend (ROAS) ====
Follow the instructions in [[adding_data_sources|Adding data sources]]

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



===== Frequently asked questions =====

=== How do I get my data into Snowflake ===

  - Create a [[https://onboard.windsor.ai|Windsor.ai]] account and connect all the sources which you would like to stream to Snowflake.
  - Use this tutorial to grant access to your Snowflake account.  
    - Create the WINDOSR_UPLOAD role (name has no importance) {{::snowflake-tutorial-step-1.png?direct|}}
    - Create a user and add the previously created role to that user {{:snowflake-tutorial-step-2.png?direct|}}
    - Grant rights to the DATABASE to the created user {{:snowflake-tutorial-step-3.png?direct|}}
    - Get the required fields from Snowflake to use the Snowflake destination in [[https://onboard.windsor.ai/|Onboard Form]] 
      - Get the username {{:snowflake-tutorial-step-5.1.png?direct|}}
      - Get the password {{:snowflake-tutorial-step-5.2.png?direct|}}
      - Get the account {{:snowflake-tutorial-step-5.3.png?direct|}}
      - Get the warehouse {{:snowflake-tutorial-step-5.4.png?direct|}}
      - Get the database {{:snowflake-tutorial-step-5.5.png?direct|}}
      - Get the schema {{:snowflake-tutorial-step-5.6.png?direct|}}
  - In **2. Select Destination** select Snowflake as destination \\ {{ :snowflake_integration_1.png?nolink&800 |}}
  - Enter all the credentials required and click **Save** \\ {{ :snowflake_integration_2.png?nolink&800 |}}
  - Your data will now be streamed to Snowflake. In case there is an error you will be notified.
 
===What fields and data types are available?=== 
Check our [[https://windsor.ai/connector/attribution-connector/|connector documentation]] for all the fields available
Knowledge Base

User Tools

Site Tools

Page Tools
