# Klaviyo: Persons

## Description

* Table of unique person profiles, enhanced with event, campaign, flow, and revenue metrics. **Counts** of instances of triggered events and **sums** of the numeric value (i.e. revenue) associated with events (total vs organic/not attributed to flows or campaigns) will be pivoted out into columns, as configured by the `klaviyo__count_metrics` and `klaviyo__sum_revenue_metrics`variables, respectively. See the dbt\_project.yml file for the default metrics used. These columns will be prefixed with `total_count_`, `total_sum_revenue_` (organic + attributed), and `organic_sum_revenue_` (not attributed to a campaign or flow).

## Supported Data Sources

* <img src="https://fivetran.com/integrations/klaviyo/resources/klaviyo.svg" alt="" data-size="line"> Klaviyo

## Columns

| Type     | Name                                     | Description                                                                                                                                                                                                                                                                                                     |
| -------- | ---------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING   | person\_id                               | Unique ID of the user if you use your own unique identifier. Otherwise, Klaviyo recommends using the email as the primary key.                                                                                                                                                                                  |
| STRING   | address\_1                               | First line of the person's address.                                                                                                                                                                                                                                                                             |
| STRING   | address\_2                               | Second line of the person's address.                                                                                                                                                                                                                                                                            |
| STRING   | city                                     | City they live in.                                                                                                                                                                                                                                                                                              |
| STRING   | country                                  | Country they live in.                                                                                                                                                                                                                                                                                           |
| STRING   | zip                                      | Postal code where they live.                                                                                                                                                                                                                                                                                    |
| DATETIME | created\_at                              | Timestamp of when the person's profile was created.                                                                                                                                                                                                                                                             |
| STRING   | email                                    | The email address for a profile.                                                                                                                                                                                                                                                                                |
| STRING   | full\_name                               | Person's full name.                                                                                                                                                                                                                                                                                             |
| STRING   | latitude                                 | Latitude of the person's location.                                                                                                                                                                                                                                                                              |
| STRING   | longitude                                | Longitude of the person's location.                                                                                                                                                                                                                                                                             |
| STRING   | organization                             | Business organization they belong to.                                                                                                                                                                                                                                                                           |
| STRING   | phone\_number                            | Associated phone number.                                                                                                                                                                                                                                                                                        |
| STRING   | region                                   | Region or state they live in.                                                                                                                                                                                                                                                                                   |
| STRING   | timezone                                 | Timezone they are situated in.                                                                                                                                                                                                                                                                                  |
| STRING   | title                                    | Title at their business or organization.                                                                                                                                                                                                                                                                        |
| DATETIME | updated\_at                              | Timestamp of when the person profile was last updated.                                                                                                                                                                                                                                                          |
| DATETIME | last\_event\_date                        |                                                                                                                                                                                                                                                                                                                 |
| STRING   | source\_relation                         | The source where this data was pulled from. If you are making use of the `union_schemas` variable, this will be the source schema. If you are making use of the `union_databases` variable, this will be the source database. If you are not unioining together multiple sources, this will be an empty string. |
| INTEGER  | count\_total\_campaigns                  | Count of the number of campaigns this person has interacted with.                                                                                                                                                                                                                                               |
| INTEGER  | count\_total\_flows                      | Count of the number of flows this person has interacted with.                                                                                                                                                                                                                                                   |
| DATETIME | first\_event\_at                         | Timestamp of when the user first triggered an event (not limited to campaign and flow interactions).                                                                                                                                                                                                            |
| DATETIME | last\_event\_at                          | Timestamp of when the user last triggered an event (not limited to campaign and flow interactions).                                                                                                                                                                                                             |
| DATETIME | first\_campaign\_touch\_at               | Timestamp of when the user first interacted with a campaign.                                                                                                                                                                                                                                                    |
| DATETIME | last\_campaign\_touch\_at                | Timestamp of when the user last interacted with a campaign.                                                                                                                                                                                                                                                     |
| DATETIME | first\_flow\_touch\_at                   | Timestamp of when the user first interacted with a flow.                                                                                                                                                                                                                                                        |
| DATETIME | last\_flow\_touch\_at                    | Timestamp of when the user last interacted with a flow.                                                                                                                                                                                                                                                         |
| INTEGER  | total\_sum\_revenue\_refunded\_order     |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | organic\_sum\_revenue\_refunded\_order   |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_sum\_revenue\_placed\_order       |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | organic\_sum\_revenue\_placed\_order     |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_sum\_revenue\_ordered\_product    |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | organic\_sum\_revenue\_ordered\_product  |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_sum\_revenue\_checkout\_started   |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | organic\_sum\_revenue\_checkout\_started |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_sum\_revenue\_cancelled\_order    |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | organic\_sum\_revenue\_cancelled\_order  |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_active\_on\_site           |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_viewed\_product            |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_ordered\_product           |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_placed\_order              |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_refunded\_order            |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_received\_email            |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_clicked\_email             |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_opened\_email              |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_marked\_email\_as\_spam    |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_unsubscribed               |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_received\_sms              |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_clicked\_sms               |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_sent\_sms                  |                                                                                                                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_unsubscribed\_from\_sms    |                                                                                                                                                                                                                                                                                                                 |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/klaviyo-persons.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.