July 2022 Release Notes

What's New? 🚀

Sources:

• Pepperjam provides affiliate marketing solutions and supports business growth for marketers seeking a scaled replacement for their primary sales and marketing projects.

Features:

• Amazon Athena is an interactive query service that allows you to analyze data in Amazon S3 directly using standard SQL. With a few clicks in the AWS Management Console, you can point Athena at your Amazon S3 data and start running ad-hoc queries that return results in seconds.
  Please note that Amazon Athena is currently available in beta. It is only accessible in Overwrite loading mode in Logic Rivers.

• Amazon S3 as a Target - It is now possible to convert CSV/JSON files to Parquet files when using Amazon S3 as the Target.
  Please be aware that Webhook and Storage Files (with the exception of Amazon S3 and Email) are not currently supported but will be in the near future.

• Python allows for the manipulation of vast volumes of data, and a XXL (16 GB) and XXXL (30 GB) option is now available.

• The following Metadata columns are now included by default in each Output Table of Source to Target Rivers:

  _rivery_last_update
  _rivery_run_id
  _rivery_river_id

  Please Note:
  This feature is currently only available for Predefined Reports and Multi-Table supported Databases.

Sources Updates:

• In the Incremental Extraction Method, there is a new mechanism for updating the Start Date only if the river run is successful.
  If you do not want this to be the default setting, go to More Options and check the box to advance the start date even if the River run fails (Not recommended).
  This is carried out for the following Sources:

  • Microsoft SQL Server
  • Salesforce
  • MongoDB
  • Jira
  • PostgreSQL
  • Facebook Ads
  • Google Sheets
  • Google Ads
  • MySQL
  • Bing Ads
  • Amazon S3
  • Zendesk
  • Twitter Ads
  • TikTok
  • LinkedIn Ads
  • Hubspot
  • SFTP
  • Stripe
  • Email
  • Apple Ads
  • Snapchat Marketing
  • Pinterest
  • Google Cloud Storage
  • Facebook Social
  • Shopify

• Facebook Ads API version 14 is currently supported, and the Campaigns report now includes a new field called 'Smart Promotion Type'.

• Tiktok now includes a new field 'Campaign Type' in the Campaigns report.

Kits ⭐

Panintelligence Marketing Visualization - This Kit enables you to visualize all of your advertising data in one location for performance management for you and your clients, providing a comprehensive overview of campaign metrics and ROI. Data is retrieved from any combination of the advertising and communication sources listed below to populate the live dashboards and reports that provide campaign analysis and performance tracking in real-time.