The table data_score contains the search scores for each object batch.
Each line contains the observed search score (score_obs), the
seasonally adjusted search score (score_sad), and the trend only
search score (score_trd) for each keyword in an object
batch_o for a given location and date. The column
batch_c indicates the control batch that has been used as baseline
for mapping. Global data takes the value world as location. Search
scores are computed and automatically written to the table with the function
compute_score
. The function start_db
exports the table
data_score as database connection tbl_score
to
the package environment gt.env
. Users can access the database
table through dplyr::tbl
.
The sample data included in data_score
was simulated based on actual
Google Trends data.
Example data for the table data_score is available as R object
example_score
.
example_score
A tibble with 6,000 rows and 8 variables:
Column of type character
showing the ISO2 code of
the country or region for which the data was computed.
Column of type character
showing the keyword for
which the data was downloaded.
Column of type integer
showing the date for which the
data was computed Can be transformed into date format with
lubridate::as_date
.
Column of type double
showing search score for the
respective location-keyword-date combination - no time series adjustment.
Column of type double
showing the search score for
the respective location-keyword-date combination - seasonally adjusted time
series.
Column of type double
showing the search score for
the respective location-keyword-date combination - trend-only time series.
Column of type integer
showing the number of each
control batch.
Column of type integer
showing the number of each
object batch.
Column of type integer
showing whether the line will
be aggregated as synonym.
compute_score()
compute_voi()