Use Google Analytics add-on to get data in Geckoboard


If your Adwords and Adsense accounts are linked to Google Analytics, you can use this method to receive data from these services (and Google Analytics) into Google Sheets and from there to Geckoboard. See Linking Analytics and Adsence and Linking Analytics and Adwords for more info.

We have pre-built integrations with Google Analytics, Adwords and Adsense. However, it's possible that you need to display very specific data that is not yet supported by these integrations or that you want to aggregate data before displaying it on your dashboard.

Conveniently, the team at Google have built a handy tool to pull Google Analytics, Adwords and Adsense data straight into Google Sheets, where you can manipulate it to your heart’s content in the familiar surroundings of a spreadsheet. This approach can also be used to manipulate the data or create combinational metrics using data from these sources before pulling it into your Geckoboard via our Spreadsheets integration.

Install the add-on

Simply go to this link: Then install the add-on by hitting the blue +FREE button in the top right-hand corner. This will then install the add-on and ask you to connect your Google Analytics account before opening a new Google Sheet for you to get started.  

Create a new report

Once you’ve installed the add-on and the Google Sheet has opened, hit Add-ons > Google Analytics > Create new report to get started.Create a new report

From this basic setup screen you specify the account, property and view that you want to pull data from. You can then select the metrics you’re interested in, and any dimensions that you’d like them broken down by.


It's from the Metrics and Dimensions menu that you can choose data from Adsense and AdwordsAdwords

Further reading

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.