About AmpAI Assistants¶

AmpAI Assistants include the following:

Journeys AI Assistant helps users build and personalize multi-touch journeys
Queries AI Assistant helps users author SQL queries and resolve errors
Segments AI Assistant helps users build segments

These assistants are generative AI features within Amperity that use natural language as input commands.

Use the Journeys AI Assistant in the Journeys canvas to:

Create customer journeys starting from natural language, such as “Create a welcome series for new customers”
Add, edit, or remove journey steps, such as delays, emails, and splits
Personalize journeys based on customer segments, behaviors, or attributes

Use the Queries AI Assistant in the SQL Query Editor to:

Create SQL queries starting from natural language, such as “Who are my top 100 customers by lifetime spend?” or “Show me everyone who shopped in-store over the last 30 days.”
Ask for help while resolving a SQL error
Get advice on how to improve a query
Ask questions about SQL syntax, such as “What is the syntax for a window function?”

Use the Segments AI Assistant in the Segment Editor to:

Generate customer segments
Refine customer segments
Get advice on building better customer segments to meet campaign goals

Important

As with all generative AI capabilities, the outputs of AmpAI Assistants are probabilistic. Users should double check outputs for accuracy.

Review the Privacy FAQ for the AI Assistant to learn more about how the AmpAI Assistant interacts with LLMs and the Microsoft Azure OpenAI Service.

Amperity Learning Lab

The AmpAI Assistants are generative AI features that can help you build better SQL queries, generate customer segments, and structure journeys based on the data in your Amperity tenant.

Open Learning Lab to learn more about how the AmpAI Assistant can help you build better queries, segments, and journeys. Registration is required.

Enable or disable AmpAI Assistants¶

AmpAI features, including AmpAI Assistants, may be enabled (or disabled) by a user who is assigned the DataGrid Operator or DataGrid Administrator policy.

To disable AmpAI Assistants

From the Settings page, open the AmpAI tab.
Under Advanced settings, select the Disable AmpAI features option to disable AmpAI features, including the AmpAI Assistant.
Click Confirm.

How AmpAI Assistants work¶

AmpAI Assistants are powered by LLMs on a private instance of Azure OpenAI Service.

Amperity passes information on the schema information, query and segment examples, results, errors, table usage, and performs a series of research tool calls to improve the quality of results.

Note

More detail about how AmpAI Assistants work, including data sharing policies, how the model stores data, and what types of data is sent (or not sent), is available from the AI Assistant Privacy FAQ.

Journey Examples¶

The following examples show some of the ways you can use the Journeys AI Assistant while working in the Journeys canvas.

Build natural language journeys
Refine a journey
Personalize a journey

Note

The answers to these questions within your tenant will depend on the journey configuration, schema, results, and error information that was provided to the model and may be different than the examples shown.

Tip

Review the steps generated by the AmpAI Assistant to ensure they align with your campaign strategy before activating the journey.

Build natural language journeys¶

You can use natural language to ask the Journeys AI Assistant to build a journey based on the goals of your campaign.

Question: “Create a welcome series for new customers.”
Answer: The Journeys AI Assistant will respond similar to:

Refine a journey¶

You can ask the Journeys AI Assistant to add, edit, or remove steps within an existing journey flow.

Question: “Add a split based on email engagement to differentiate the path for highly engaged users.”
Answer: The Journeys AI Assistant will respond similar to:

Personalize a journey¶

You can ask the Journeys AI Assistant to update journey logic to better target specific audiences or behaviors.

Question: “Update the inclusion logic to target first time customers whose purchase was over $100.”
Answer: The Journeys AI Assistant will respond similar to:

Effective prompt patterns¶

To get the best results from the Journeys AI Assistant, use specific, clear commands that identify node types, criteria, and destinations.

Good prompts (specific and clear)¶

The following prompts provide the necessary context for the assistant to build accurate steps:

“Create a split for high value customers, send them to SFMC, everyone else to S3”
“Add a 7-day delay after the welcome email activation”
“Split by gender, then for each path split by loyalty tier (gold, silver, bronze)”
“Merge the two email paths and send a final survey email to everyone”
“Use Club Members as the inclusion segment”

Why these work:

Specific node types: Clearly identifies splits, delays, activations, or merges.
Clear criteria: Defines the logic (high value, gender, loyalty tier).
Explicit destinations: Names the downstream systems (SFMC, S3).
Explicit segments: Names the segment (Club Members)
Sequential structure: Outlines the order of operations.

Bad prompts (vague or ambiguous)¶

The following prompts may result in generic or incorrect journey steps because they lack detail:

