Reporting

Adspect reporting is a comprehensive and valuable source of analytical information on your affiliate campaigns performance and traffic quality. It lets you do the following:

  • Evaluate traffic quality wholly or per source, publisher, ad spot, etc;

  • Build sales funnels of various depth and with flexible filtering by any traffic attributes;

  • Obtain detailed information about any particular click;

  • Download reports in CSV format.

Reporting section in your clients area is split into three parts:

  1. Report parameters: date range, time zone, funnel groupings, filters;

  2. Sales funnel table;

  3. Click log table.

Once report parameters are set, hit the Report button to build a sales funnel report and pull its click log. You may delete data by these parameters from Adspect reporting by pressing the Delete button.

Both tables have a Download .CSV button in the bottom left corner, for downloading reports in CSV format. You may import them into Microsoft Excel, Apple Numbers, Google Sheets, or similar spreadsheet software.

Please do not select overly broad date ranges as it will lead to huge dataset fetching and additional strain on our servers. We limit the total number of rows that will be included in a report, so you may get an incomplete report if its date range is too broad.

Sales Funnels

Sales funnels are produced by splitting click log into groups and computing summary statistical metrics on per-group basis. Adspect offers a dozen of different groupings: by date, stream, country, subaccount, etc. Grouping may be nested, e.g. Date + Stream would first split data by dates and then by individual streams on each date. This way you can combine different groupings to analyze various sales funnels.

Sales Funnel Columns

The sales funnel table consists of the grouping columns on the left followed by statistical columns. Some of them display a gray percentage value following a slash–that is the percentage of the total number of clicks, for convenience.

Statistical columns are:

Column

Description

Clicks

Total number of clicks.

Uniques

Approximate number of unique visitors as per uniqueness of their IP addresses.

FP

Number of visitors that successfully produced a JavaScript fingerprint. This figure may be less than the total number of clicks for various reasons, most often due to inability of dumb bots to run JavaScript code.

Money Hits

Number of visitors that have been shown the money page.

Money Uniques

Number of unique visitors that have been shown the money page.

Safe Hits

Number of visitors that have been shown the safe page.

GIVT

General invalid traffic, that is, the number of visitors blocked by superficial filters such as IP address blacklists, user agent matching, targeting, day parting (schedule), etc.

SIVT

Sophisticated invalid traffic, that is, the number of browser fingerprints that Adspect consciously filtered out as bad traffic.

MIA

Clicks missing in action, the figure computed as the number of visitors that failed to produce or submit a browser fingerprint. As mentioned above, these are often dumb bots with missing JavaScript support. Another common reason is network latency, especially evident in traffic with slow connection rates, e.g. 3G/EDGE, when visitors manage to close the tab or window before their fingerprint is submitted.

Quality

Percentage of money hits in the whole click volume. This is the best metric for evaluating traffic quality as a whole and may be used to compare different traffic sources, publishers, ad spots, etc. Especially useful with grouping by sub ID for compiling blacklists of bot-ridden zones, as described in the dedicated paragraph.

Expenses

Total traffic cost computed as a sum of costs of each click, if passed via URL parameter.

Conversions

Total number of conversions as accounted via the postback mechanism.

CR

Conversion rate computed as conversions / clicks.

Revenue

Gross revenue of the funnel as accounted via the postback mechanism.

Profit

Net profit computed as revenue − cost.

ROI

Return of investment computed as profit / cost.

CPC / CPM

Cost per click computed as cost / clicks, and cost per mille computed as CPC × 1000.

CPA

Cost per action computed as cost / conversions.

EPL

Earn per lead computed as revenue / conversions.

eCPM

Effective cost per mille computed as revenue / clicks × 1000.

Click Log

Click log contains detailed information on every click that was processed by Adspect.

Click Log Columns

Click log consist of the following columns:

Column

Description

Timestamp

Date and time of the click or conversion.

IP Address

IP address of the visitor.

ASN

Autonomous system number of the visitor.

Stream

Name of the stream and a link to it.

Country

Two-letter country code of the visitor.

OS

Visitor’s operating system.

Browser

Visitor’s browser.

Engine

Visitor’s browser engine.

Cost

Cost click or payout of the conversion.

Sub ID

Subaccount ID of the click.

Click ID

Unique ID of the click.

Mode

Stream mode at the moment of click.

Status

Page displayed to the visitor, and a list of reasons if the click was blocked.

CSV Click Log Columns

Click log in CSV format consist of the following columns:

Column

Description

timestamp

Date and time of the event.

account_id

Account ID.

stream_id

Stream ID.

ip_address

IP address of the visitor.

asn

Autonomous system number of the visitor.

country_code

Two-letter country code of the visitor.

os

Visitor’s operating system.

browser

Visitor’s browser.

engine

Visitor’s browser engine.

cost

Cost click, if passed via URL parameter.

sub_id

Subaccount ID of the click.

click_id

Unique ID of the click.

mode

Stream mode at the moment of click.

sequence

Click processing stage: 0 for basic checks, 1 for JavaScript fingerprint analysis, 255 for conversion.

target

Page displayed: 0 for safe page, 1–255 for money page with the corresponding ordinal number.

tags

List of mnemonic tags that represent particular filtering reasons.

Tags

Each blocked click has tags that indicate why it was blocked. The most common tags are described below. Other tags not listed in the table indicate various bot signatures.

Tag

Description

C1

Visitor blocked by primary cloaking algorithms.

IP, EX

Visitor blocked by High filtering level algorithms.

PARANOID

Visitor blocked by Paranoid filtering level algorithms.

BL

IP address blacklisted in stream IP/ASN blacklist.

GBL

IP address blacklisted in global IP/ASN blacklist.

WL

IP address not whitelisted in stream or global IP/ASN whitelist.

UNIQ

Non-unique visitor.

BOT

Public bot (Googlebot, Facebot, Twitterbot, etc.)

NOGEO

IP address has no officially assigned country code.

GEO

Country mismatch.

OS

Operating system mismatch.

BROWSER

Browser mismatch.

LANG

Browser language mismatch.

TZ

Time zone mismatch.

IPTZ

Browser time zone does not match IP address time zone.

RULE

Visitor blocked by stream URL rule(s).

UARE

Visitor blocked by stream user agent blacklist.

REF

Visitor blocked by stream referrer filter.

NOPAGE

No money page in stream settings, or all money pages disabled.

EMBED

Embeddeding detected (<iframe>, <embed>, <object>, etc.)