FreshReach™ raw reporting creates a JSON document of all reported data within a specific time frame.

Report Parameters

Example: http://freshreach.co/report-raw.php?token=YOUR_TOKEN_HERE&start=2021-01-01&end=2021-01-31&offset=100&max=3000

Parameter

Value

Required?

token

Access Token

Required

aid

Affiliate ID

Optional

If an Affiliate ID is not specified, all Affiliate IDs available for your access level will be included in the data.

start

Date Format yyyy-mm-dd

Optional (Defaults to current date)

end

Date Format yyyy-mm-dd

Optional (Defaults to current date)

offset

Numerical Value (Used for pagination)

Optional (Defaults to 0)

max

Numerical Value (Max records to return)

Optional (Defaults to 1,000)

download

Optional. This parameter will force a JSON file download rather than display records to the screen.

Sample Returned Data:
{

“total_records”: 2200,
”results”: [
{
“id”: “000000”,
“action_status”: “APPROVED”,
“action_type”: “Sale”,
“commission_id”: “00000000”,
“country”: “US”,
“event_date”: “2020-11-18 19:42:32”,
“locking_date”: “2021-01-30”,
“order_id”: “00000000”,
“original”: ““,
“original_action_id”: “0”,
“posting_date”: “2020-11-18 21:22:55”,
“action_tracker_id”: “0000”,
“action_tracker_name”: “Sale”,
“advertiser_name”: “Merchant Name”,
“commission_amount”: “5.99”,
“order_discount”: “0”,
“sid”: “0000”,
“sale_amount”: “99.99”,
“network”: “Network Abbreviation”,
“timestamp”: “2020-12-18 44:32:35”,
“cid”: “0”
“networkId”: “0000”,
“currency”: “USD”,
“currencyConversionRate”: “1”,
“currencyConversionDate”: “2020-12-18 00:38:49”,
“convertedAmount”: 99.99”,
“convertedCommission”: “0”,
“networkStatus”: “approved”,
“merchant_name”: “Merchant Name”,
“merchant_id”: “00000”
}
]

}

**Please note: the report parameter aid matches to the returned value sid.