Lytics Query Language

Developer training on basic LQL syntax and how Lytics transforms incoming data into actionable user profiles.

Intro to LQL

Learn LQL basics

Note: On January 10, 2023, we upgraded our UI with a new, refreshed interface. All of the underlying functionality is the same, but you will notice that things look a little different from this Academy guide. The most notable change is that the navigation menu has moved from the top of the app to the left side. We appreciate your patience as we work on updating our Academy.

What will I learn?

• What is LQL? 
• Where can I view LQL files in the Lytics UI?
• What is the basic syntax?
• What are the different ways to transform incoming data fields?

Watch the "Lytics Query Language - Learn LQL Basics" training video below (15 mins) for an overview of Lytics Query Language (LQL). We'll cover the basics of how LQL transforms data, the difference between default and custom LQL, and how key identifiers merge user profiles.

Keep in Mind - The end result of LQL is the ability to build educated user profiles and audiences in Lytics.

Knowledge Check

Before you dive into writing your own LQL files, check your understanding of the key concepts covered.

Copies of raw events are stored prior to LQL processing.

A. True

B. False

Answer: A

Which name on the LQL file is displayed and searchable in the Lytics Audience Builder?

A. SELECT Field

B. Short Description

C. BY Field

D. Long Description

Answer: B

Each LQL file must have a unique name set as the alias.

A. True

B. False

Answer: A

How are data types (i.e. string, integer, map, etc.) referenced in LQL files?

A. SORT

B. TYPE

C. KIND

Answer: C

KINDs will impact the data visualizations in the Audience Builder.

A. True

B. False

Answer: A

How many out-of-the-box LQL files are there?

A. 4

B. 3

C. 8

D. 0

More Resources

Documentation

• Lytics Query Language - more detailed explanation and syntax examples
• LQL & Data Import Basics - introductory API documentation