How to Pull Conversion and Sub ID Reports via the CAKE API

Jeff Olliver

Modified on: Sat, 20 Jun, 2026 at 10:18 AM

This article will cover the following:

Conversion Report
Sub ID Report

When to use these endpoints:
Use these endpoints for granular analysis — the Conversion Report for fraud review and payout auditing, and the Sub ID Report for placement-level performance attribution within affiliate campaigns.

Authentication: All CAKE API requests require your api_key parameter. Find yours under Setup → System Access → API Keys.

Part of a series: This focused guide covers specific endpoints from the complete CAKE API — Reporting reference, which documents all available endpoints for this feature area.

Available Endpoints

Conversion Report

Row-level visibility into individual conversion events including status. Critical for fraud review, payout reconciliation, and postback debugging.

When to use: Audit individual conversion records; filter by status to find rejections; debug postback issues by inspecting conversion-level data.

GET /api/2/report/conversion.json

Parameter	Type	Required	Description
api_key	string	Yes	Your CAKE API key.
start_date	date	Yes	Start date (YYYY-MM-DD).
end_date	date	Yes	End date (YYYY-MM-DD).
offer_id	integer	No	Filter by offer.
affiliate_id	integer	No	Filter by affiliate.
conversion_status	string	No	`approved` \| `pending` \| `rejected`
start_at_row	integer	No	Pagination offset.
row_limit	integer	No	Max rows. Default 100, max 10000.
sort_field	string	No	Field to sort by.
sort_descending	boolean	No	`true` for descending.

Sample request

GET https://yourdomain.cakemarketing.com/api/2/report/conversion.json?api_key=YOUR_API_KEY&start_date=2026-01-01&end_date=2026-01-31&offer_id=12345&conversion_status=approved&row_limit=100

Sample response

{
  "request_status": "Success",
  "response": {
    "data": {
      "conversions": [
        {
          "conversion_id": 998877,
          "conversion_date": "2026-01-15 14:30:00",
          "offer_id": 12345,
          "affiliate_id": 67890,
          "payout": 18.00,
          "revenue": 22.00,
          "conversion_status": "approved",
          "unique_id": "ORD-98765"
        }
      ]
    }
  }
}

Sub ID Report

Breaks down performance by Sub ID values — identify which sub-publishers, placements, or channels drive the best results within a campaign.

When to use: Identify best-performing sub-publishers or traffic placements within an affiliate's campaign.

GET /api/2/report/subid.json

Parameter	Type	Required	Description
api_key	string	Yes	Your CAKE API key.
start_date	date	Yes	Start date (YYYY-MM-DD).
end_date	date	Yes	End date (YYYY-MM-DD).
offer_id	integer	No	Filter to a single offer.
affiliate_id	integer	No	Filter to a single affiliate.
sub_id	string	No	Filter to a specific Sub ID value.
start_at_row	integer	No	Pagination offset.
row_limit	integer	No	Max rows. Default 100, max 10000.