Reporting Data

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'

Pivot

Required

Pivot your data based on one or multiple columns allowing you to group the reporting metrics. At least one column must be selected. Multiple columns can be selected (can take up to a maximum of 10 columns in a single request).

offer, affiliate, advertiser, offer_group, campaign, creative, event_name, offer_url, country, country_code, region, city, dma,carrier,platform, os_version, isp, browser, device_type, device_make, model, language,connection_type,sub1, sub2, sub3, sub4, sub5, source_id, adv1,adv2, adv3, adv4, adv5, coupon_code, tracking_domain,referrer,offer_status,affiliate_manager, account_manager,category, project_id, payout_type, payout_amount, revenue_type, revenue_amount,currency, sales_manager,account_executive, affiliate_status, advertiser_event_name, app_identifier, bundle_id, hour

Ignore Fail Traffic

Required

Specify whether or not to exclude fail traffic from results.

{True, False}

Default Value: False

Only Include Fail Traffic

Required

Specify whether or not to include only failed traffic.

{True, False}

Default Value: False

Campaign Data Only