Differences

This shows you the differences between two versions of the page.

--- snowflake [2021/05/28 04:03]
windsor_ai created
+++ snowflake [2022/01/26 01:27]
windsor_ai
@@ Line 1: / Line 1: @@
 ====== Getting your data into Snowflake ======
-==== Frequently asked questions ====
+Windsor.ai and Snowflake allow you to
-  * How do I get my data into Snowflake?
+  * 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.
+    - Add all the columns that are returned by your connector's URL. {{:snowflake-tutorial-step-1.png?direct|}}
+    - 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|}}
+    - Grand the rights to the destination table {{:snowflake-tutorial-step-4.png?direct|}}
+    - Get the rerquired 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|}}
+      - Get the table name {{:snowflake-tutorial-step-5.7.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

Differences

Page Tools