What will we do in this course?

What will we do in this course?

The whole cost import consists of 3 phases.

Phase 1:

Download the cost data to Google Sheets. You can use Supermetrics, Dataslayer, Zapier, or other tools. We recommend using the Google Apps script, which connects directly to the API of Facebook, TikTok, etc. In the following chapters, we will provide a link to our Apps script.

Phase 2:

Create your virtual SFTP server and upload the cost data to it. You must have a server to make the automated cost import work. You will find a detailed guide on how to set up your server and upload your cost data to it.

Phase 3:

Uploading data from SFTP to GA4. When you have all your cost data on your SFTP server, you must connect it with GA4 to automatically make the uploads.

GA4 Cost Import EN

Buy nowLearn more

0. Before you start

  • What is GA4 cost import?
  • What will we do in this course?
  • Technology stack and costs
  • Clean up your UTMs

1. Exporting cost data to Google Sheets

  • Overview
  • Google Apps script for cost import
  • Create your config spreadsheet
  • Copy the Google Apps Script
  • Create your Google Sheet for cost data
  • Run the script

2. Uploading cost data to SFTP server

  • Overview
  • Create an account on Bluehost
  • Create an SFTP account
  • Create a Keboola account
  • Create data source in Keboola
  • Create data destination in Keboola
  • Create a Keboola flow

3. Import cost data to GA4

  • Overview
  • Create a data import in GA4
  • Import public key to SFTP server
  • Run the cost import manually (optional)
  • Check the quality of imported data