Tune
Tune ETL for data replication
Features | Details |
Release Status | Released |
Source API Version | v2 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Tune networkId
Tune networkToken |
Replication Type | Key based Replication |
Replication Key | DATE |
Suggested Replication Frequency | 24 hrs |
Tables/APIs Supported | |
ManagerCommissionsReport | ConversionsReport |
ReferralsReport | StatsReport |
Affliate | Conversions |
Offers | SummaryLogsReport |
ManuallyUpdatedConversions
- 1.Signin to Daton
- 2.Select Tune 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 your Tune networkId and networkToken.
- 5.After providing the networkId and networkToken to authorize Daton to periodically extract data from Tune.
- 6.Post successful authentication you will be prompted to choose from the list of available tables
- 7.Then select all required fields for each table
- 8.Submit the integration.
- 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
ManagerCommissionsReport
Purpose: Get affiliate manager commission report.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
Stat | RECORD |
AffiliateManager | RECORD |
ConversionsReport
Purpose: Get a conversion report.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
Stat | RECORD |
RevenueGroup | RECORD |
Region | RECORD |
PayoutGroup | RECORD |
OfferUrl | RECORD |
Offer | RECORD |
Goal | RECORD |
Customer | RECORD |
Country | RECORD |
ConversionsMobile | RECORD |
ConversionMeta | RECORD |
Browser | RECORD |
AffiliateManager | RECORD |
Affiliate | RECORD |
AdvertiserManager | RECORD |
Advertiser | RECORD |
ReferralsReport
Purpose: Get traffic referrals report.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
Stat | RECORD |
Offer | RECORD |
AffiliateManager | RECORD |
AdvertiserManager | RECORD |
Advertiser | RECORD |
Affiliate | RECORD |
StatsReport
Purpose: Retrieve a stats report that contains aggregated stats for clicks, conversions, and other data points.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
Stat | RECORD |
Region | RECORD |
OfferVertical | RECORD |
OfferUrl | RECORD |
OfferTag | RECORD |
OfferOperatingSystem | RECORD |
OfferMediaPlacement | RECORD |
OfferIncentive | RECORD |
OfferFile | RECORD |
OfferConversionType | RECORD |
OfferChannel | RECORD |
Offer | RECORD |
Goal | RECORD |
Country | RECORD |
Category | RECORD |
Browser | RECORD |
AffiliateTag | RECORD |
AffiliateManager | RECORD |
Affiliate | RECORD |
AdvertiserTag | RECORD |
AdvertiserManager | RECORD |
Advertiser | RECORD |
AdCampaign | RECORD |
Affliate
Purpose: Returns one or more affiliates, optionally filtered and sorted by specified parameters.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
id | NUMERIC |
account_manager_id | NUMERIC |
company | STRING |
address1 | STRING |
address2 | STRING |
city | STRING |
region | STRING |
country | STRING |
other | STRING |
zipcode | NUMERIC |
phone | STRING |
fax | STRING |
website | STRING |
signup_ip | STRING |
date_added | TIMESTAMP |
status | STRING |
wants_alerts | NUMERIC |
payment_method | STRING |
method_data | STRING |
payment_terms | STRING |
w9_filed | NUMERIC |
referral_id | STRING |
affiliate_tier_id | STRING |
fraud_activity_score | STRING |
fraud_activity_alert_threshold | STRING |
fraud_activity_block_threshold | STRING |
fraud_profile_alert_threshold | STRING |
fraud_profile_block_threshold | STRING |
fraud_risk_tier | STRING |
scrub_offer_pixels | NUMERIC |
ref_id | STRING |
modified | TIMESTAMP |
Conversions
Purpose: List of Conversion model objects.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
Conversion | RECORD |
Offer | RECORD |
Country | RECORD |
ConversionMeta | STRING |
Browser | STRING |
AffiliateManager | RECORD |
Affiliate | RECORD |
AdvertiserManager | RECORD |
Advertiser | RECORD |
Offers
Purpose: Returns one or more offers, optionally filtered and sorted by specified parameters.
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | NUMERIC |
display_advertiser | NUMERIC |
advertiser_id | NUMERIC |
name | STRING |
description | STRING |
require_approval | NUMERIC |
require_terms_and_conditions | NUMERIC |
terms_and_conditions | STRING |
preview_url | STRING |
offer_url | STRING |
currency | STRING |
default_payout | NUMERIC |
max_payout | NUMERIC |
protocol | STRING |
status | STRING |
expiration_date | TIMESTAMP |
is_private | NUMERIC |
payout_type | STRING |
tiered_payout | NUMERIC |
tiered_revenue | NUMERIC |
percent_payout | STRING |
revenue_type | STRING |
max_percent_payout | STRING |
redirect_offer_id | NUMERIC |
converted_offer_type | STRING |
converted_offer_id | STRING |
converted_offer_url | STRING |
conversion_ratio_threshold | STRING |
featured | STRING |
is_subscription | NUMERIC |
subscription_duration | STRING |
subscription_frequency | STRING |
customer_list_id | NUMERIC |
ref_id | STRING |
rating | NUMERIC |
disable_click_macro | NUMERIC |
click_macro_url | STRING |
conversion_cap | NUMERIC |
monthly_conversion_cap | NUMERIC |
payout_cap | NUMERIC |
monthly_payout_cap | NUMERIC |
revenue_cap | NUMERIC |
monthly_revenue_cap | NUMERIC |
target_browsers | NUMERIC |
approve_conversions | NUMERIC |
allow_multiple_conversions | NUMERIC |
allow_website_links | NUMERIC |
allow_direct_links | NUMERIC |
show_custom_variables | NUMERIC |
session_hours | NUMERIC |
session_impression_hours | NUMERIC |
set_session_on_impression | NUMERIC |
is_seo_friendly_301 | NUMERIC |
show_mail_list | NUMERIC |
dne_list_id | NUMERIC |
email_instructions | NUMERIC |
email_instructions_from | STRING |
email_instructions_subject | STRING |
enforce_geo_targeting | NUMERIC |
enforce_secure_tracking_link | NUMERIC |
hostname_id | STRING |
has_goals_enabled | NUMERIC |
default_goal_name | STRING |
enforce_encrypt_tracking_pixels | NUMERIC |
modified | NUMERIC |
enable_offer_whitelist | NUMERIC |
note | STRING |
use_target_rules | NUMERIC |
use_payout_groups | NUMERIC |
use_revenue_groups | NUMERIC |
website_links_copy_static_params | NUMERIC |
create_date_utc | TIMESTAMP |
lifetime_revenue_cap | NUMERIC |
lifetime_conversion_cap | NUMERIC |
lifetime_payout_cap | NUMERIC |
proactive_click_fraud_prevention | STRING |
non_unique_click_attribution | STRING |
is_expired | NUMERIC |
dne_download_url | STRING |
dne_unsubscribe_url | STRING |
dne_third_party_list | BOOLEAN |
SummaryLogsReport
Purpose: Get mod summary logs report.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
Offer | RECORD |
ModSummaryLog | RECORD |
Affiliate | RECORD |
ManuallyUpdatedConversions
Purpose: Find Conversions which were manually updated within a specific date range.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
startDate | DATE |
endDate | DATE |
id | NUMERIC |
affiliate_id | NUMERIC |
offer_id | NUMERIC |
datetime | TIMESTAMP |
batch_date_utc | DATE |
batch_timestamp | TIMESTAMP |
payout | NUMERIC |
revenue | NUMERIC |
ad_id | STRING |
tune_event_id | STRING |
advertiser_manager_id | NUMERIC |
advertiser_id | NUMERIC |
affiliate_manager_id | NUMERIC |
goal_id | NUMERIC |
creative_url_id | NUMERIC |
customer_id | NUMERIC |
source | STRING |
affiliate_info1 | STRING |
affiliate_info2 | STRING |
affiliate_info3 | STRING |
affiliate_info4 | STRING |
affiliate_info5 | STRING |
advertiser_info | STRING |
session_datetime | TIMESTAMP |
refer | STRING |
pixel_refer | STRING |
ip | STRING |
session_ip | STRING |
status | STRING |
status_code | NUMERIC |
sale_amount | NUMERIC |
user_agent | STRING |
country_code | STRING |
event_city | STRING |
event_region | STRING |
browser_id | NUMERIC |
is_adjustment | NUMERIC |
ad_campaign_id | NUMERIC |
ad_campaign_creative_id | NUMERIC |
offer_file_id | NUMERIC |
payout_type | STRING |
revenue_type | STRING |
currency | STRING |
promo_code | STRING |
adv_unique1 | STRING |
adv_unique2 | STRING |
adv_unique3 | STRING |
adv_unique4 | STRING |
adv_unique5 | STRING |
order_id | STRING |
sku_id | STRING |
product_category | STRING |
app_version | STRING |
Last modified 2yr ago