Reports export

Exports aggregated performance statistics as a GZIP-compressed CSV file. The requested dimensions define how rows are grouped.

Request example

curl -X POST https://affiliatecontrol-api.com/external/exports/report \
  -H "x-access-key: ak_example123" \
  -H "x-secret-key: sk_example456" \
  -H "Content-Type: application/json" \
  -d '{
    "start_timestamp": "2026-06-01T00:00:00Z",
    "end_timestamp": "2026-06-30T23:59:59Z",
    "dimensions": ["date_raw", "site_id", "affiliate_id"],
    "site_id": ["site_abc"],
    "currency_code": "USD",
    "webhook_url": "https://example.com/hook"
  }'

Parameters:

• date (String): A single calendar day in YYYY-MM-DD format. Required when start_timestamp and end_timestamp are omitted. The report covers the full UTC day.
• start_timestamp (String): Start of a custom UTC interval in YYYY-MM-DDTHH:mm:ssZ format. Must be provided together with end_timestamp.
• end_timestamp (String): End of a custom UTC interval in YYYY-MM-DDTHH:mm:ssZ format. The interval cannot exceed 30 days. Do not provide date with the timestamp pair.
• dimensions (Array of String): Fields used to group report rows. Accepts up to 10 supported values. Pass an empty array for a report without grouping. Defaults to date_raw, site_id, site_player_id, player_country_code, affiliate_id and affiliate_offer_id.
• site_id (Array of String): Limit to specific sites. Defaults to all of your sites.
• currency_code (String): Currency for money metrics. Defaults to your account's default currency.
• webhook_url (String): URL notified when the file is ready.

Supported dimensions values:

affiliate_id
affiliate_email
sub_affiliate_email
year_raw
start_of_quarter_raw
start_of_month_raw
start_of_week_raw
date_raw
marketing_material_name
media_buying_campaign_name
media_buying_root_campaign_name
affiliate_offer_id
affiliate_offer_name
offer_type_name
affiliate_offer_settings_name
player_country_code
site_player_id
site_id
site_name
site_registration_type_name
team_name
traffic_source_name

Response:

{ "id": "export-id-here" }

Default output fields

The table shows the column order when dimensions is omitted. When dimensions is provided, the selected dimension columns appear first in the requested order, followed by all metric columns.

