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 form: 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.

The list of statistical columns (CSV report column names written in parentheses):

  • Clicks (clicks) – total number of clicks.
  • Uniques (uniques) – approximate number of unique visitors as per uniqueness of their IP addresses.
  • FP (fingerprints) – 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 (money_hits) – number of visitors that have been shown the money page.
  • Money Uniques (money_uniques) – number of unique visitors that have been shown the money page.
  • Safe Hits (safe_hits) – number of visitors that have been shown the safe page.
  • GIVT (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 (sivt) – sophisticated invalid traffic, that is, the number of browser fingerprints that Adspect consciously filtered out as bad traffic.
  • MIA (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 (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 parapgraph.
  • Expenses (expenses) – total traffic cost computed as a sum of costs of each click, if passed via URL parameter.
  • Conversions (conversions) – total number of conversions as accounted via the postback mechanism.
  • CR (cr) – conversion rate computed as conversions / clicks.
  • Revenue (revenue) – gross revenue of the funnel as accounted via the postback mechanism.
  • Profit (profit) – net profit computed as revenue − cost.
  • ROI (roi) – return of investment computed as profit / cost.
  • CPC / CPM (cpc) – cost per click computed as cost / clicks, and cost per mille computed as CPC × 1000.
  • CPA (cpa) – cost per action computed as cost / conversions.
  • EPL (epl) – earn per lead computed as revenue / conversions.
  • eCPM (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:

  • Timestamp – date and time of the click or conversion;
  • IP Address – IP address of the visitor;
  • ASNautonomous system number of the visitor;
  • Stream – name of the stream and a link to it;
  • CountryISO 3166-1 alpha-2 country code of the visitor;
  • OS – name of the visitor’s operating system;
  • Browser – name of the visitor’s browser;
  • Engine – name of the visitor’s browser’s engine;
  • Cost – cost of the click or payout of the conversion;
  • Sub IDsubaccount ID of the click;
  • Click IDunique 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:

  • timestamp – date and time of the event;
  • account_id – account ID;
  • stream_id – stream ID;
  • ip_address – IP address of the visitor;
  • asnautonomous system number of the visitor;
  • country_codeISO 3166-1 alpha-2 country code of the visitor;
  • os – name of the visitor’s operating system;
  • browser – name of the visitor’s browser;
  • engine – name of the visitor’s browser’s engine;
  • cost – cost of the click, if passed via URL parameter;
  • sub_idsubaccount ID of the click;
  • click_idunique ID of the click;
  • mode – stream mode at the moment of click;
  • sequence – click processing stage:
    • 0 – basic checks;
    • 1 – JavaScript fingerprint analysis;
    • 255 – conversion;
  • target – target page shown to the visitor:
    • 0 – safe page;
    • 1–255 – money page with the corresponding ordinal number;
  • tags – list of mnemonic tags that represent particular filtering reasons (see below.)

Tags

The exact nature of click tags is a trade secret–we do not disclose our filtering techniques. However, we do give out information about some of them that can be used as proofs of bot traffic (e.g. for demanding refunds from ad networks) or for debugging purposes:

  • IP, EX – IP address blacklisted by us: proxies, VPN and hosting providers, antivirus companies, ad scoring companies, security companies, known moderator origins, etc;
  • BL – IP address blacklisted by the stream IP/ASN blacklist;
  • GBL – IP address blacklisted by the global IP/ASN blacklist;
  • WL – IP address not whitelisted by the stream or global IP/ASN whitelist;
  • LIMIT – IP address blocked due to exceeding its click limit;
  • BOT – visitors that identify themselves as bots, including known device emulators and virtualized environments;
  • PARANOID – visitors blocked by paranoid mode;
  • NOGEO – IP address has no officially assigned country code;
  • GEO, OS, BROWSER, LANG, TZ, IPTZ – visitors blocked by manual stream filters;
  • RULE – visitors blocked by a user-defined URL rule;
  • UARE – visitors whose user agent matched customer-supplied regular expression;
  • REF – visitors whose referer matched customer-supplied regular expression;
  • NOPAGE – no money page specified in stream settings, or all money pages are turned off;
  • EMBED – embeddeding detected (<iframe>, <embed>, <object>, etc.)