A Looker Studio Dashboard to Visualize Kingfin Affiliate Revenue

Why should you "visualize" Kingfin revenue?

After running an affiliate operation for a while, there's a wall almost everyone hits at some point: "I get a decent amount of traffic, but the payouts aren't growing the way I'd like," or "It feels like things improved over last month, but I can't tell what actually worked." You're doing the work — writing articles, posting — yet you can't see "what to fix next." This is exactly the kind of plateau that catches intermediate and advanced affiliates.

The cause is usually that "the numbers are scattered across different places." Clicks live in GA4, sign-ups and payouts in the Kingfin dashboard, your own notes in a spreadsheet — and when they're split apart, it's hard to connect the whole flow in your head. As a result, you decide improvements by gut feel, and the misses pile up. The point of pulling everything onto one page in Looker Studio is to "re-arrange the scattered numbers in the order in which revenue is born."

Boil it down and the revenue flow is a single road: an article or post gets read → the referral link gets clicked → someone signs up with Kingfin → trading begins and a RevShare payout is generated. Once you can see where on that one road people are falling away, your moves narrow themselves down automatically. Few clicks? Work on traffic and the pitch. Plenty of clicks but few sign-ups? The path and the explanation around the link. Sign-ups but no payouts? The quality of who you're referring. Each symptom has a different prescription.

Kingfin already comes with a dashboard that lets you check your payout status in real time. Layer your site-side click and traffic data on top of that, and you can trace everything from "your own content" to "the actual payout" on a single page. In other words, what you do in Looker Studio is connect your own "causes" to the "results" Kingfin shows you.

Which metrics should you put on the dashboard?

The first thing to decide isn't "what to include" but "what to leave out." People new to visualization tend to line up every number they can think of and end up with a dashboard where they can't tell where to look. What belongs at the center are only the numbers that correspond to that one road above. Specifically:

Add the conversion rate between each pair of stages, and the dashboard instantly becomes a "diagnostic tool." If "click-to-sign-up rate" is low, the path or explanation toward the sign-up page is the issue; if "sign-up-to-payout rate" is low, the people you're referring aren't actually progressing to trading. Rates are easier to read than raw counts, and they let you feel improvement even while your scale is small.

If you want to look at the makeup of revenue, it's also good to display CPA and RevShare separately. CPA is a fixed reward per conversion (up to $250); RevShare is an ongoing reward that compounds the longer the people you referred keep trading. With Kingfin, the tiered rate starts around 20% and rises with your track record, reaching up to 80% with various bonuses combined. Viewing this "difference in how things accumulate" separately on the dashboard reveals the balance between short-term counts (CPA) and the medium-to-long-term asset (RevShare). That said, amounts vary with results and are not guaranteed. A dashboard is a mirror of "how things are right now," not a promise about the future — don't lose sight of that premise.

Don't get greedy. Keep it to one page at first

You don't need an elaborate multi-page report from the start. In fact, a dashboard you can keep up with should be fully visible on one page, one scroll. The four stages above, their conversion rates, and a period comparison (this week vs. last week) are plenty as the foundation of a weekly review. Decoration and fine-grained segments can be added once you're used to the routine.

Where does the data come from? (GA4, Kingfin, a spreadsheet)

The part of dashboard design where people get stuck most is organizing these data sources. Visualizing Kingfin affiliate revenue combines three sources of different natures. Each has a clearly distinct role, so understand that division of labor first.

The key is an asymmetry: the GA4 side tends to be automatic, while the Kingfin side tends to be manual. Because GA4 integrates with Looker Studio by default, clicks and traffic stay up to date almost without you touching them. Meanwhile, in typical affiliate environments there's often no mechanism to automatically feed Kingfin's payout data to external tools, so the solid approach in practice is to copy the numbers from the Kingfin dashboard into the spreadsheet once a week. It may feel like a chore, but the transcription itself becomes "time spent facing this week's results," so it's not wasted.

To measure "referral-link clicks" on the GA4 side, you need to be able to capture clicks on external links heading to Kingfin as events. The basics of GA4 enhanced measurement and event setup are covered in the related article GA4 for FX Affiliate Sites: A Beginner's Guide, so if your measurement foundation isn't ready yet, set that up first and this dashboard will work right out of the box.

