How to Pull Offer, Affiliate, and Advertiser Reports via the CAKE API

This article will cover the following:

When to use these endpoints:
Use these aggregated performance endpoints to build the core reporting layer for external dashboards — pulling clicks, conversions, payout, and revenue broken down by your key entities.
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

Offer Report

Aggregates performance at the offer level — clicks, conversions, payout, revenue, EPC, and conversion rate for each offer over a date range. Access via Reports → Offer Report in CAKE.

When to use: Identify highest/lowest performing offers, monitor revenue trends, compare performance across verticals or affiliates.
GET /api/2/report/offer.json
ParameterTypeRequiredDescription
api_keystringYesYour CAKE API key.
start_datedateYesStart of reporting range (YYYY-MM-DD).
end_datedateYesEnd of reporting range (YYYY-MM-DD).
offer_idintegerNoFilter to a single offer.
affiliate_idintegerNoFilter to a single affiliate.
advertiser_idintegerNoFilter to a single advertiser.
vertical_idintegerNoFilter by vertical.
country_idintegerNoFilter by country.
start_at_rowintegerNoPagination offset. Default 1.
row_limitintegerNoMax rows. Default 100, max 10000.
sort_fieldstringNoconversions | clicks | revenue | epc
sort_descendingbooleanNotrue for descending.

Sample request

GET https://yourdomain.cakemarketing.com/api/2/report/offer.json?api_key=YOUR_API_KEY&start_date=2026-01-01&end_date=2026-01-31&sort_field=conversions&sort_descending=true&row_limit=50

Sample response

{ "request_status": "Success", "response": { "data": { "offers": [ { "offer_id": 12345, "offer_name": "Auto Insurance Quote - US", "clicks": 8420, "unique_clicks": 7930, "conversions": 312, "conversion_rate": 3.71, "payout": 5616.00, "revenue": 6864.00, "profit": 1248.00, "epc": 0.667 } ], "totals": { "clicks": 8420, "conversions": 312, "payout": 5616.00, "revenue": 6864.00 } } } }


Affiliate Report

Aggregates clicks, conversions, and earnings by affiliate. Use to generate affiliate-facing statements, identify top performers, or automate tier reclassification.

When to use: Build affiliate earnings dashboards, identify top performers for tier upgrades, or automate performance-based payout adjustments.
GET /api/2/report/affiliate.json
ParameterTypeRequiredDescription
api_keystringYesYour CAKE API key.
start_datedateYesStart date (YYYY-MM-DD).
end_datedateYesEnd date (YYYY-MM-DD).
affiliate_idintegerNoFilter to a single affiliate.
offer_idintegerNoFilter to a single offer.
start_at_rowintegerNoPagination offset.
row_limitintegerNoMax rows. Default 100, max 10000.
sort_fieldstringNoclicks | conversions | payout | epc
sort_descendingbooleanNotrue for descending.

Sample request

GET https://yourdomain.cakemarketing.com/api/2/report/affiliate.json?api_key=YOUR_API_KEY&start_date=2026-01-01&end_date=2026-01-31&sort_field=payout&sort_descending=true

Sample response

{ "request_status": "Success", "response": { "data": { "affiliates": [ { "affiliate_id": 67890, "affiliate_name": "MediaBridge Partners", "clicks": 3210, "conversions": 142, "conversion_rate": 4.42, "payout": 2556.00, "epc": 0.796 } ] } } }


Advertiser Report

Aggregates performance by advertiser — clicks, conversions, and revenue. Use for advertiser billing reconciliation or revenue reporting.

When to use: Generate advertiser-facing revenue statements or audit conversion delivery before sending invoices.
GET /api/2/report/advertiser.json
ParameterTypeRequiredDescription
api_keystringYesYour CAKE API key.
start_datedateYesStart date (YYYY-MM-DD).
end_datedateYesEnd date (YYYY-MM-DD).
advertiser_idintegerNoFilter to a single advertiser.
offer_idintegerNoFilter to a single offer.
start_at_rowintegerNoPagination offset.
row_limitintegerNoMax rows. Default 100, max 10000.

Sample request

GET https://yourdomain.cakemarketing.com/api/2/report/advertiser.json?api_key=YOUR_API_KEY&start_date=2026-01-01&end_date=2026-01-31&advertiser_id=1021

Sample response

{ "request_status": "Success", "response": { "data": { "advertisers": [ { "advertiser_id": 1021, "advertiser_name": "Acme Financial Services", "clicks": 12500, "conversions": 487, "revenue": 10714.00 } ] } } }



If you have any questions, please reach out to your dedicated CAKE Client Success Manager/Account Manager or contact the CAKE Support Team at support@getCAKE.com.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.