tl;dr
The Influencer Google Sheet is Klar's template for tracking influencer and affiliate partnerships as a datasource
Red fields are required — Klar will reject a row if any required field is missing
Row 1 contains field descriptions, Row 3 contains column headers — your data starts at Row 4
After filling in the sheet, connect it as a datasource in Klar. The Status column (AJ) shows whether each row was imported successfully
Looking for a more structured way to manage influencers? Consider the Influencer CRM instead
Getting the template
In Klar, go to Store Configurator → Data Sources → Add Data Source
Select Influencers (Google Sheet)
Klar will generate a new Google Sheet for you — open it from the datasource settings
Duplicate rows
If two or more rows share identical values across all of the following fields, Klar will import the entry exactly once — no matter how many duplicate rows exist, the data still comes through, just not multiple times:
Influencer/Affiliate Name
Campaign Name
Posting Date
End Date
utm_source, utm_medium, utm_campaign, utm_term, utm_content
Discount Code
This means you cannot have two separate entries for the same influencer, same campaign, same date, and same tracking parameters — the system treats them as one. If you work with an influencer multiple times within the same campaign, make sure at least one of the above fields differs (e.g. a different Posting Date, a different utm_term, or a different discount code).
Field reference
Campaign & partner details
Campaign Name (col A, optional) The campaign this partnership belongs to. For always-on programs, the month works well (e.g. June 2026). For project-based programs, use the campaign name (e.g. Summer Sale).
Influencer/Affiliate Name (col B, required) The full name of the creator or affiliate. Example: Pamela Reif
Handle (col C, optional) Their username on the relevant platform. Example: @pamreif
Platform (col D, required) Where the partnership is taking place — e.g. Instagram, YouTube, TikTok.
Link to Profile (col E, optional) The URL of their profile on the platform. Not yet used in reporting, but worth populating for future features.
Followers (col F, optional) How many followers the influencer has on this platform. Used for the Follower Bracket dimension in the Flex Table.
Reach (col G, optional) How many people actually saw the post. This can only be filled in after the post is live — leave it blank upfront and add it once the post has gone out.
Expected Reach (col H, optional) Your estimate of reach before the post goes live. Klar compares actual vs. expected in the Flex Table, so you can immediately see which influencers significantly over- or underdelivered against your brief.
Expected Sessions (col I, optional) Your estimate of sessions before the post goes live. Same logic as Expected Reach — Klar will show you how actual sessions compared to what you planned.
Type of Partnership (col J, required) How the partnership is structured. Options: Paid, Free, Product-based (or equivalent dropdown values).
Category (col K, required) The type of content this influencer posts — e.g. Fitness, Fashion, Beauty. You can categorise any way you want. The goal is to be able to later understand which categories are working best for you — so think about how you'd want to group influencers when analysing performance.
Post Type (col L, optional) The format of this specific post — e.g. Feed Post, Story, Reel, Sponsored Video.
# of Integrations (col M, optional) How many individual posts or placements are included in this deal.
Link to Post (col N, optional) The URL of the specific post. Not yet used in reporting, but planned for future features.
Posting dates & attribution window
Posting Date (col O, required — format: dd/mm/yyyy) The date the post goes live. Fixed costs and follower/reach metrics are assigned to this date. Revenue and orders are assigned to when they actually occurred.
End Date (col P, optional — format: dd/mm/yyyy) The date Klar stops assigning sessions and conversions to this partnership. If left blank, Klar continues assigning until a newer entry for the same influencer (same discount code AND same UTMs) appears in the sheet.
Example: Two entries for the same influencer — one on 2 Feb, one on 14 March. Conversions between 2 Feb and 13 March go to the first; conversions from 14 March onwards go to the second.
If you set an End Date, it acts as a hard cut — no further conversions are assigned after that date, even if no new entry follows.
⚠️ Data not showing in the Influencer Flex Table? Check whether the Posting Date has already passed. Klar only starts matching sessions and conversions to a partnership once the Posting Date is reached — if it's still in the future, the campaign hasn't started in the system yet.
Costs
Fixed Costs (col Q, required) The flat fee for this partnership, assigned to the posting date. Enter the number only — e.g. 5000.
Fixed Costs Distribution (col R, optional) How the fixed costs are spread across time in your reports. Leave blank to use the default.
Option | How it works |
Posting Date (default) | All costs assigned to the posting date |
3-Days Data Driven | Costs distributed across 3 days after posting date, weighted by expected revenue |
7-Days Data Driven | Same, but spread over 7 days |
Linear | Even daily distribution from posting date to end date — End Date must be set |
Variable Cost – Percentage (col S, optional) A revenue share for the partner — e.g. the influencer gets 5% of gross revenue. Enter the number only: 5, not 5%. No percent sign. If set, Cost Reference – Percentage (col T) must also be set.
Cost Reference – Percentage (col T, optional) Which revenue figure the percentage applies to.
Option | Meaning |
Percentage Gross Revenue | % of gross revenue |
Percentage Net Revenue | % of net revenue (after returns) |
Gross Rev Share Max | % of gross revenue, capped |
Variable Costs – Fee (col U, optional) A fixed fee per order or per customer — e.g. 10 for €10. If set, Cost Reference – Fee (col V) must also be set, and Variable Cost – Percentage must be left blank.
Cost Reference – Fee (col V, optional) Which order type triggers the fee.
Option | Meaning |
Gross Orders | Fee applies per gross order |
Net Orders | Fee applies per net order (after returns) |
New Customers | Fee applies per new customer only |
Klar automatically calculates the total variable compensation based on actual orders and revenue, and adds it to the fixed costs so you always know the total payout per partnership.
Discount codes
Discount Codes (Comma Separated) (col W, optional) Enter all discount codes used in this partnership, comma-separated. Example: PAM10,PAM20,PAMVIP. An order is assigned to this partnership if any of the listed codes match.
Discount Code Type (col X, optional) The type of discount code (e.g. percentage off vs. fixed amount). Select from the dropdown.
Attribution control
Add Attribution Last Touch (col Y, optional — yes/no) This controls how Klar handles a common scenario: a customer places an order, the UTM parameters show they came from Facebook — but they used an influencer discount code. Do you want that order assigned to Facebook, or to Influencer Marketing?
Yes — Klar assigns the order to the influencer partnership, regardless of what the UTMs say
No (or blank) — the order follows UTM attribution logic
Set this to Yes if you want discount code usage to always count as an influencer conversion, even when the customer's last click came from a paid ad.
UTM parameters
Enter the UTM parameters used in the tracking links for this partnership. Each partnership should have unique UTMs so Klar can unambiguously match sessions.
Column | Parameter | Suggested value |
Z |
| Platform — e.g. |
AA |
|
|
AB |
| Campaign name |
AC |
| Influencer name (must be unique per partnership) |
AD |
| Advertised SKU or post format |
An order is attributed to a partnership if either the discount code OR the UTM parameters match — one is enough.
Featured SKU
Featured SKU (col AE, optional) The SKU of the product advertised in this partnership. Klar will then show what share of units sold through this partnership came from that specific product.
Custom dimensions
Custom Dimension 1–3 (cols AF–AH, optional) Free-text fields for anything specific to your business that you want to track. Every influencer program is different — use these for whatever dimensions matter to you. Examples: content format, product category, campaign tier, agency, geographic market.
Whatever you enter here becomes available as a dimension in the Influencer Flex Table. Use consistent values across rows so the grouping is useful (e.g. always Macro, Micro, Nano rather than variations like macro influencer, Macro, big creator).
The Status column
Status (col AJ — filled automatically by Klar) After each data sync, Klar writes the import result here for every row.
✅
Success @ [timestamp]— the row was imported successfully❌
[Field name]: [error description]— the row was rejected. Fix the error in that row and sync again.
Common errors include missing required fields (Influencer Name, Platform, Type of Partnership, Posting Date, Fixed Costs) and invalid date formats. Do not edit the Status column yourself — Klar writes to it automatically.
Syncing your data
Once your sheet is connected as a datasource in Klar:
Open the datasource in Store Configurator → Data Sources
Click Sync Data — this may take a few minutes
Check the Status column in the sheet to confirm rows imported correctly
Go to Store Settings → Update Store Data to rebuild your reports with the new data