select *
Updates

New Facebook Ads integration, merge columns with a separator and sort multiple columns

Published on
April 19, 2021
New

Facebook Ads integration

Running Facebook ads and trying to analyze your spent and best performing channels? We got you. Our latest updates allow Intersect to connect to your Ad Account and provide up to 23 columns for you to analyze for each of your campaign levels, across different time periods.

You only need to connect your Facebook and Ad account, and pulling data is done in just a couple of minutes. Check our official documentation for step-by-step instructions.

A preview of the Facebook block in Intersect
New

Merge multiple columns with a separator

In cases where you have separate columns with values that need to be mixed into one, you can use the merge multiple columns block. You can set a special character like “/” or “,”, that will be used to merge all the columns you specify. One use-case for this is when you have your day, month and year data types stored in multiple columns, and you want to merge them into one consistent column, using the “/” or “-” symbol.

A preview of merging the day, month and year column into one column named "Date", using the Merge multiple columns block.
New

Sort data by multiple columns

The new sorting block lets you sort multiple columns by ascending or descending order. You may use this block to sort your monthly sales data by month to look for variances in sales volume, or you can use it to rank some scoring in a lead scoring column. The possibilities are endless.

A preview of the "Sort data" block in Intersect

New Facebook Ads integration, merge columns with a separator and sort multiple columns

April 19, 2021

Facebook Ads integration

Running Facebook ads and trying to analyze your spent and best performing channels? We got you. Our latest updates allow Intersect to connect to your Ad Account and provide up to 23 columns for you to analyze for each of your campaign levels, across different time periods.

You only need to connect your Facebook and Ad account, and pulling data is done in just a couple of minutes. Check our official documentation for step-by-step instructions.

A preview of the Facebook block in Intersect

Merge multiple columns with a separator

In cases where you have separate columns with values that need to be mixed into one, you can use the merge multiple columns block. You can set a special character like “/” or “,”, that will be used to merge all the columns you specify. One use-case for this is when you have your day, month and year data types stored in multiple columns, and you want to merge them into one consistent column, using the “/” or “-” symbol.

A preview of merging the day, month and year column into one column named "Date", using the Merge multiple columns block.

Sort data by multiple columns

The new sorting block lets you sort multiple columns by ascending or descending order. You may use this block to sort your monthly sales data by month to look for variances in sales volume, or you can use it to rank some scoring in a lead scoring column. The possibilities are endless.

A preview of the "Sort data" block in Intersect

Try Intersect Labs Today

This is your gateway to the magical land of Intersect Labs, where we help you improve your data processes.
Book a Demo