Tune
Tune ETL for data replication

Snapshot

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

Integrate Tune with Daton

  1. 1.
    Signin to Daton
  2. 2.
    Select Tune from Integrations page
  3. 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. 4.
    Provide your Tune networkId and networkToken.
  5. 5.
    After providing the networkId and networkToken to authorize Daton to periodically extract data from Tune.
  6. 6.
    Post successful authentication you will be prompted to choose from the list of available tables
  7. 7.
    Then select all required fields for each table
  8. 8.
    Submit the integration.

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Tune Data

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 8mo ago