Connect Awin to Google Data Studio with Windsor.ai

Directly connect Awin to Google Data Studio, in minutes, and in an easy-to-use format.

data integration

All your marketing data in one place, just in a few clicks.

In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.

Automate and save time.

No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.
Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!
Data Automation
data warehouse

Use all your data where and when you need it.

We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).

About Awin

Awin is an affiliate marketing network which is a type of performance-based marketing in which a business rewards one or more affiliates for each visitor or customer brought by the affiliate’s own marketing efforts. Awin operates globally and helps advertisers and publishers to connect and collaborate effectively. The company provides a range of tools and services to support the affiliate marketing process, including tracking, reporting, and payment. Awin’s global affiliate network is powered by 17 offices worldwide, over 1,200 employees, 241,000 contributing publishers, and 21,200 advertisers.

 

Learn more about Awin

About Google Data Studio

Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.

 

Learn more about Google Data Studio

Why integrate Awin with Google Data Studio?

  • Google Data Studio provides a wide range of customizable charts, graphs, and other visualizations to help you better understand your Awin data. You can also customize the layout and design of the reports to match your brand identity.

 

  • Using Google Data Studio, you can create custom reports that focus on the most relevant data for your business. For example, as a publisher, you can see which pages generate the most revenue, and as an advertiser, you can identify which publishers are driving the most traffic to your website.

 

  • Google Data Studio allows you to share your reports with others in your organization or with third parties which makes it easier to collaborate on your affiliate marketing strategies and track progress.

 

  • Integrating Awin with Google Data Studio can help you gain a deeper understanding of your affiliate marketing data and make more informed decisions about your marketing efforts

About the Awin Google Data Studio Connector

The Awin Google Data Studio Connector pulls Metrics and Dimensions for Awin. 

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 Awin to Google Data Studio?

Select the fields on the right to later use in your data source. For example, you can include metrics such as Commission Amount, Bonus Transactions, or Impressions.

select fields on the right

Go to “Select Destination” and choose Google Data Studio.

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

Windsor.ai Awin Google Data Studio Connector

Windsor.ai: All your marketing data in one place

Power up your marketing performance with result-driven marketing solutions

  • Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
  • The setup is done in minutes. No coding is required.
  • Currently, we support more than 3000 dimensions and metrics.
  • See the value and return on every marketing touchpoint.
  • Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.

Google Data Studio Templates for Awin

Do you plan to connect and visualize your Awin in Google Data Studio? 

These free and customizable Google Data Studio Studio Awin templates will assist you in visualizing your data for easy reporting and analysis.

Google Data Studio Tutorials for Awin

Would you like to take your Google Data Studio Awin dashboards to the next level? 

Here are some of our favorite tutorials to help you:

Available Awin Metrics and Dimensions

nametypedescription
Ad Network ConversionsNUMERICThe Ad Network Reported Conversions
Awin RevenueNUMERICAwin Revenue
Advertiser CostNUMERICAdvertiser cost
Advertiser Cost CurrencyTEXTAdvertiser cost currency
Advertiser CountryTEXTAdvertiser country
Advertiser IDTEXTThe Advertiser ID
Advertiser NameTEXTThe Advertiser Name
Amend ReasonTEXTTransaction amendment reason
AmendedTEXTWhether the transaction was amended
Basket ProductsTEXTBasket products
Bonus CommissionNUMERICThe Commission of Bonus Transactions
Bonus Transaction RevenueNUMERICThe Value of Bonus Transactions
Bonus TransactionsNUMERICThe Number of Bonus Transactions
CampaignTEXTThe Name of the Publisher (Duplicate)
Click DateDATEClick date
Click DeviceTEXTClick device
ClicksNUMERICThe Number of Clicks
CodeTEXTCode
Commission AmountNUMERICCommission amount
Commission CurrencyTEXTCommission currency
Commission Sharing Publisher IdTEXTCommission sharing publisher Id
Commission StatusTEXTCommission status
Confirmed CommissionNUMERICThe Commission of the Confirmed Transactions
Confirmed RevenueNUMERICThe Total Value of Confirmed Transactions
Confirmed TransactionsNUMERICThe Total Number of Confirmed Transactions
CurrencyTEXTThe Currency
Customer AcquisitionTEXTCustomer acquisition
Customer CountryTEXTCustomer country
DateDATEThe Date
Decline ReasonTEXTDecline reason
Declined CommissionNUMERICThe Commission of Declined Transactions
Declined RevenueNUMERICThe Value of Declined Transactions
Declined TransactionsNUMERICThe Number of Declined Transactions
ImpressionsNUMERICThe Number of Impressions
Lapse TimeNUMERICLapse Time
Network FeeNUMERICNetwork fee
Network Fee CurrencyTEXTNetwork fee currency
Old Commission AmountNUMERICOld commission amount
Old Sale AmountNUMERICOld sale amount
Order ReferenceTEXTOrder reference
Original Sale AmountNUMERICOriginal sale amount
TEXTPaid to publisher
Payment IdTEXTPayment Id
Pending CommissionNUMERICThe Commissions of Pending Transactions
Pending Transaction RevenueNUMERICThe Value of Pending Transactions
Pending TransactionsNUMERICThe Number of Pending Transactions
Publisher URLTEXTClick device
Publisher IDTEXTThe ID of the Publisher
Publisher NameTEXTThe Name of the Publisher
RegionTEXTThe Region
Sale AmountNUMERICTransaction sale amount
Sale CurrencyTEXTSale currency
Site NameTEXTsite Name
Transaction CommissionNUMERICThe same as Transaction Commission
Publisher TagsOBJECTThe publisher tags
Transaction Commission (Duplicate)NUMERICThe Total Commission of all Transactions
Total CostNUMERICThe same as Transaction Commission
Tracked CurrencyTEXTTracked currency amount
Tracked Currency AmountNUMERICTracked currency amount
Transaction DateDATETransaction date
Transaction DeviceTEXTTransaction device
Transaction IdTEXTTransaction id
Transaction Parts ListTEXTList of the transaction parts
Transaction Query IdTEXTTransaction query Id
Transaction TypeTEXTTransaction date
Transaction URLTEXTTransaction URL
Transaction CommissionNUMERICThe Total Commission of all Transactions
Transaction RevenueNUMERICThe Total Value of all Transactions
TransactionsNUMERICThe Total Number of Transactions
TypeTEXTThe Region (duplicate)
Voucher CodeTEXTCode of the voucher used
Voucher Code UsedTEXTWhether a voucher code was used