Running Reports in CAKE

Jeff Olliver

Modified on: Sat, 20 Jun, 2026 at 6:50 PM

This article will cover the following:

Report Types Available
How to Run a Report
Key Columns Explained
Exporting Report Data
Scheduled Reports
API: Reporting Endpoints

Report Types Available

Report Name	What It Shows	Best For
Summary Report	High-level totals across offers, affiliates, or advertisers.	Daily check-ins, executive overviews.
Conversion Report	Individual conversion records with timestamps, sub IDs, and status.	Auditing transactions, dispute resolution.
Click Report	Raw click data including device, geo, and referrer details.	Traffic quality analysis.
Offer Report	Performance broken down by individual offer.	Comparing offer performance side by side.
Affiliate Report	Performance grouped by affiliate partner.	Account managers reviewing partner activity.
Advertiser Report	Revenue and margin data by advertiser.	Advertisers reviewing campaign spend.

Note:
Reports available to you depend on your role. Affiliates see their own data only. Account managers have access to all report types.

How to Run a Report

Click Reports in the main navigation and select the report type.
Set your date range — use presets (Today, This Week, Last Month) or a custom range.
Apply filters: offer, affiliate, advertiser, country, device type, conversion status, or sub ID.
Choose a Group By dimension to organize rows — by date, offer, affiliate, or country.
Click Run Report. Results load in the table below your filter options.

Caution:
Very wide date ranges with no filters can return a large volume of data and may time out. Narrow the date range or add at least one filter if this happens.

Key Columns Explained

Column	What It Means
Clicks	Total tracking link clicks processed by CAKE during the selected period.
Conversions	Completed actions recorded. May include all statuses unless you filter by status.
Conversion Rate (CR)	Conversions ÷ clicks, as a percentage.
EPC (Earnings Per Click)	Total payout ÷ total clicks. Useful for comparing offer value across traffic sources.
Revenue	Total amount billed to the advertiser for approved conversions.
Payout	Total amount owed to affiliates for approved conversions.
Margin	Revenue minus payout — the network's gross profit. Visible primarily to account managers.

Exporting Report Data

Run the report with your desired date range and filters applied.
Click the Export button near the top right of the results table.
Choose CSV or Excel and download the file.

Caution:
Export only after the report has fully loaded. Exporting before results finish may produce an incomplete file.

Scheduled Reports

Set a report to run automatically and deliver results to your inbox. After configuring your filters, click Schedule or Create Schedule, choose a frequency (daily, weekly, or monthly), add recipient email addresses, and save. See the Schedules & Automated Reports article for full setup details.

API: Reporting Endpoints

All report endpoints use GET requests, return paginated JSON, and require start_date and end_date in YYYY-MM-DD format.

Offer Report

GET /api/2/report/offer.json

Parameter	Type	Required	Description
start_date	date	Yes	Report start date (YYYY-MM-DD).
end_date	date	Yes	Report end date (YYYY-MM-DD).
offer_id	integer	No	Filter to a single offer.
affiliate_id	integer	No	Filter to a single affiliate.
advertiser_id	integer	No	Filter to a single advertiser.
start_at_row	integer	No	Pagination offset. Default: 0.
row_limit	integer	No	Max rows. Default: 25.

Sample request

GET https://yourdomain.cakemarketing.com/api/2/report/offer.json
  ?api_key=YOUR_API_KEY
  &start_date=2024-01-01
  &end_date=2024-01-31
  &offer_id=12345

Sample response

{
  "request_status": "Success",
  "offer_report": [{
    "offer_id": 12345,
    "offer_name": "Summer Promo",
    "clicks": 3840,
    "conversions": 192,
    "revenue": 1800.00,
    "cost": 900.00,
    "profit": 900.00,
    "cr": 0.0500
  }]
}

Affiliate Report

GET /api/2/report/affiliate.json

Parameter	Type	Required	Description
start_date	date	Yes	Report start date (YYYY-MM-DD).
end_date	date	Yes	Report end date (YYYY-MM-DD).
affiliate_id	integer	No	Filter to a single affiliate.
offer_id	integer	No	Filter to a single offer.
start_at_row	integer	No	Pagination offset. Default: 0.
row_limit	integer	No	Max rows. Default: 25.