#	Field	Type	Description
1	date_raw	string (date)	UTC calendar date for the row.
2	site_id	string	Site ID.
3	site_player_id	string	Player ID.
4	player_country_code	string	Player country code (ISO 3166-1 alpha-2).
5	affiliate_id	string	Affiliate ID.
6	affiliate_offer_id	string	Offer ID.
7	impressions_count	number	Promo Materials Impressions.
8	visits_count	number	Number of Visits.
9	registrations_count	number	Number of Registrations.
10	deposits_first_count	number	Number of First Deposits.
11	deposits_first_sum	number	Sum of First Deposits.
12	deposits_second_count	number	Number of Second Deposits.
13	deposits_second_sum	number	Sum of Second Deposits.
14	deposits_third_count	number	Number of Third Deposits.
15	deposits_third_sum	number	Sum of Third Deposits.
16	deposits_other_count	number	Number of Redeposits.
17	deposits_other_sum	number	Sum of Redeposits.
18	deposits_all_count	number	Number of all Deposits.
19	deposits_all_sum	number	Sum of all Deposits.
20	deposits_withdrawals_count	number	Number of Withdrawals.
21	deposits_withdrawals_sum	number	Sum of Withdrawals.
22	bet_new_count	number	Number of Bets.
23	bet_new_sum	number	Sum of Bets.
24	bet_new_sports_count	number	Number of Sports Bets.
25	bet_new_sports_sum	number	Sum of Sports Bets.
26	bet_new_games_count	number	Number of Casino/Slots/Etc Bets.
27	bet_new_games_sum	number	Sum of Casino/Slots/Etc Bets.
28	bet_result_sum	number	Win Sum — winnings sum (all).
29	bet_result_sports_sum	number	Winnings Sum from Sports.
30	bet_result_games_sum	number	Winnings Sum from Casino.
31	avg_bet_amount	number	Average Bet.
32	median_bet_amount	number	Median Bet.
33	avg_sports_bet_amount	number	Average Sports Bet.
34	median_sports_bet_amount	number	Median Sports Bet.
35	avg_games_bet_amount	number	Average Casino Bet.
36	median_games_bet_amount	number	Median Casino Bet.
37	deposit_bonus_count	number	Number of Bonuses for Deposit.
38	deposit_bonus_sum	number	Sum of Bonuses for Deposit.
39	profit_sum	number	GGR — Gross Gaming Revenue.
40	net_profit_sum	number	NGR — Net Gaming Revenue.
41	total_fees_sum	number	Total Fees — the sum of all commissions paid by the affiliate program.
42	deposit_fee_total_sum	number	Total Deposits Fee — commission of payment systems for processing deposits.
43	withdrawal_fee_total_sum	number	Total Withdrawal Fee — commission of payment systems for processing withdrawals.
44	sport_fee_total_sum	number	Total Sports Betting Fee — platform commission for the processing of sports bets.
45	casino_fee_total_sum	number	Total Casino Bets Fee — platform commission for processing bets in a casino.
46	gaming_tax_fee_total_sum	number	Total Gaming Tax — gaming tax assessed in accordance with the player's jurisdiction.
47	admin_fee_total_sum	number	Total Admin Fee — affiliate program platform commission for administration.
48	revenue_sum	number	Affiliate Income — revenue minus affiliate fees.
49	revshare_revenue_sum	number	Affiliate RS Income — RevShare revenue minus affiliate fees.
50	sports_revshare_revenue_sum	number	Affiliate RS Income (Sports) — RevShare revenue minus affiliate fees, sports only.
51	games_revshare_revenue_sum	number	Affiliate RS Income (Games) — RevShare revenue minus affiliate fees, games only.
52	cpa_revenue_sum	number	Affiliate CPA Income — CPA revenue.
53	affiliate_fees_sum	number	Affiliate Fees — part of the total commission amount distributed according to the percentage of RevShare between the partner and the partner program.
54	deposit_fee_affiliate_sum	number	Affiliate Deposits Fee — affiliate part of the commission of payment systems for deposits in accordance with the percentage of RevShare.
55	withdrawal_fee_affiliate_sum	number	Affiliate Withdrawal Fee — affiliate part of the commission of payment systems for withdrawals in accordance with the percentage of RevShare.
56	sport_fee_affiliate_sum	number	Affiliate Sports Betting Fee — affiliate part of the commission of the platform for the processing of sports bets.
57	casino_fee_affiliate_sum	number	Affiliate Casino Bets Fee — affiliate part of the platform commission for processing bets in the casino.
58	gaming_tax_fee_affiliate_sum	number	Affiliate Gaming Tax — affiliate part of the gaming tax.
59	admin_fee_affiliate_sum	number	Affiliate Admin Fee — affiliate part of the affiliate program platform commission for administration.
60	chargebacks_sum	number	Chargebacks — total sum of chargebacks.
61	project_roi	number	ROI — return on investment.
62	affiliate_program_profit_sum	number	Net Project Profit.
63	project_costs_sum	number	Project Costs — project costs amount.
64	deposits_first_avg	number	Average first deposit amount.
65	deposits_first_median	number	Median first deposit amount.
66	deposits_other_avg	number	Average redeposit amount.
67	deposits_other_median	number	Median redeposit amount.
68	deposits_all_avg	number	Average deposit amount.
69	deposits_all_median	number	Median deposit amount.
70	players_with_first_deposit_count	number	Number of players with a first deposit.
71	players_with_redeposit_count	number	Number of players with a redeposit.
72	players_with_deposit_count	number	Number of players with a deposit.
73	players_with_bet_count	number	Number of players with a bet.
74	players_uniq_count	number	Number of unique players.
75	sports_ggr_sum	number	Gross gaming revenue from sports.
76	games_ggr_sum	number	Gross gaming revenue from casino games.
77	media_buying_payments_sum	number	Media buying payments amount.
78	affiliate_balance_correction_sum	number	Affiliate balance correction amount.