“Build me a journey”
(What kind of journey? What segments? What destinations?)
“Make it better”
(Better how? What should change?)
“Add personalization”
(Personalize by what attribute? Where in the journey?)
“Do the usual thing”
(The AI doesn’t know your specific preferences or history)

Why these fail:

No specific actions: The assistant does not know which nodes to add.
Ambiguous goals: Terms like “better” or “personalization” are subjective without context.
Missing information: Lacks segments, destinations, or split criteria.

Query Examples¶

The following examples show some of the ways you can use the Queries AI Assistant while working in the SQL Query Editor.

Build natural language queries
Ask for help resolving errors
Ask questions about syntax

Note

The answers to these questions within your tenant will depend on the query, schema, results, and error information that was provided to the model and may be different than the examples shown.

Build natural language queries¶

You can use natural language–the same types of sentences you use when talking to co-workers and friends–to ask the AmpAI Assistant to help you build queries against any database in the Customer 360 page.

Customers by lifetime spend¶

Question: “Who are my top 100 customers by lifetime spend?”
Answer: The Queries AI Assistant will respond similar to:

Tip

When “Tables and fields are valid” is shown for the SQL returned by the AmpAI Assistant you can try running the query in the SQL Query Editor.

Click the Copy SQL link in the response from the AmpAI Assistant, paste the SQL into the SQL Query Editor, click the Run query button, and then (after the query is finished running) you can view the results.

In-store shoppers¶

Question: “Show me everyone who shopped in-store over the last 30 days.”
Answer: The Queries AI Assistant will respond similar to:

Ask for help resolving errors¶

When you have an error in your query syntax you can ask the AmpAI Assistant for help resolving the error.

Question: “Can you help me resolve this error?”
Answer: The Queries AI Assistant will respond similar to:

Ask questions about syntax¶

You can ask the AmpAI Assistant to help you understand how specific types of syntax work in a SQL query.

Question: “What is the syntax for a CASE statement?”
Answer: The Queries AI Assistant will respond similar to:

Note

Amperity uses Presto SQL syntax within the SQL Query Editor.

Segment Examples¶

The following examples show some of the ways you can use the Segments AI Assistant while working in the Segment Editor.

Create a segment
Refine a segment
Get advice on your segment

Note

The answers to these questions within your tenant will depend on the query, schema, results, and error information that was provided to the model and may be different than the examples shown.

Create a segment¶

You can ask the Segments AI Assistant to build a segment based on the criteria you lay out.

Question: “Build a segment of my highest value customers based on customer lifetime value.”
Answer: The Segments AI Assistant will respond similar to:

Tip

Be sure to check that the segment created matches what you were looking for, and if not you can guide the AmpAI Assistant on how to try again.

For example, if you ask for a segment of your highest value customers without specifying customer lifetime value as the criteria, you may get a segment based on highest spend over the past year.

In cases like this, prompt the AmpAI Assistant again and specify how you want to measure value.

Refine a segment¶

You can ask the Segments AI Assistant to add additional conditions to your segment.

Question: “Narrow it down to high value customers who have a product preference for jeans and have not purchased in the last month.”
Answer: The Segments AI Assistant will respond similar to:

Get advice on your segment¶

You can ask the Segments AI Assistant for guidance on how else you might design your segment to meet the goals of your campaign.

Question: “What other criteria should I consider adding to the segment in order to attract high-value customers who have not recently purchased to buy new offerings in the jeans category?”
Answer: The Segments AI Assistant will respond similar to:

"To make your segment even more effective for targeting high-value customers
who have not recently purchased (especially with the goal of promoting new
jeans offerings), you might consider adding additional criteria."

Answers will include suggestions similar to:

Predicted Affinity for Related Categories:

Include customers who also have a demonstrated or predicted interest in complementary categories, such as “Tops and T-shirts” or “Accessories,” which pair well with jeans.
Preferred Channel or Brand:

Focus on customers who prefer a specific purchase channel or brand, if your new jeans offerings are exclusive or more prominent in certain channels or under specific brands.
Contactability:

Ensure that customers are opted into email or SMS marketing, so your campaigns can actually reach them.
Geographic Proximity:

Filter for customers living in regions where jeans sales or promotions are planned or more likely and in areas with upcoming in-store events.
Previous Buyers of Premium Jeans:

Target customers who have purchased higher-value or premium jeans in the past, as they are more likely to be interested in new, similar offerings.
Lapsed but Historically Loyal Customers:

Identify customers who have bought jeans in the past but have not purchased any recently—they may respond well to a “welcome back” campaign for new jeans.
Customer Lifecycle Status:

Pay attention to customers with a “likely to return” or “at-risk” predicted lifecycle, as they could be nudged toward purchase with targeted messaging.