This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
snowflake [2021/05/29 02:18] windsor_ai |
snowflake [2022/01/26 01:27] windsor_ai |
||
---|---|---|---|
Line 3: | Line 3: | ||
Windsor.ai and Snowflake allow you to | Windsor.ai and Snowflake allow you to | ||
- | - Connect all your marketing, sales and CRM data (e.g. Facebook Ads, Google Ads, Google Analytics, Salesforce) | + | * 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 ===== | ==== Connect all your marketing, sales and CRM data ===== | ||
Line 23: | Line 25: | ||
- | ==== Frequently asked questions ==== | + | ===== Frequently asked questions |
- | * How do I get my data into Snowflake? | + | === How do I get my data into Snowflake |
- Create a [[https:// | - Create a [[https:// | ||
+ | - Use this tutorial to grant access to your Snowflake account. | ||
+ | - Add all the columns that are returned by your connector' | ||
+ | - Create the WINDOSR_UPLOAD role (name has no importance) {{:: | ||
+ | - Create a user and add the previously created role to that user {{: | ||
+ | - Grant rights to the DATABASE to the created user {{: | ||
+ | - Grand the rights to the destination table {{: | ||
+ | - Get the rerquired fields from Snowflake to use the Snowflake destination in [[https:// | ||
+ | - Get the username {{: | ||
+ | - Get the password {{: | ||
+ | - Get the account {{: | ||
+ | - Get the warehouse {{: | ||
+ | - Get the database {{: | ||
+ | - Get the schema {{: | ||
+ | - Get the table name {{: | ||
- In **2. Select Destination** select Snowflake as destination \\ {{ : | - In **2. Select Destination** select Snowflake as destination \\ {{ : | ||
- Enter all the credentials required and click **Save** \\ {{ : | - Enter all the credentials required and click **Save** \\ {{ : | ||
- Your data will now be streamed to Snowflake. In case there is an error you will be notified. | - 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:// | ||
+ | |||