Follow

Data Fusion: Google Cloud

Time to read: 6 min

topic.pngThe article covers the following topics:

Google Cloud Platform (GCP), offered by Google, is a suite of cloud computing services that runs on the same infrastructure that Google uses internally for its end-user products, such as Google Search and YouTube. Alongside a set of management tools, it provides a series of modular cloud services, including computing, data storage, data analytics, and machine learning.

How does it work?

  1. Set up your own Google Cloud account, visiting directly on the website.
    import.pngPlease, mind to turn on API here https://console.developers.google.com/apis/api/storage-api.googleapis.com/overview?project=<PROJECT_ID> for Affise to be able to pass the data to Google Cloud:
    2019-08-29_12-43-05.png
  2. Fill in Google Cloud configuration settings to create integration between your account and Google Cloud:
    Markup 2020-06-01 at 17.18.36.pngScreenshot on 2020-06-01 at 17-20-04.png

The configuration settings include 2 forms: Clicks and Conversions to be filled in for sending raw data on all clicks and conversions, respectively. 

Where:

  • Directory - the way in the Bucket your data will be sent to.
  • Bucket - the main folder your data will be sent to in the created Storage.
  • Credentials (JSON) - the access data to the Storage in your Google Cloud.
    There is a small hint on how to find it:

Step 1. Open Google Cloud console and navigate in 'Menu' - > 'IAM&Admin' - > 'Service Accounts'

Screenshot_120.png

Step 2. On the 'Service accounts' page, select a service account for the needed project and take a Key ID under 'Key ID' column or, if this column is empty, you can create a new key ID. To do this, click 'Actions' - > 'Create key' - > 'JSON' - > 'Create':

chrome-capture__58_.gif

import.pngPlease, mind the account should have the "Owner" role; otherwise, there's no possibility to stream the data into the bucket. 

Step 3. Put Key ID into the 'Credentials' field on the plugin page in Affise:

Markup 2020-06-01 at 17.21.54.png

On the plugin page, you can see some additional actions:

  • Delete integration - upon turning on the slider, the sync on sending the data from Affise to Google Cloud is stopped, and it's completely erased from the Affise side, though all previously uploaded to Google Cloud files will remain at their folders.
  • Tap on the Save button. As soon as your account is set up on Google Cloud side, your data on clicks and conversions will be sent to be stored there.

How does the system send information on clicks and conversions?

The system creates .csv file, then compresses it into .gz file and sends it to Google Cloud Storage. Format .gz will save storage capacity. The file is sent every 15 minutes.

The system initiates the creation of a folder tree according to the current date of exporting process execution and segment archives into the following folders: Year, Month, Day and the files are named according to the date  {YYYY-MM-DD-hh-mm}, so it is pretty easy to naviage them.

Should you have any further doubts or questions on the Google Cloud plugin work, feel free to contact the Google Cloud support team.

Updated by Lizaveta Talkachova

 

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.