# Store data in database from GA API

**URL:** <https://www.ruby-forum.com/t/store-data-in-database-from-ga-api/183678>\
**Category:** Rails\
**Created:** [February 18, 2010, 5:19pm UTC](https://www.ruby-forum.com/t/store-data-in-database-from-ga-api/183678 "2010-02-18T17:19:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![remco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/9d8465/32.png) [@remco](https://www.ruby-forum.com/u/remco)\
**Post date:** [February 18, 2010, 5:19pm UTC](https://www.ruby-forum.com/t/store-data-in-database-from-ga-api/183678/1 "2010-02-18T17:19:15Z")

</div>

Hi,

I use the gem gattica to acces our unique visitor data. This works fine  
in my console.

require ‘rubygems’  
require ‘gattica’

gs = Gattica.new({:email =\> ‘XXXX’, :password =\> ‘XXXXX’})  
accounts = gs.accounts  
gs.profile\_id = XXXXXX

results = gs.get({ :start\_date =\> ‘2010-02-17’, :end\_date =\>  
‘2010-02-17’, :dimensions =\> ‘day’, :metrics =\> ‘visitors’})

output1:

{“start\_date”=\>Wed, 17 Feb 2010, “end\_date”=\>Wed, 17 Feb 2010,  
“points”=\>[{“title”=\>“ga:day=17”, “dimensions”=\>[{:day=\>“17”}],  
“id”=\>“[Google Marketing Platform - Unified Advertising and Analytics](http://www.google.com/analytics/feeds/data?ids=ga:21180637&amp;ga:day=17&amp;start-date=2010-02-17&amp;end-date=2010-02-17)”,  
“metrics”=\>[{:visitors=\>4088}], “updated”=\>Tue, 16 Feb 2010 16:00:00  
-0800}], “items\_per\_page”=\>1, “total\_results”=\>1, “start\_index”=\>1}

output 2:  
results.to\_csv(:short)

“day,visitors\n17,4088\n”

I want to check the Google Analyticsc API with a frequency of 4 hours  
and store the value of visitors (4088) in my database. How do i  
realize this?

Grtz…remco