A Powerful Tool
The mapflo tool can pull in data from external sources in to a flow. The flow allows you do what you have been doing on a spreadsheet in a faster, flexible, automated way.
Versus a spreadsheet, the tool can handle more data, reduce errors and save hundreds of hours of your team’s time.
CREATE NEW SEGMENTATIONS TO HELP UNDERSTAND DATA
The Data Shaper node is a phenomenally powerful and easy to use way of categorizing or segmenting data.
For example, use it to group your search queries so you can see sessions and session growth at an aggregated level [If you ran the the Google Merchandise Store you can group all queries that contain “hoodie” + ‘Google’ or ‘Android’ or ‘YouTube’ for example.
You can create new mappings based on AND/OR rules, nulls, regex and more.
JOIN DATA SETS TOGETHER
You can Append data (merge two separate datasets with the same columns => more rows with same columns) or Join data from one dataset onto another based on matching one or more variables (=> same number of rows plus new columns with joined data).
So you can join spend data from Google Ads to Session Data from Google Analytics. Joined based on matching the date, source and campaign.
USE MATH OPERATIONS LIKE IN EXCEL
Use formulas to multiply, divide, add, subtract. Use Regex to extract Month from a Date. Turn numbers into date format.
FILTER AND ‘GROUP BY’ YOUR DATA
use the Filter node to filter for particular values or exclude nulls.
Use Group By to aggregate your data by particular dimension values (such as transform a dataset of daily marketing spend to monthly marketing spend).
CREATE CUSTOM VARIABLES
Create custom variables that can be used in formulas.
Define a variable called ‘Facebook Order uplift’ and assign a value of 1.5
use the variable in your flows in math and data shaper nodes but change the value centrally [so you can update assumptions universally across a flow].