***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The Problem A client needed to automate his business operations – mainly his lead management workflow. The client has recently started using Pipedrive to manage influx of leads from their site. The problem was that client’s […]
Google Ads Keyword Planner Data to Google Sheets
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** I’ve always wanted to be able to easily get Google Ads Keyword Planner data to Google Sheets. The best case scenario was to provide inputs in a Google Sheet and then have “some magic” download the […]
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 Marketing Data to Snowflake
Advanced advertisers and analysts may find themselves in a situation where working with marketing data in Google Sheets or Excel or Google Data Studio is simply not good enough because: They need to do complex transformations of the raw data. They need to enrich the raw data with internal data sources. They need to “own […]