What's the basic Looker Studio layout?

Once the roles of your data sources are clear, it's time for the actual screen. Looker Studio is an intuitive tool: you place charts and tables (components) on a canvas and assign each one "which number from which data source to show." No difficult programming required. For a Kingfin revenue dashboard, this clear ordering works well:

Just by letting your eyes fall from top to bottom, you read it as "the current result (scorecards) → where it leaked (funnel) → the trend over time (trend) → what worked (breakdown)." Placing a "date range control" at the top to switch the period (this week, last month, and so on) lets you change the range you're looking at on the spot — very handy.

How do you visualize RevShare accumulation?

The most "fun to watch" part of a Kingfin revenue dashboard is RevShare accumulation. CPA is a number suited to a bar chart — it pops up the moment a conversion happens — but RevShare is an ongoing reward that keeps coming in little by little as long as the people you referred keep trading. Drawing it as "accumulation" rather than "points" makes that nature obvious at a glance.

Concretely, it's effective to express the weekly RevShare amount as a stacked bar chart or a cumulative line. The single-week amount may feel small, but draw it cumulatively and an upward curve emerges — and that's exactly why RevShare is the "asset type." As referrals grow, the payouts from people you referred in the past pile up as a base, and new ones ride on top of them; the dashboard visualizes that structure (this describes the mechanism only; it does not guarantee any amount or continuity).

Kingfin payouts settle daily, and you can withdraw from a $10 minimum. Charting every tiny daily fluctuation gets hard to read, so on the dashboard it's practical to round to weekly or monthly and view the trend. The daily numbers are tempting to watch, but improvement decisions wobble over too short a window. "Get paid daily, reflect weekly" is the rhythm that fits Kingfin's mechanics. And when you're thinking about how to present payouts, keeping the difference and use cases of CPA versus RevShare in mind tightens the design.

What do you look at weekly to improve?

A dashboard isn't done once you build it — it only matters once you fold it into a routine you run the same way every week. The recommendation is to fix a once-a-week, 15–20-minute "revenue review" as a scheduled block. The steps can stay simple.

What matters here is to not try to fix many things each week. Change this and that, and you can't tell what worked, so even staring at the dashboard yields no learning. Quietly running "one hypothesis test per week" makes the accumulation half a year out far larger. The thinking in The 3 Numbers Every Affiliate Should Watch, which Kingfin Insights returns to repeatedly, helps narrow the axis of this review.

One more thing. The records from your weekly review get even stronger when tied to article- and project-level management. Keeping track of "which article led to sign-ups" makes the priority of your next topic clear. If you want to systematize article and project management, combining it with the Notion Template for Kingfin Affiliate Management turns the dashboard (numbers) and the management table (actions) into two wheels of the same cart.

What are the common pitfalls and cautions?

Finally, here are the points many people trip over when building a Kingfin revenue dashboard, along with how to avoid them. Knowing them up front cuts down on pointless detours.

One more practical caution: the handling of personal information and terms. Keep what you put on the dashboard to aggregated figures (click counts, sign-up counts, payout amounts, and the like), and don't handle anything that could identify the people you referred. Also, if you share or publish the dashboard with others, do so within the bounds of Kingfin's terms of service and its policy on handling payout data. In your content itself, complying with the Act against Unjustifiable Premiums and Misleading Representations (no hype advertising) and stealth-marketing regulations (clear ad disclosure) is a baseline.

Visualization is an investment that turns plain, steady improvement into a "system you can keep up." The initial build takes a little effort, but once it's done, your weekly reflection shifts from "vaguely" to "a move with a reason." If you've never seen your Kingfin results data, start by signing up free and looking at the numbers in the admin panel. Layer your site's clicks on top, and the foundation of a revenue dashboard that's all your own is complete.

Written by

Hiro Hiraki

Editor-in-Chief, Kingfin JP. An FX affiliate specialist with over 15 years of financial and FinTech translation experience. Bilingual in Japanese and English.