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
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
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
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
Last modified 1yr ago