Connect Commission Factory to Looker Studio in Minutes

Directly connect Commission Factory to Looker Studio in an easy-to-use format

commission factory google data studio integration

Analyze Your Metrics from Commission Factory in GDS

About the Commission Factory Google Data Studio Connector

The Commission Factory Google Data Studio Connector pulls metrics and dimensions for Commission Factory. The Insights are retrieved at the campaign and ad levels.

Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.

Prerequisites

To set up the connector, the user should have:

How to connect Commission Factory to Google Data Studio in 2023?

Do you plan to connect and visualize your Commission Factory in Looker Studio? Follow the Tutorial Below:

Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend.select fields on the right

Go to “Select Destination” and choose Looker Studio.

select looker studio

Once done, select “connect” and authorize access to your data source.

ad crm data studio integration

Commission Factory metrics & dimensions available for streaming into Google Data Studio

nametypedescription
Account IDTEXTAccount ID.
Account nameTEXTAccount name.
AffiliateBusinessNameTEXTThe business name of the affiliate that generated the click or transaction.
AffiliateContactNameTEXTThe contact name of the affiliate that generated the click or transaction.
AffiliateIdTEXTThe ID of the affiliate that generated the click or transaction.
ClicksBotNUMERICThe number of clicks that were from known bots.
ClicksTotalNUMERICThe total number of clicks.
CommissionApprovedNUMERICThe total commission amount of approved transactions.
CommissionPendingNUMERICThe total commission amount of pending transactions.
CommissionVoidNUMERICThe total commission amount of void transactions.
Data SourceTEXTThe name of the Windsor connector returning the row
DateDATEThe date of the click or transaction.
Day of monthTEXTDay of the month
ImpressionsBotNUMERICThe number of impressions that were from known bots.
ImpressionsTotalNUMERICThe total number of impressions.
MonthTEXTNumber of the month
OverrideApprovedNUMERICThe total override fees of approved transactions.
OverridePendingNUMERICThe total override fees of pending transactions.
OverrideVoidNUMERICThe total override fees of void transactions.
SaleValueApprovedNUMERICThe total sale value of approved transactions.
SaleValuePendingNUMERICThe total sale value of pending transactions.
SaleValueVoidNUMERICThe total sale value of void transactions.
SourceTEXTThe name of the Windsor connector returning the row
TodayDATEToday's date
TransactionsApprovedNUMERICThe number of approved transactions.
TransactionsPendingNUMERICThe number of pending transactions.
TransactionsVoidNUMERICThe number of void transactions.
WeekTEXTWeek (Sun-Sat).
Day of week and day numberTEXTWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
Day of week and day number, ISOTEXTWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
Week ISOTEXTWeek, ISO format (Mon-Sun).
YearTEXTYear
YearmonthTEXTYear and month, e.g. 2024|3
Year of weekTEXTThe year that contains first day of the week (Sun-Sat).
Year of week, ISOTEXTThe year that contains first day of the ISO week (Mon-Sun).
Year weekTEXTYear and week for US weeks (Sun-Sat), e.g. 2024|15
Year week ISOTEXTYear and week for ISO weeks (Mon-Sun), e.g. 2024|20

Easily connect Commission Factory to Google Data Studio

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Commission Factory and GDS Integrations