What it does
The Pull Stats step connects to your tracking platform and fetches a table of stats for the date range you specify. Each cell you select in the results becomes a variable that can be used in any later step — email subjects and bodies, invoice templates, conditions, and more.
This is typically the first step in any automation.
When to use it
Use a Pull Stats step whenever you need live data from your tracker in an automation:
- Pulling weekly or monthly revenue and payout numbers per affiliate
- Getting conversion counts to check against a condition
- Fetching offer-level performance before generating invoices
Configuration
Connection
Select which of your saved connections to use. The available stat types in the next field depend on which platform you select here.
Stat Type
Choose how the data should be grouped. Available options depend on your platform:
| Platform | Available Stat Types |
|---|
| Affise Admin | By Affiliate, By Advertiser, By Date |
| Affise Affiliate | By Offer |
| CAKE | Daily Summary, Campaign Summary |
| Binom | By Traffic Source, By Campaign, By Date |
Date Preset
Choose the date range for the stats query. See Date Presets for a full explanation of each option. For scheduled automations, always use a preset (not a custom date) so the range stays fresh on every run.
Timezone
Select the timezone that matches your tracking platform’s reporting timezone. This ensures “Yesterday” and “Last 7 Days” map to the same time windows you’d see in your tracker’s own UI.
Filters (optional)
Some stat types support additional filters to narrow results — for example, filtering by a specific offer ID or affiliate ID. Leave blank to fetch all data.
Running a Test Pull
After configuring the step, click Test Pull to fetch a live preview from your tracker. The results appear as a table below the configuration form.
This preview uses the real API — the data is live, not sample data.
Selecting Variables
Once the test pull results appear, click on any cell to select it as a variable:
- Selected cells turn highlighted
- The variable name is automatically generated (e.g.
{affiliate_name_1_stats_1})
- The variable appears in the Variables Available panel on the left
You can select as many cells as you need across as many rows as you need. Each selected cell becomes an independently usable variable in later steps.
Select the affiliate name, revenue, payout, and any other columns you’ll reference in your email. You don’t need to select everything — just the cells you’ll actually use.
AffZero stores the entity ID (e.g. affiliate ID) alongside each selected cell, not just the row position. This means that even if the table order changes on future runs, the correct values will always be matched to the right affiliate. See Variables for details.
Multiple Pull Stats Steps
You can add more than one Pull Stats step to a single automation — for example, to pull stats from two different connections or two different stat types. Each step gets its own suffix:
- First Pull Stats step:
{affiliate_name_1_stats_1}
- Second Pull Stats step:
{affiliate_name_1_stats_2}
All variables from all Pull Stats steps are available to any subsequent step.
Common Issues
| Issue | What to check |
|---|
| Test pull returns empty results | Confirm data exists in this date range by checking your tracker directly |
| Test pull fails with an error | Verify your connection is still valid (API key not expired, base URL correct) |
| Variables don’t appear in later steps | Make sure you clicked cells to select them — just viewing the table doesn’t create variables |
| Wrong numbers in the email | Check that the Pull Stats step timezone matches your tracker’s timezone |
