Commission Factory Looker Studio connector by Windsor.ai

The connector pulls metrics and dimensions from Commission Factory. The insights are retrieved at affiliate and account level.

Once user successfully logs into the connector its possible to choose the metrics and dimensions to create a report on.

The user should have a Commission Factory API key in order to use this connector.

Commission Factory Looker Studio Templates

Available Metrics and Dimensions

Name	Type	Description
Account ID	TEXT	Account ID.
Account name	TEXT	Account name.
AffiliateBusinessName	TEXT	The business name of the affiliate that generated the click or transaction.
AffiliateContactName	TEXT	The contact name of the affiliate that generated the click or transaction.
AffiliateId	TEXT	The ID of the affiliate that generated the click or transaction.
ClicksBot	NUMERIC	The number of clicks that were from known bots.
ClicksTotal	NUMERIC	The total number of clicks.
CommissionApproved	NUMERIC	The total commission amount of approved transactions.
CommissionPending	NUMERIC	The total commission amount of pending transactions.
CommissionVoid	NUMERIC	The total commission amount of void transactions.
Date	DATE	The date of the click or transaction.
ImpressionsBot	NUMERIC	The number of impressions that were from known bots.
ImpressionsTotal	NUMERIC	The total number of impressions.
OverrideApproved	NUMERIC	The total override fees of approved transactions.
OverridePending	NUMERIC	The total override fees of pending transactions.
OverrideVoid	NUMERIC	The total override fees of void transactions.
SaleValueApproved	NUMERIC	The total sale value of approved transactions.
SaleValuePending	NUMERIC	The total sale value of pending transactions.
SaleValueVoid	NUMERIC	The total sale value of void transactions.
TransactionsApproved	NUMERIC	The number of approved transactions.
TransactionsPending	NUMERIC	The number of pending transactions.
TransactionsVoid	NUMERIC	The number of void transactions.