User Tools

Site Tools


snowflake

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 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

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

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?
  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. Add all the columns that are returned by your connector's URL.
    2. Create the WINDOSR_UPLOAD role (name has no importance)
    3. Create a user and add the previously created role to that user
    4. Grant rights to the DATABASE to the created user
    5. Grand the rights to the destination table
    6. Get the rerquired 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
      7. Get the table name
  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.
snowflake.txt · Last modified: 2021/06/17 09:33 by windsor_ai