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 |
--- | ---
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).
------ | ------ 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.
------ | ------ 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
------ | ------
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)
- 1._OverviewQueries
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:NameTarget DatatypeNameSTRINGAppKpisRECORDEventKpisRECORDAdKpisRECORDCostKpisRECORDFraudKpisRECORDCampaignsRECORD
- 1.Campaigns:NameTarget DatatypeNameSTRINGAppKpisRECORDEventKpisRECORDAdKpisRECORDCostKpisRECORDFraudKpisRECORDAdGroupsRECORD
- 1.AdGroups:NameTarget DatatypeNameSTRINGAppKpisRECORDEventKpisRECORDAdKpisRECORDCostKpisRECORDFraudKpisRECORDCreativesRECORD
- 1.CreativesNameTarget DatatypeNameSTRINGAppKpisRECORDEventKpisRECORDAdKpisRECORDCostKpisRECORDFraudKpisRECORD
- 1.AppKpis
NameTarget DatatypesessionsFLOATclicksFLOATinstallsFLOATuninstallsFLOATdeattributionsFLOATimpressionsFLOATuninstall_cohortFLOATreinstallsFLOATclick_conversion_rateFLOATimpression_conversion_rateFLOATctrFLOATreattribution_reinstallsFLOATreattributionsFLOATrevenue_eventsFLOATrevenueFLOATall_revenueFLOATcohort_revenueFLOATdausFLOATwausFLOATmausFLOATlimit_ad_tracking_installsFLOATlimit_ad_tracking_install_rateFLOATlimit_ad_tracking_reattributionsFLOATlimit_ad_tracking_reattribution_rateFLOATgdpr_forgetsFLOATcohort_ad_revenueFLOATcohort_all_revenueFLOAT - 2.EventKpisNameTarget DatatyperevenueRECORDeventsRECORDrevenue_per_eventRECORDrevenue_eventsRECORDfirst_eventsRECORDrevenue_per_revenue_eventRECORDEach RECORD of EventKpis:NameTarget DatatypeEventNameSTRINGValueFLOAT
- 3.AdKpisNameTarget Datatypeall_revenueFLOATad_revenueFLOATad_impressionsFLOATad_rpmFLOAT
- 4.CostKpisNameTarget Datatypeinstall_costFLOATclick_costFLOATimpression_costFLOATcostFLOATpaid_installsFLOATpaid_clicksFLOATpaid_impressionsFLOATecpcFLOATecpmFLOATecpiFLOATcohort_gross_profitFLOATreturn_on_investmentFLOATrcrFLOATroasFLOAT
- 5.FraudKpisNameTarget Datatyperejected_installsFLOATrejected_installs_anon_ipFLOATrejected_installs_too_many_engagementsFLOATrejected_installs_distribution_outlierFLOATrejected_reattributionsFLOATrejected_reattributions_anon_ipFLOATrejected_reattributions_too_many_engagementsFLOATrejected_reattributions_distribution_outlierFLOATrejected_reattributions_click_injectionFLOATrejected_install_rateFLOATrejected_install_anon_ip_rateFLOATrejected_install_too_many_engagements_rateFLOATrejected_install_distribution_outlier_rateFLOATrejected_install_click_injection_rateFLOATrejected_reattribution_rateFLOATrejected_reattribution_anon_ip_rateFLOATrejected_reattribution_too_many_engagements_rateFLOATrejected_reattribution_distribution_outlier_rateFLOATrejected_reattribution_click_injection_rateFLOAT
- 2._EventQueries
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:NameTarget DatatypeNameSTRINGEventsRECORDCampaignsRECORD
- 1.CampaignsNameTarget DatatypeNameSTRINGEventsRECORDAdGroupsRECORD
- 1.AdGroupsNameTarget DatatypeNameSTRINGEventsRECORDCreativesRECORD
- 1.CreativesNameTarget DatatypeNameSTRINGEventsRECORDCreativesRECORD
- 2.EventsNameTarget DatatypeEventNameSTRINGfirst_eventsFLOATrevenue_per_revenue_eventFLOATrevenue_eventsFLOATrevenueFLOATeventsFLOATrevenue_per_eventFLOAT
- 2._CohortQueries
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:NameTarget DatatypeNameSTRINGPeriodsRECORDCampaignsRECORD
- 1.CampaignsNameTarget DatatypeNameSTRINGPeriodsRECORDAdGroupsRECORD
- 1.AdGroupsNameTarget DatatypeNameSTRINGPeriodsRECORDCreativesRECORD
- 1.CreativesNameTarget DatatypeNameSTRINGPeriodsRECORDCreativesRECORD
- 2.PeriodsNameTarget DatatypePeriodSTRINGtime_spent_per_sessionFLOATconverted_user_sizeFLOATconversion_per_userFLOATconversion_distributionFLOATconverted_usersFLOATrevenue_events_per_paying_userFLOATeventsFLOATconversion_per_active_userFLOATrevenue_events_per_active_userFLOATrevenue_events_per_userFLOATfirst_uninstalls_totalFLOATfirst_reinstallsFLOATfirst_uninstalls_totalFLOATreinstallsFLOATreinstalls_totalFLOATgdpr_forgetsFLOATgdpr_forgets_totalFLOATfirst_uninstallsFLOATuninstalls_totalFLOATuninstallsFLOATreattributions_per_deattributionFLOATdeattributions_per_userFLOATrevenue_eventsFLOATreattributions_per_userFLOATdeattributionsFLOATreattributionsFLOATevents_per_active_userFLOATevents_per_userFLOATevents_per_converted_userFLOATpaying_usersFLOATpaying_user_rateFLOATpaying_user_sizeFLOATpaying_users_retention_rateFLOATcohort_sizeFLOATretained_usersFLOATretention_rateFLOATsessionsFLOATsessions_per_userFLOATrevenueFLOATrevenue_totalFLOATrevenue_per_userFLOATrevenue_per_paying_userFLOATrevenue_total_in_cohortFLOATrevenue_events_total_in_cohortFLOATlifetime_valueFLOATpaying_user_lifetime_valueFLOATtime_spentFLOATtime_spent_per_userFLOAT
Last modified 1d ago