SPIKE Can we easily read the Web Actions using Looker?

[LL782]

To understand our options for visibility on public visits and actions across all projects

Result

1. @anibe set up a Looker look at our Web Actions data stored in Big Query (see Investigate how to create view of web actions #30 (comment))

Notes

1. The look is limited because the data in Big Query is a string of JSON from the Firestore import
2. Tools exist for working around that but none have been immediately useful

Options

1. We could change the way we store the data in Big Query (e.g. when importing from Firebase)

Next steps

• See parent ticket: Investigate how to create view of web actions #30

[LL782]

Spike complete. See comment: #30 (comment)