Adjust

Adjust ETL connector for data replication

Features
Details
Release Status
In-dev
Source API Version
v1
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes (Tables, filters) / No (Columns, Fields)
Replication Type Selection
No
Authentication Parameters
API Key
Replication Type
Key Based Incremental
Replication Key
Date
Suggested Replication Frequency
2-4 hrs
Tables/APIs Supported:
--- | --- 
 There are three types of tables (queries) that you can integrate: 1. Overview 2. Events 3. Cohorts
These largely mirror different sections in the Adjust dashboard, and allow you to see the relevant KPIs directly.
Data will be fetched in combinations of selected Attribution source, Attribution type, Reattributed and Period filter (in case of cohort queries).
Integrate Adjust with Daton
------ | ------ 1. Sign in to Daton 2. Select Adjust from Integrations page 3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later 4. Provide API Key for authorizing Daton (https://help.adjust.com/en/article/kpi-service#authentication) and app token (https://help.adjust.com/en/article/app-settings#view-your-app-token) to extract data periodically 5. Post successful authentication, you will be prompted to choose from the list of available Adjust queries (tables) 6. Select from the list of kpis (columns) available for your app along with a combination of filters for each table and your UTC offset 7. Submit the integration 8. For integrating additional apps, one has to create a new integration from step-2.
Workflow
------ | ------ 1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse 2. Users would be able to edit/pause/re-activate/delete integration anytime 3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Adjust Data
------ | ------
Each combination of filters would be used to query the trackers' data for that particular app as a table in the selected warehouse.
The data will be stored incrementally in a batch of 10 days in the warehouse as following base fields in their respective tables- 1. Networks (top level) 2. Campaigns (sublevel 1) 3. Adgroups (sublevel 2) 4. Creatives (sublevel 3)
Tables
1._OverviewQueries
Documentation: https://help.adjust.com/en/article/kpi-service#overview-queries​
Fields:
Name
Target Datatype
Name
STRING
Currency
STRING
StartDate
DATE
EndDate
DATE
Attribution source
STRING
Attribution type
STRING
Reattributed
STRING
utc_offset
STRING
Networks
RECORD
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
Sub-fields:
1.Networks:
Name
Target Datatype
Name
STRING
AppKpis
RECORD
EventKpis
RECORD
AdKpis
RECORD
CostKpis
RECORD
FraudKpis
RECORD
Campaigns
RECORD
1.Campaigns:
Name
Target Datatype
Name
STRING
AppKpis
RECORD
EventKpis
RECORD
AdKpis
RECORD
CostKpis
RECORD
FraudKpis
RECORD
AdGroups
RECORD
1.AdGroups:
Name
Target Datatype
Name
STRING
AppKpis
RECORD
EventKpis
RECORD
AdKpis
RECORD
CostKpis
RECORD
FraudKpis
RECORD
Creatives
RECORD
1.Creatives
Name
Target Datatype
Name
STRING
AppKpis
RECORD
EventKpis
RECORD
AdKpis
RECORD
CostKpis
RECORD
FraudKpis
RECORD
1.AppKpis
Name
Target Datatype
sessions
FLOAT
clicks
FLOAT
installs
FLOAT
uninstalls
FLOAT
deattributions
FLOAT
impressions
FLOAT
uninstall_cohort
FLOAT
reinstalls
FLOAT
click_conversion_rate
FLOAT
impression_conversion_rate
FLOAT
ctr
FLOAT
reattribution_reinstalls
FLOAT
reattributions
FLOAT
revenue_events
FLOAT
revenue
FLOAT
all_revenue
FLOAT
cohort_revenue
FLOAT
daus
FLOAT
waus
FLOAT
maus
FLOAT
limit_ad_tracking_installs
FLOAT
limit_ad_tracking_install_rate
FLOAT
limit_ad_tracking_reattributions
FLOAT
limit_ad_tracking_reattribution_rate
FLOAT
gdpr_forgets
FLOAT
cohort_ad_revenue
FLOAT
cohort_all_revenue
FLOAT
2.EventKpis
Name
Target Datatype
revenue
RECORD
events
RECORD
revenue_per_event
RECORD
revenue_events
RECORD
first_events
RECORD
revenue_per_revenue_event
RECORD
Each RECORD of EventKpis:
Name
Target Datatype
EventName
STRING
Value
FLOAT
3.AdKpis
Name
Target Datatype
all_revenue
FLOAT
ad_revenue
FLOAT
ad_impressions
FLOAT
ad_rpm
FLOAT
4.CostKpis
Name
Target Datatype
install_cost
FLOAT
click_cost
FLOAT
impression_cost
FLOAT
cost
FLOAT
paid_installs
FLOAT
paid_clicks
FLOAT
paid_impressions
FLOAT
ecpc
FLOAT
ecpm
FLOAT
ecpi
FLOAT
cohort_gross_profit
FLOAT
return_on_investment
FLOAT
rcr
FLOAT
roas
FLOAT
5.FraudKpis
Name
Target Datatype
rejected_installs
FLOAT
rejected_installs_anon_ip
FLOAT
rejected_installs_too_many_engagements
FLOAT
rejected_installs_distribution_outlier
FLOAT
rejected_reattributions
FLOAT
rejected_reattributions_anon_ip
FLOAT
rejected_reattributions_too_many_engagements
FLOAT
rejected_reattributions_distribution_outlier
FLOAT
rejected_reattributions_click_injection
FLOAT
rejected_install_rate
FLOAT
rejected_install_anon_ip_rate
FLOAT
rejected_install_too_many_engagements_rate
FLOAT
rejected_install_distribution_outlier_rate
FLOAT
rejected_install_click_injection_rate
FLOAT
rejected_reattribution_rate
FLOAT
rejected_reattribution_anon_ip_rate
FLOAT
rejected_reattribution_too_many_engagements_rate
FLOAT
rejected_reattribution_distribution_outlier_rate
FLOAT
rejected_reattribution_click_injection_rate
FLOAT
2._EventQueries
Documentation: https://help.adjust.com/en/article/kpi-service#event-queries​
Fields:
Name
Target Datatype
Name
STRING
Currency
STRING
StartDate
DATE
EndDate
DATE
Attribution source
STRING
Attribution type
STRING
Reattributed
STRING
utc_offset
STRING
Networks
RECORD
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
Sub-fields:
1.Networks:
Name
Target Datatype
Name
STRING
Events
RECORD
Campaigns
RECORD
1.Campaigns
Name
Target Datatype
Name
STRING
Events
RECORD
AdGroups
RECORD
1.AdGroups
Name
Target Datatype
Name
STRING
Events
RECORD
Creatives
RECORD
1.Creatives
Name
Target Datatype
Name
STRING
Events
RECORD
Creatives
RECORD
2.Events
Name
Target Datatype
EventName
STRING
first_events
FLOAT
revenue_per_revenue_event
FLOAT
revenue_events
FLOAT
revenue
FLOAT
events
FLOAT
revenue_per_event
FLOAT
2._CohortQueries
Documentation: https://help.adjust.com/en/article/kpi-service#cohort-queries​
Fields:
Name
Target Datatype
Name
STRING
Currency
STRING
StartDate
DATE
EndDate
DATE
Attribution source
STRING
Attribution type
STRING
Reattributed
STRING
utc_offset
STRING
period
STRING
Networks
RECORD
_daton_user_id
NUMERIC
_daton_batch_runtime
NUMERIC
_daton_batch_id
NUMERIC
Sub-fields:
1.Networks:
Name
Target Datatype
Name
STRING
Periods
RECORD
Campaigns
RECORD
1.Campaigns
Name
Target Datatype
Name
STRING
Periods
RECORD
AdGroups
RECORD
1.AdGroups
Name
Target Datatype
Name
STRING
Periods
RECORD
Creatives
RECORD
1.Creatives
Name
Target Datatype
Name
STRING
Periods
RECORD
Creatives
RECORD
2.Periods
Name
Target Datatype
Period
STRING
time_spent_per_session
FLOAT
converted_user_size
FLOAT
conversion_per_user
FLOAT
conversion_distribution
FLOAT
converted_users
FLOAT
revenue_events_per_paying_user
FLOAT
events
FLOAT
conversion_per_active_user
FLOAT
revenue_events_per_active_user
FLOAT
revenue_events_per_user
FLOAT
first_uninstalls_total
FLOAT
first_reinstalls
FLOAT
first_uninstalls_total
FLOAT
reinstalls
FLOAT
reinstalls_total
FLOAT
gdpr_forgets
FLOAT
gdpr_forgets_total
FLOAT
first_uninstalls
FLOAT
uninstalls_total
FLOAT
uninstalls
FLOAT
reattributions_per_deattribution
FLOAT
deattributions_per_user
FLOAT
revenue_events
FLOAT
reattributions_per_user
FLOAT
deattributions
FLOAT
reattributions
FLOAT
events_per_active_user
FLOAT
events_per_user
FLOAT
events_per_converted_user
FLOAT
paying_users
FLOAT
paying_user_rate
FLOAT
paying_user_size
FLOAT
paying_users_retention_rate
FLOAT
cohort_size
FLOAT
retained_users
FLOAT
retention_rate
FLOAT
sessions
FLOAT
sessions_per_user
FLOAT
revenue
FLOAT
revenue_total
FLOAT
revenue_per_user
FLOAT
revenue_per_paying_user
FLOAT
revenue_total_in_cohort
FLOAT
revenue_events_total_in_cohort
FLOAT
lifetime_value
FLOAT
paying_user_lifetime_value
FLOAT
time_spent
FLOAT
time_spent_per_user
FLOAT

Advertising

Aircall

Last modified 1d ago

Features	Details
Release Status	In-dev
Source API Version	v1
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes (Tables, filters) / No (Columns, Fields)
Replication Type Selection	No
Authentication Parameters	API Key
Replication Type	Key Based Incremental
Replication Key	Date
Suggested Replication Frequency	2-4 hrs

Name	Target Datatype
Name	STRING
Currency	STRING
StartDate	DATE
EndDate	DATE
Attribution source	STRING
Attribution type	STRING
Reattributed	STRING
utc_offset	STRING
Networks	RECORD
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC

Name	Target Datatype
sessions	FLOAT
clicks	FLOAT
installs	FLOAT
uninstalls	FLOAT
deattributions	FLOAT
impressions	FLOAT
uninstall_cohort	FLOAT
reinstalls	FLOAT
click_conversion_rate	FLOAT
impression_conversion_rate	FLOAT
ctr	FLOAT
reattribution_reinstalls	FLOAT
reattributions	FLOAT
revenue_events	FLOAT
revenue	FLOAT
all_revenue	FLOAT
cohort_revenue	FLOAT
daus	FLOAT
waus	FLOAT
maus	FLOAT
limit_ad_tracking_installs	FLOAT
limit_ad_tracking_install_rate	FLOAT
limit_ad_tracking_reattributions	FLOAT
limit_ad_tracking_reattribution_rate	FLOAT
gdpr_forgets	FLOAT
cohort_ad_revenue	FLOAT
cohort_all_revenue	FLOAT

Name	Target Datatype
install_cost	FLOAT
click_cost	FLOAT
impression_cost	FLOAT
cost	FLOAT
paid_installs	FLOAT
paid_clicks	FLOAT
paid_impressions	FLOAT
ecpc	FLOAT
ecpm	FLOAT
ecpi	FLOAT
cohort_gross_profit	FLOAT
return_on_investment	FLOAT
rcr	FLOAT
roas	FLOAT

Name	Target Datatype
rejected_installs	FLOAT
rejected_installs_anon_ip	FLOAT
rejected_installs_too_many_engagements	FLOAT
rejected_installs_distribution_outlier	FLOAT
rejected_reattributions	FLOAT
rejected_reattributions_anon_ip	FLOAT
rejected_reattributions_too_many_engagements	FLOAT
rejected_reattributions_distribution_outlier	FLOAT
rejected_reattributions_click_injection	FLOAT
rejected_install_rate	FLOAT
rejected_install_anon_ip_rate	FLOAT
rejected_install_too_many_engagements_rate	FLOAT
rejected_install_distribution_outlier_rate	FLOAT
rejected_install_click_injection_rate	FLOAT
rejected_reattribution_rate	FLOAT
rejected_reattribution_anon_ip_rate	FLOAT
rejected_reattribution_too_many_engagements_rate	FLOAT
rejected_reattribution_distribution_outlier_rate	FLOAT
rejected_reattribution_click_injection_rate	FLOAT

Name	Target Datatype
EventName	STRING
first_events	FLOAT
revenue_per_revenue_event	FLOAT
revenue_events	FLOAT
revenue	FLOAT
events	FLOAT
revenue_per_event	FLOAT

Name	Target Datatype
Period	STRING
time_spent_per_session	FLOAT
converted_user_size	FLOAT
conversion_per_user	FLOAT
conversion_distribution	FLOAT
converted_users	FLOAT
revenue_events_per_paying_user	FLOAT
events	FLOAT
conversion_per_active_user	FLOAT
revenue_events_per_active_user	FLOAT
revenue_events_per_user	FLOAT
first_uninstalls_total	FLOAT
first_reinstalls	FLOAT
first_uninstalls_total	FLOAT
reinstalls	FLOAT
reinstalls_total	FLOAT
gdpr_forgets	FLOAT
gdpr_forgets_total	FLOAT
first_uninstalls	FLOAT
uninstalls_total	FLOAT
uninstalls	FLOAT
reattributions_per_deattribution	FLOAT
deattributions_per_user	FLOAT
revenue_events	FLOAT
reattributions_per_user	FLOAT
deattributions	FLOAT
reattributions	FLOAT
events_per_active_user	FLOAT
events_per_user	FLOAT
events_per_converted_user	FLOAT
paying_users	FLOAT
paying_user_rate	FLOAT
paying_user_size	FLOAT
paying_users_retention_rate	FLOAT
cohort_size	FLOAT
retained_users	FLOAT
retention_rate	FLOAT
sessions	FLOAT
sessions_per_user	FLOAT
revenue	FLOAT
revenue_total	FLOAT
revenue_per_user	FLOAT
revenue_per_paying_user	FLOAT
revenue_total_in_cohort	FLOAT
revenue_events_total_in_cohort	FLOAT
lifetime_value	FLOAT
paying_user_lifetime_value	FLOAT
time_spent	FLOAT
time_spent_per_user	FLOAT