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