Data Fusion: Google Cloud
Natalya Yefimenko avatar
Written by Natalya Yefimenko
Updated over a week ago

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

πŸ’° GCP is available by request. Contact your Affise account manager to get the feature.

Integration with Google Cloud

  1. To set up your own Google Cloud account, go to the website directly.
    ​

    You are to turn on API here to allow Affise to pass the data to Google Cloud:
    ​
    ​

  2. Fill in Google Cloud configuration settings to create integration between your account and Google Cloud:
    ​
    ​
    ​

    GoogleCloud.png


​

The configuration settings include two forms: Clicks and Conversions. You need to fill them to send raw data on all clicks and conversions.
​
You can see the following fields:

  • Frequency: indicate the interval of files sending to Google Cloud (in minutes).

  • Directory: the way in the Bucket your data will be sent to.

  • Bucket: the main folder the system sends your data to in the created Storage.

  • Credentials (JSON): the access data to the Storage in your Google Cloud.
    ​

To find it, do the following:

Step 1. Open Google Cloud console and go to Menu > IAM&Admin > Service Accounts:
​


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

⚠️ The account must have the "Owner" role. Otherwise, there's no possibility of streaming the data into the bucket.


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

You can choose certain affiliates and/or advertisers whose clicks and/or conversions the system sends to Google Cloud. It allows paying not for all conversions, but only for the needed ones.

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

  • Delete integration: turn on the slider to stop the sync on sending the data from Affise to Google Cloud. It's completely erased from the Affise side. All previously uploaded to Google Cloud files remain in their folders.

  • Click Save. After setting your account on the Google Cloud side, the system sends your data on clicks and conversions to be stored there.

Sending information on clicks and conversions

The system creates .CSV file, compresses it into .GZ file, and sends it to Google Cloud Storage. The .GZ format saves storage capacity. The system sends the file every 15 minutes by default.

The system starts the creation of a folder tree according to the current date of exporting process execution, and segments archives into the following folders: Year, Month, Day and the files are named according to the date {YYYY-MM-DD hh:mm:ss}.


Please contact the Affise Customer Support team regarding all raised questions via the e-mail: [email protected].

Did this answer your question?