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. 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.

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

Tune Data

ManagerCommissionsReport

Purpose: Get affiliate manager commission report.

Source API Documentation https://developers.tune.com/network/report-getmanagercommissions/

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
Stat	RECORD
AffiliateManager	RECORD

ConversionsReport

Purpose: Get a conversion report.

Source API Documentation https://developers.tune.com/network/report-getconversions/

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.

Source API Documentation https://developers.tune.com/network/report-getreferrals/

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.

Source API Documentation https://developers.tune.com/network/report-getstats/

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.

Source API Documentation https://developers.tune.com/network/affiliate-findall/

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.

Source API Documentation https://developers.tune.com/network/conversion-findall/

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.

Source API Documentation https://developers.tune.com/network/offer-findall/

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.

Source API Documentation https://developers.tune.com/network/report-getmodsummarylogs/

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.

Source API Documentation https://developers.tune.com/network/conversion-findupdatedconversions/

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