Raw Conversions

Number of Days

Required

Enter the number of days for which you wish you get the data in each run.

'NUMBER'

Insert Mode

Required

This refers to the manner in which data will get updated in the data warehouse, with 'Upsert' selected, the data will be upserted (only new records or records with changes) and with 'Append' selected, all data fetched will be inserted. Selecting 'Replace' will ensure the table is dropped and recreated with fresh data on each run. Recommended to use "Upsert" option unless there is a specific requirement.

Upsert, Append, Replace

Default Value: Upsert

Upsert Key

Dependent Required

Specify comma separated Upsert Keys based on which data is to be upserted.

'Upsert Key'

Columns

Required

Select the columns that are to be included in the report. Multiple columns can be selected. At least one coumn must be selected. Use 'Select all' to include all columns.

offer, affiliate, advertiser, offer_group, campaign, affiliate_manager, creative, offer_url, category, previous_offer, source_id, sub1, sub2, sub3, sub4, sub5, adv1, adv2, adv3, adv4, adv5, country, region, city, platform, os_version, isp, account_manager, android_id, android_id_md5, android_id_sha1, app_id, brand, browser, carrier, click_date, conversion_id, conversion_user_ip, coupon_code, currency, delta_hours, device, email, error_message, event_name, google_ad_id, google_ad_id_md5, google_ad_id_sha1, http_user_agent, idfa, idfa_md5, idfa_sha1, language, notes, order_id, order_line_items, order_number, payout, payout_type, referrer, revenue, revenue_type, sale_amount, session_ip, transaction_id, type, status, conversion_date, origin

Show Conversions

Required

Specify whether or not base conversions are returned.

{True, False}

Default Value: False

Show Events

Required

Specify whether or not post-conversion events are returned.

{True, False}

Default Value: False

Isolate conversions that were throttled

Required

Specify whether or not to isolate conversions that were throttled.

{True, False}

Default Value: False

Isolate view-through conversions

Required

Specify whether or not to isolate view-through conversions.

{True, False}

Default Value: False

Isolate click-through events

Required

Specify whether or not to isolate click-through events.

{True, False}

Default Value: False

Isolate conversion and events that come from fail traffic

Required

Specify whether or not to isolate conversion and events that come from fail traffic.

{True, False}

Default Value: False