Category Archives: Alteryx

Customer Cohorts and Product Sequence with orders data

Posted on 2020-08-25 by Frederic

Whether you work in B2B or B2C, getting a better understanding of customer or account transactions in sequence is core. Customer cohorts will show you how well you are doing acquiring new customers, but also do they conduct repeat business … Continue reading →

Posted in Alteryx, Marketing, Redshift, Sales, Snowflake, SQL, Tableau | Tagged , , , | Comments Off on Customer Cohorts and Product Sequence with orders data

How to Import SFDC Recursive Hierarchies to Tableau

Posted on 2020-05-07 by Frederic

If you have dealt with hierarchies from Salesforce (SFDC), or from most normalized transactional systems, you have faced some challenges to use those hierarchies in Tableau. Those systems treat hierarchies as a recursive model, storing Parent to Child relationships in … Continue reading →

Posted in Alteryx, Automation, Marketing, Sales, SFDC, SQL, Tableau, Uncategorized | Tagged , | 6 Comments

Snowflake Summit 2019 Debrief

Posted on 2019-06-11 by Frederic

I was very excited at the thought of attending the first edition of the Snowflake customer event In San Francisco last week, and the event did deliver…

Posted in Alteryx, Automation, Performance, Snowflake, SQL, Tableau, Uncategorized | Comments Off on Snowflake Summit 2019 Debrief

Classify records based on keywords in a text field

Posted on 2019-04-25 by Frederic

Have you ever been tasked to assign customers to a category based on a free form text field? This happens a lot in B2B marketing, using the Title that a prospect has input into a form. It can certainly be … Continue reading →

Posted in Alteryx, Marketing, Quick & Dirty | Tagged | Comments Off on Classify records based on keywords in a text field

How to edit Salesforce credentials within several Alteryx workflows at once

Posted on 2019-04-22 by Frederic

In Alteryx, the Salesforce connector is very useful to easily import raw data from Salesforce using its wonderful API. All you need to input is the email and password for a API enabled user login, as well as the Security … Continue reading →

Posted in Alteryx, Productivity, SFDC | 6 Comments