New website customers¶
Which customers made their first order from your website within the last 30 days?
You can find customers who made their first purchase from your website within the last 30 days first by identifying customers who have made their first purchase within the last 30 days, and then by identifying customers whose purchase channel is your website.
The following sections describe using the the visual Query Editor to build a query that returns a list of customers who placed their first website order within the previous 30 days.
Open the visual Query Editor, look in the lower-right of the page and make sure your customer 360 database is selected. |
|
To identify which customers have made their first purchase within the previous 30 days, choose the Amperity ID and First Order Datetime attributes from the Transaction Attributes Extended table. Set the condition for Amperity ID to “is not NULL” and the condition for First Order Datetime to “is after”, and then configure a relative date range of “now - 30 days”: |
|
Add a second attribute to your query. To identify customers who have purchased from your website, choose the First Order Purchase Channel attribute from the Transaction Attributes Extended table, select the “is” operator, and then select “web”: Keep the and/or slider set to AND. |
|
Run the query to validate the syntax, and then review the results. |
|
You’re done! Give your query a name that clearly describes the purpose. For example: “New Customers L30D Website”. Click the Activate button in the top right corner of the visual Query Editor. Tip Use good naming patterns to ensure that you can always find your queries when you need them. Be sure to include the brand name and/or the region name if you have multiple brands or have multiple regions and want to build queries that are brand- and/or region-specific. |