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.

Open the visual Query Editor, look in the lower-right of the page and make sure your customer 360 database is selected.

Use your customer 360 database to build queries.
Find customers whose first purchase was within the last 30 days.

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

Find customers whose first purchase was within the last 30 days.
Find customers who have purchased from your website.

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

Find customers who have purchased from your website.

Keep the and/or slider set to AND.

Run the query.

Run the query to validate the syntax, and then review the results.

Save your segment.

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.