Jak Stáhnout Sklik Data do BigQuery

***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** Pro Sklik existuje řada skriptů (především od Standy Jílka), které umožňují stahovat data z Skliku do Google Sheetů. Nebudu tedy nosit dříví do lesa a raději zkusím stáhnout data o výkonu kampaní z Skliku rovnou do […]

Dealing with Cookie Apocalypse: Data ETL and Performance Reporting

***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The ongoing advertising cookie sunset poses serious challenges to reporting your campaign results. If your site does not use any sneaky cookie consent designs, you can expect to lose around 60-90% of advertising cookies. This means […]

Make/Integromat in the BI World: Will It Work?

***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** I’ve always wondered whether you can use Integromat for making your life easier in the BI/analytics world where I am partially coming from. As I’ve been becoming more familiar with Integromat ecosystem I can say “yes“. […]

Make/Integromat Case Study: How Integromat Replaced 75% of Coding

***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The Problem A client from health care vertical is running an HHAE instance which is a service which allows the client to manage caregivers and patients on scale. I’m talking about thousands of patient and caregivers. […]

Make/Integromat Case Study: Nahrávání příloh k dodavatelským smlouvám v Abra Flexibee

***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** Problém Klient používající Abra Flexibee mě oslovil, zda bych byl schopen vyřešit následující problém: Bylo třeba začít monitorovat složku na Google Drivu. Do složky si klient ukládá přílohy k dodavatelským smlouvám. Nové přílohy je třeba automaticky […]

Make/Integromat Case Study: Getting Zoom Meetings Duration from Pipedrive Notes and Sending the Info to Google Sheets

***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The Problem A client is running Pipedrive CRM + CloudTalk + Zoom + Google Sheets combo: Salespeople are making calls via CloudTalk – all the info is automatically logged into Pipedrive, including duration of the calls. […]

Make/Integromat Case Study: Getting Traffic Source Info from CallRail into Pipedrive CRM

***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The Problem A client is running Pipedrive CRM + JustCall + CallRail combo: Leads are captured in Pipedrive. As soon as a call from an unknown number comes, a “deal” is automatically created in Pipedrive thanks […]

How to Get Google Ads Data to Google Data Studio along with Other Data Sources

Okay, this may sound like yet another useless article about getting Google Ads data into Google Data Studio. Most of the marketing community knows that Google itself provides a free Google Data Studio connector for Google Ads which will get you going in minutes. This is the connector: You just select the connector, then select […]