If you store your business data is in BigQuery, Sellforte can fetch it programmatically to use it in Marketing Mix Modeling. For the programmatic fetch, A JSON credential file is required. By following the steps below, you can create the file.
1) Go to Service Account management
In Google Cloud platform, open the menu in the left-hand side. Locate "IAM & Admin" section in the menu. Under the "IAM & Admin", choose "Service Accounts".
2) Create a new Service Account
In the Service account management, click "Create Service Account".
Give a name for the service account, for example bigquery-sellforte. The name is replicated as your Service account ID. Add the description if you like. Click "Create and Continue".
3) Grant access
In the "Select a role" dropdown, choose "BigQuery". Then choose "BigQuery Job User" as a role.
You don't need to make changes in the "Grant users access to this service account (optional)" step. Instead, click "Done".
4) Manage Keys of your project
In the Service Account management, locate the account you just created. Click three dots on the right hand side, and click "Manage keys".
Click "Add key" and then "Create new key".
Choose "JSON" as a Key type. Click "Create".
5) Deliver JSON file safely to the recipient
When you click "Create" JSON file is automatically saved to your computer. Deliver this file securely to your Sellforte Point of Contact.