Connect Basis to Google Looker Studio
Directly connect Basis to Looker Studio, in minutes, and in an easy-to-use format.
Analyze Your Marketing Metrics from Basis in GDS
About Basis
About Google Looker Studio
About the Basis Google Looker Studio Connector
The Basis Google Looker Studio Connector pulls metrics and dimensions for Basis. The Insights are retrieved at the campaign and account 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:
- A Basis advertiser account (Visit our privacy policy and terms of use)
- Google account for Basis to Google Looker Studio integration.
- A Windsor account. Start your free trial now.
How to connect Basis to Google Looker Studio?
Do you plan to connect and visualize your Basis in Google Looker Studio? Follow the Tutorial Below:
You need to select Basis as a Data Source and grant access to Windsor.ai. 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. Go to “Select Destination” and choose Google Looker Studio. Once done, select “connect” and authorize access to your data source.
Basis metrics & dimensions available for streaming into Looker Studio
name type description Advertiser Spend NUMERIC Total advertiser spend for the campaign group or campaign. Auctions Bid NUMERIC Number of auctions that the campaign bid on. Auctions Won NUMERIC The number of auctions the campaign won. Brand Archived BOOLEAN Indicates if the brand is archived. Brand ID TEXT A unique brand ID is automatically assigned when you create a brand. Brand Landing Page Domain TEXT The landing page domain is the domain name of the advertiser's website. Brand Name TEXT The name of the brand, up to 255 characters long. Brand Notes TEXT Optional notes about the brand. Campaign TEXT The Campaign Name Campaign Group ID TEXT A unique group ID is automatically assigned when you create a group. Campaign Group Name TEXT The name of the group. Campaign Group Notes TEXT A descriptive string for the group Campaign ID TEXT A unique campaign ID is automatically assigned when you create a campaign. Campaign Name TEXT The name of the campaign. Campaign Notes TEXT Notes about the campaign. Campaign Status TEXT The campaign's status. Valid Values: online, offline, archived Click Cvr NUMERIC conversions/impressionsWon Click Effective CPA NUMERIC Cost per click-through conversion: totalSpend/clickthruConversions Click RPM NUMERIC ctcRevenue/(impressionsWon/1000) Clicks NUMERIC The number of advertisement clicks. Clickthru Conversions NUMERIC The number of click-through conversions. Clickthru Rate NUMERIC Click-through rate (CTR): clicks/impressionsWon Companion Clicks NUMERIC The number of clicks that were recorded for companion ads. See Companion Ads for details. Companion Conversions NUMERIC The number of conversions that were recorded for companion ads. See Companion Ads for details. Companion Impressions NUMERIC The number of impressions that were recorded for companion ads. See Companion Ads for details. Companion Offer Revenue NUMERIC Revenue from companion ad click-through conversions. CTC Revenue NUMERIC Click-through revenue: revenue associated with click-through conversions. Data Effective CPM NUMERIC Effective Cost Per Mille (CPM) for demographic data: dataSpend/(impressionsWon/1000) Data Spend NUMERIC The amount that the campaign spent on demographic data. Date DATE The Date Effective CPA On Advertiser Spend NUMERIC The advertiser spend effective cost per conversion, the average cost to the advertiser for each conversion. Effective CPC On Advertiser Spend NUMERIC The advertiser spend effective cost per click, the average cost to the advertiser for each click. Effective CPCV On Advertiser Spend NUMERIC The advertiser spend cost per completed view (video). Calculated for video impressions only. Effective CPM NUMERIC Effective Cost Per Mille (CPM), the average cost per 1000 impressions: totalSpend/(auctionsWon/1000) Effective CPM On Advertiser Spend NUMERIC The advertiser spend effective cost per mille, the average cost to the advertiser for 1000 impressions. Eligible Impressions NUMERIC The number of impressions on which the DSP enabled viewability measurements. Gross Total Effective CPA NUMERIC Gross total cost per acquisition: (totalSpend+nonBillableSpend)/(clickthruConversions+ viewthruConversions) Gross Total Effective CPC NUMERIC Gross total effective cost per click: (totalSpend+nonBillableSpend)/clicks Gross Total Effective CPCV NUMERIC Gross total effective cost per completed view: (totalSpend+nonBillableSpend)/ campaignStats.getVideoCompleted() Gross Total Effective CPM NUMERIC Gross total effective cost per mille: ((totalSpend+nonBillableSpend) / campaignStats.getImpressionsWon())*1000.0 Impressions Won NUMERIC Number of impressions that the campaign won. This value will be the same as auctionsWon except in cases where an auction might result in multiple impressions, such as digital out-of-home (DOOH). Margin On Advertiser Spend NUMERIC Your margin on advertiser spend. Measured Impressions NUMERIC The number of impressions, out of the eligible impressions, on which the viewability was able to successfully determined. This includes all viewable impressions and all impressions that were determined to be not viewable. Measured Rate NUMERIC measuredImpressions/eligibleImpressions Media Spend NUMERIC The amount that the campaign spent on auctions. Offer Clicks NUMERIC The number of offer (also known as secondary) clicks. Offer Clickthru Rate NUMERIC Click-through rate (CTR) for offer clicks: offerClicks/impressionsWon Primary Click Effective CPA NUMERIC Cost per primary click-through conversion: totalSpend/primaryClickthruConversions Primary Clickthru Conversions NUMERIC Primary click-through conversions: primary conversions recorded after a user clicked an ad in the campaign. Primary Cost Per Acquisition NUMERIC Cost per primary conversion: totalSpend/totalPrimaryConversions Primary Effective CPA On Advertiser Spend NUMERIC Advertiser spend cost per primary click-through conversion: (advertiserSpend)/primaryClickthruConversions Primary Viewthru Conversions NUMERIC Primary view-through conversions: primary conversions recorded after a user saw an ad from the campaign but did not click through. Return On Ad Spend NUMERIC (ctcRevenue+vtcRevenue)/(totalSpend) Revenue NUMERIC Revenue associated with all conversions: ctcRevenue+vtcRevenue Revenue Per Mille NUMERIC Revenue per 1000 impressions (RPM): (ctcRevenue+vtcRevenue)/{impressionsWon/1000) Total Conversions NUMERIC All click-through and view-through conversions added together. Total CVR NUMERIC (conversions+viewthruConversions)/(auctionsWon/1000) Total Effective CPA NUMERIC Effective cost per acquisition (eCPA): totalSpend/clickthruConversions + viewthruConversions Total Effective CPC NUMERIC Cost per click (eCPC): totalSpend/clicks Total Effective CPCV NUMERIC Total effective cost per completed view (video only): totalSpend/videoCompleted Total Effective CPM NUMERIC Total effective Cost Per Mille (CPM), equal to: effectiveCPM+dataEffectiveCPM Total Primary Conversions NUMERIC Primary conversions: All primary click-through and primary view-through conversions added together: primaryClickthruConversions+ primaryViewthruConversions Total Spend NUMERIC Total amount that the campaign spent, equal to: auctionsSpend+dataSpend Video Completed NUMERIC The number of completed video plays. Video Completion Rate NUMERIC videoCompleted/videoStarted Video First Quartile Reached NUMERIC The number of video plays through the first 25%. Video Midpoint Reached NUMERIC The number of video plays through the first 50%. Video Skipped NUMERIC The number of videos that were skipped after starting. Video Skipped Rate NUMERIC videoSkipped/videoStarted Video Started NUMERIC The number of video starts. Video Third Quartile Reached NUMERIC The number of video plays through the first 75%. View Cvr NUMERIC viewthruConversions/impressionsWon View Effective CPA NUMERIC Cost per view-through conversion: totalSpend/viewthruConversions Viewability Spend NUMERIC The spend on viewable impressions. Viewable Impressions (Basis DSP) NUMERIC The number of impressions that were viewable. Viewable Rate NUMERIC viewableImpressions/measuredImpressions Viewthru Conversions NUMERIC The number of view-through conversions. VTC Revenue NUMERIC View-through revenue: revenue associated with view-through conversions Win Rate NUMERIC auctionsWon/auctionsBid Today DATE Today's date
Easily connect Basis to Looker Studio
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.