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
Signin to Daton
Select Tune from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your Tune networkId and networkToken.
After providing the networkId and networkToken to authorize Daton to periodically extract data from Tune.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration.
Workflow
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
Users would be able to edit/pause/re-activate/delete integration anytime
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 |
Last updated