$req = $analytics->new_request( realtime => "true", ids => "ga:12345678", dimensions =>"rt:country,rt:city,rt:pagePath, rt:latitude, rt:longitude", metrics =>"rt:activeUsers", filters =>"rt:country==England", ); #### select * from query_builder where query_no = 14; #### Record 1 realtime => "true", Record 2 ids => "ga:12345678", Record 3 dimensions =>"rt:country,rt:city,rt:pagePath,rt:latitude,rt:longitude", Record 4 metrics =>"rt:activeUsers", Record 5 filters =>"rt:country==England", #### realtime => "true", ids => "ga:12345678", dimensions =>"rt:country,rt:city,rt:pagePath,rt:latitude,rt:longitude", metrics =>"rt:activeUsers", filters =>"rt:country==England", #### $qry_str = 'realtime => "true", ids => "ga:12345678", dimensions =>"rt:country,rt:city,rt:pagePath,rt:latitude,rt:longitude", metrics =>"rt:activeUsers", filters =>"rt:country==England",'; #### while ( @row = $sth->fetchrow_array() ) { $qry_str .= $row[0]; } #### $req = $analytics->new_request( $qry_str );