Skip to main content

FluentCo

FluentCo is an affiliate marketing network built on the HasOffers platform. The Extract connector pulls conversion and aggregated performance data from the HasOffers Reporting API.

Source Setup Guide​

To connect FluentCo to Extract, you'll need an API Key with read access to the Reporting API.

Contact your FluentCo account manager to obtain your API key.

Connection Setup Guide​

After connecting FluentCo to a destination, configure the following settings:

  • Connection Pull Schedule: How frequently Extract pulls data from FluentCo.
  • Backfill (Days): How many days of historical data to include on each run (default: 7 days).
  • Destination-specific settings: Settings such as Dataset Name or Target Schema (varies by destination).
  • Schema Migration Policy: How Extract handles schema changes from the source.

Configuration​

FieldTypeRequiredDescription
api_keystringYesYour HasOffers API key with Reporting API access.
backfillintegerNoNumber of days of historical data to sync (default: 7).

Data Retention​

The FluentCo API retains conversion-level data for approximately 762 days. Older data is not available through the API. To retrieve historical data beyond this window, contact FluentCo support.

Schema ERD​

Explore the interactive entity relationship diagram for FluentCo.

Open page

Data Streams​

conversions​

Individual conversion events from the HasOffers Report.getConversions endpoint. Each row represents a single conversion with its associated offer, affiliate, and advertiser details.

  • Sync behavior: Partitioned by conversion date. The connector re-reads the backfill window on each run to capture status changes (approved, rejected, pending).
  • Enabled by default: No (must be explicitly selected).
Loading ....

daily_report​

Aggregated daily performance statistics from the HasOffers Stats API. Includes impressions, clicks, conversions, revenue, payout, and profit metrics with full dimension breakdowns.

  • Sync behavior: Partitioned by date. Replaces existing data for each date in the sync window.
  • Device dimensions: When device fields are included, API history is limited to 184 days.
Loading ....

Field Naming​

Fields from the HasOffers API use Extract's standard snake_case flattening:

  • Stat fields retain their original names (e.g., advertiser_id, offer_id, revenue).
  • Dimension paths are flattened with double underscores (e.g., Advertiser.company becomes advertiser__company).

Amounts retain their original reported currency; no currency conversion is applied.