When developing a behavior change intervention, it is first necessary to obtain a comprehensive in-depth understanding of the problem. For example, the Intervention Mapping protocol dedicated the first step, the Needs Assessment, to this endeavour. In this phase, maintaining an overview can be challenging, as all the myraid aspects of reality that are, or may be, relevant are collected and related to each other.
COMPLECS1 was developed to help to keep an overview during this process. It allows adding new information in a piece-wise manner, and then combines everything into one visualisation.
COMPLECS reads the specifications from a spreadsheet. This spreadsheet can be provided either as an URL to Google Sheets (useful if you want to collaborate wiht multiple people) or as the path to an Excel file.
The spreadsheet workbook should contain four worksheets. The default names2 of these worksheets and columns in those worksheets are as follows.
entities worksheet, you specify the entities you identified. These become the nodes in the visualisations. Entities can be people such as a member of the at-risk population, the target population, or another relevant actor; they can be more abstract entities such as school boards, hospital management, or politicians; they can be environmental conditions, such as the presence of free condoms or drug testing services; or they can be behaviors, such as bullying or providing social support. In fact, entities can be anything that you think is useful to include in the overview; there are really no limitations except what works for you. This flexibility is possible because entities have types, which are specified in another worksheet. When specifying an entity, you have to specify a unique identifier (in column
entity_id), a human-readable label (in
entity_label), and an entity type (
connections worksheet, you specify how the entities relate to each other. By default, you can use the relationship types specified in West et al. (2019, doi:10.1038/s41562-019-0561-2), such as
causal_influences_unspecified for causal effects where it is unknown whether the effects are positive or negative;
causal_influences_positive for positive causal effects;
causal_influences_negative for negative causal effects; and
causal_influences_unknown if it is unknown whether there is a causal effect. When specifying a connection, you have to specify the entity from which the connection originates (
from_entity_id), the entity to which that entity connects (
to_entity_id), and the connection type (
entity_types worksheet, you specify the possible entity types. By default, the following types are prespecified:
determinant. You can add more types here by specifying their type identifier (in column
entity_type_id) and their human-readable label (in
entity_type_label), as well as how you want it to look in the COMPLECS overview by specifying the stroke color (
color), the shape (
shape), the fill color (
fillcolor), the style (
style), and the text color (
connection_types worksheet, you specify the possible connection types. By default, all connection types listed in West et al. (2019, doi:10.1038/s41562-019-0561-2) have been prespecified. You can add more connection types here by specifying their connection type identifier (in column
connection_type_id) and their human-readable label (in
connection_type_label), as well as how you want the connection to look in teh COMPLECS overview by specifying the stroke color (
color), the style (
style), and the direction of the arrow (
If you want to use a Google Sheet, make sure you make it public in two ways (it has to be public in both ways for the R
googlesheets package to be able to read the information):
Once you specified everyting, you can generate the overview. To do this, you can use the
complecs function in the
behaviorchange package (this function’s manual page is located here). The function only requires one argument: the URL to a Google Sheet, or the path to an Excel file. If you use the function like this, the produced COMPLECS overview will simply be shown. However, you will usually want to save the overview to a file. To do that, you can use
outputFile to specify a path and filename of a file you want to write to.
As an example, let us use the default COMPLECS specification template located at https://docs.google.com/spreadsheets/d/1WMO15xroy4a0RfpuZ8GhT-NfDoxwS34w9PrWp8rGjjk. Let’s first store that long URL in a convenient variable:
googleSheetsURL <- "https://docs.google.com/spreadsheets/d/1WMO15xroy4a0RfpuZ8GhT-NfDoxwS34w9PrWp8rGjjk";
You can produce a COMPLECS overview by simply passing that URL to the
If you want to save the resulting COMPLECS overview to a file, you also specify a path and filename: