Schema Information

This subtopic provides a structured reference to assist you in working with Daton's Adjust v2 connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the Adjust v2 connector:

• Cohort Queries

• Event Queries

• Overview Queries

Cohort Queries

The Cohort Queries API allows users to retrieve data related to user cohorts, helping analyze and track the behavior of groups of users over time.

For more information, see Adjust- Cohort Queries.

This table does not include primary keys, emphasizing its analytical focus on Key Performance Indicators (KPIs).

This table does not include a primary key, emphasizing its analytical focus on Key Performance Indicators (KPIs).

FIELDS

Field Name	Data Type
date	DATE
period	NUMERIC
retained_users	NUMERIC
cohort_size	NUMERIC
retention_rate	NUMERIC
reattributions	NUMERIC
deattributions	NUMERIC
sessions	NUMERIC
sessions_per_user	NUMERIC
revenue	NUMERIC
revenue_total	NUMERIC
revenue_per_user	NUMERIC
revenue_per_paying_user	NUMERIC
revenue_total_in_cohort	NUMERIC
lifetime_value	NUMERIC
paying_user_lifetime_value	NUMERIC
time_spent	NUMERIC
time_spent_per_user	NUMERIC
time_spent_per_session	NUMERIC
paying_users	NUMERIC
paying_user_size	NUMERIC
paying_users_retention_rate	NUMERIC
paying_user_rate	NUMERIC
revenue_events	NUMERIC
revenue_events_total	NUMERIC
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
period_in	INTEGER
retained_users_in	INTEGER
cohort_size_in	INTEGER
retention_rate_in	INTEGER
sessions_in	INTEGER
sessions_per_user_in	INTEGER
time_spent_in	INTEGER
time_spent_per_user_in	INTEGER
time_spent_per_session_in	INTEGER
paying_user_size_in	INTEGER
paying_users_in	INTEGER
revenue_events_in	INTEGER
revenue_events_total_in	INTEGER
revenue_in	INTEGER
revenue_total_in	INTEGER
revenue_total_in_cohort_in	INTEGER
reattributions_in	INTEGER
deattributions_in	INTEGER
paying_user_lifetime_value_in	INTEGER
lifetime_value_in	INTEGER
revenue_per_paying_user_in	INTEGER
paying_users_retention_rate_in	INTEGER

Event Queries

Event Queries API enables users to access detailed information about specific events or actions taken by users within an app or platform, providing insights into user engagement and behavior.

For more information, see Adjust- Event Queries.

This table does not include primary keys, emphasizing its analytical focus on Key Performance Indicators (KPIs).

This table does not include a primary key, emphasizing its analytical focus on Key Performance Indicators (KPIs).

FIELDS

Field Name	Data Type
date	DATE
revenue_events	NUMERIC
revenue	NUMERIC
events	NUMERIC
first_events	NUMERIC
revenue_per_event	NUMERIC
revenue_per_revenue_event	NUMERIC
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
events_in	INTEGER
first_events_in	INTEGER
revenue_events_in	INTEGER
revenue_in	INTEGER
revenue_per_revenue_event_in	INTEGER

Overview Queries

Overview Queries API provides a high-level summary of key metrics and performance indicators, offering a quick snapshot of an app or campaign's overall effectiveness.

For more information, see Adjust- Overview Queries.

This table does not include primary keys, emphasizing its analytical focus on Key Performance Indicators (KPIs).

This table does not include a primary key, emphasizing its analytical focus on Key Performance Indicators (KPIs).

FIELDS

Field Name	Data Type
date	DATE
clicks	NUMERIC
impressions	NUMERIC
ctr	NUMERIC
clicks__1	NUMERIC
installs	NUMERIC
uninstalls	NUMERIC
reinstalls	NUMERIC
reattribution_reinstalls	NUMERIC
uninstall_cohort	NUMERIC
limit_ad_tracking_installs	NUMERIC
limit_ad_tracking_install_rate	NUMERIC
limit_ad_tracking_reattributions	NUMERIC
limit_ad_tracking_reattribution_rate	NUMERIC
click_conversion_rate	NUMERIC
impression_conversion_rate	NUMERIC
reattributions	NUMERIC
deattributions	NUMERIC
base_sessions	NUMERIC
sessions	NUMERIC
revenue_events	NUMERIC
revenue	NUMERIC
cohort_revenue	NUMERIC
gdpr_forgets	STRING
rejected_installs	NUMERIC
rejected_installs_anon_ip	NUMERIC
rejected_installs_too_many_engagements	STRING
rejected_installs_distribution_outlier	STRING
rejected_reattribution_rate	STRING
install_cost	STRING
click_cost	STRING
impression_cost	STRING
event_cost	STRING
cost	STRING
ecost	STRING
paid_installs	STRING
return_on_investment	STRING
ad_revenue	STRING
ad_impressions	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC
installs_in	INTEGER
reinstalls_in	INTEGER
base_sessions_in	INTEGER
sessions_in	INTEGER
uninstalls_in	INTEGER
uninstall_cohort_in	INTEGER
revenue_events_in	INTEGER
revenue_in	INTEGER
limit_ad_tracking_installs_in	INTEGER
clicks_in	INTEGER
click_conversion_rate_in	INTEGER
rejected_installs_in	INTEGER
rejected_installs_anon_ip_in	INTEGER
limit_ad_tracking_reattributions_in	INTEGER
limit_ad_tracking_reattribution_rate_in	INTEGER
reattributions_in	INTEGER
deattributions_in	INTEGER
impressions_in	INTEGER
impression_conversion_rate_in	INTEGER
reattribution_reinstalls_in	INTEGER
ctr_in	INTEGER
cohort_revenue_in	INTEGER