MDH GROUP · BLOG

Measuring Advertising Asset Performance in Affilentra: Asset IDs, UTM Standards and Reporting Best Practices

Measuring advertising assets in a controlled way is a prerequisite for efficient partner management. Affilentra brings tracking, commission calculation and billing into a self‑hosted platform with clearly separated roles for software operators, merchants and partners.

← All posts

Measuring Advertising Asset Performance in Affilentra: Asset IDs, UTM Standards and Reporting Best Practices

Introduction

Measuring advertising assets in a controlled way is a prerequisite for efficient partner management. Affilentra brings tracking, commission calculation and billing into a self‑hosted platform with clearly separated roles for software operators, merchants and partners. This article shows concretely how to link asset IDs with UTM parameters, analyze tracking links and export advertising asset performance via the Affilentra reporting — including actionable templates for merchants.

1. Preparation: Create Asset IDs and UTM Conventions

Before the technical setup you need a consistent naming and parameter convention. Define the following rules in a few minutes and document them for partners:

  • Asset ID: Short, unambiguous, e.g. ASSET_123 or banner_300x250_v1. You will later link this ID to the asset in Affilentra.
  • UTM standards: Consistent values for the essential parameters:
    • utm_source: affilentra_{partnerID} or network_name — makes the source unambiguous.
    • utm_medium: banner | email | social | textlink — classifies the format.
    • utm_campaign: product code or time‑limited promotion, e.g. summer23_sale.
    • utm_content: Asset ID (e.g. ASSET_123) or variant (colorA).
  • Document templates: A short spreadsheet with allowed values increases consistency and reporting quality.

2. Create Asset in Affilentra and Link with UTM Template

Practical steps (Admin / Merchant role):

  • Create a new advertising asset in Affilentra: title, description, asset ID, file upload (banner, HTML, download link).
  • Fill in a UTM template field for the asset (or the "Landing URL Template" field). Example template for the landing page: https://shop.beispiel/landing?utm_source=affilentra_{partnerID}&utm_medium=banner&utm_campaign=summer23&utm_content=ASSET_123.
  • If Affilentra supports tokens: use placeholders like {partner_id} or {asset_id} so links are generated dynamically. If not, create the finished template per partner manually.
  • Configure whether the UTM parameters should be forwarded to the tracking URL or to the final destination URL. Important: the final redirection must preserve query strings.

3. Tracking Link Generation and Validation

How to ensure UTMs arrive correctly:

  1. Create a partner tracking link in Affilentra for the respective asset. The tracking link should include the partner identifier and point to the defined landing page.
  2. Check whether the tracking domain or the redirect forwards the query parameters (UTM). Perform a test click and inspect the URL on the landing page (browser address bar, server logs or analytics).
  3. If UTMs are lost: Adjust the redirect logic so that the utm_ parameters are appended or forwarded. Common causes are incorrect 302/301 redirects without query-string forwarding or JavaScript redirects that remove parameters.
  4. Also validate that Affilentra stores click and conversion events linked with the asset ID and the UTM fields — you will need these fields later in reporting.

4. Analysis of Tracking Links in Affilentra

For daily evaluations, use the role-specific filters and views:

  • Filter by Asset ID: Restrict clicks and conversions to individual creative assets.
  • Filter by UTM parameters: Search for utm_campaign or utm_content to compare campaigns and variants.
  • Segmented by Partner: Combinations of asset ID and partner reveal the actual partner performance.
  • Timeframe and Conversion Status: Pay attention to different attribution windows (cookie lifetime) and only review validated conversions when billing is due.

Practical verification steps:

  1. Click a tracking link as a test user and trigger a test conversion (e.g., form submission, test purchase) to see how Affilentra displays the conversion with asset and UTM.
  2. Compare the raw data (click log) with the UI aggregate: Do click counts and attributions match?
  3. Use vendor logs (server logs) and Google Analytics in parallel to identify inconsistencies in UTM forwarding.

5. Reporting Export: Step by Step

How to generate exportable reports for billing and optimization:

  1. Open the export function in the Affilentra reporting area.
  2. Select filters: timeframe, asset ID(s), partner(s), utm_campaign, conversion status.
  3. Select metrics: clicks, conversions, revenue, commission amount, payout, conversion rate (formula), EPC (earnings per click) — if available.
  4. Export format: CSV or XLSX. Export raw data for pivot analyses and an aggregate sheet for quick decisions.

Example: Recommended Report Columns

  • asset_id
  • asset_name
  • partner_id
  • utm_campaign
  • utm_content
  • clicks
  • conversions
  • conversion_rate = conversions / clicks
  • revenue
  • commission
  • payout_status

Example: Simplified Report Layout (Export)

Columns: Asset ID | Asset Name | Partner | Clicks | Conversions | CVR (%) | Revenue | Commission | Pending Payout

Note: Use pivot tables in Excel or Google Sheets: Group by Asset ID and Partner, calculate Sum(Clicks), Sum(Conversions) and derive Conversion Rate and EPC using formulas.

6. Interpretation and Optimization

Concrete actions based on the reports:

  • Asset with many clicks but few conversions → Creative A/B test: check image, CTA, landing URL; verify that UTM is correct and targeted.
  • Asset with high conversion but low reach → Increase budget or placements; brief partners selectively.
  • Partner comparison for the same asset → Identify which partners deliver traffic quality (EPC, conversion rate) and adjust terms if necessary.

7. Troubleshooting: Common Errors and Solutions

  • UTM missing in analytics: Check whether the tracking link appends the parameters or whether the landing page overwrites query strings.
  • Remove duplicate redirects: Each additional server redirect chain can cause parameters to be lost.
  • Unclear partner attribution: Ensure partner IDs are included unambiguously in the UTM source or in the Affilentra tracking link.
  • Discrepancies between platform reports and shop data: Compare conversion definitions (e.g., “order confirmed” vs. “payment confirmed”).

Conclusion and Short Implementation Plan

Short-term to-dos (first 72 hours):

  • Document UTM conventions.
  • Create the top 10 assets in Affilentra and configure UTM templates.
  • Perform test clicks and validate query strings.
  • Create the first export and prepare a pivot template.

With these steps you reliably link Asset IDs to UTMs, obtain meaningful tracking data, and can systematically measure and settle advertising assets. Affilentra provides the self-hosted infrastructure and role-based control so merchants retain control over products, terms and creative assets while partners can use personal tracking links and access transparent payout histories.

Act now: Choose an entry and test Affilentra: Choose an entry

Next step

Try Affilentra yourself

Unified platform that transparently brings together product provisioning, tracking, conversion validation, commission calculation and payout across clearly separated roles; option for self‑hosted installation with a perpetual license and no revenue share; merchants retain control over products, terms and ad assets; partners receive personal tracking links and a transparent payout history.

Choose how to get started