By Taylor Mcgrath

Panintelligence Marketing Visualization

Integrates with:
facebook ads integration Snapchat data integration

This Kit allows you to visualize all of your advertising data in one place for real time performance management for you and your clients by giving a complete overview of campaign metrics and ROI. Data is queried from any combination of the below advertising and communication sources to populate the live dashboards and reports supplying campaign analysis and performance tracking, all in one place, with real-time insights.

  • Facebook Ads
  • Snapchat Marketing 
  • Twitter Ads
  • TikTok 
  • LinkedIn Ads
  • Bing Ads 
Dashboards and reports can be white labelled and styled to your digital agencies own branding, giving clients a seamless brand experience. It saves you time and drives efficiency whilst building trust with your clients through complete transparency. 

This Kit includes…

Data ingestion from the following ource entities:

A master logic river that orchestrates the transformation of all the marketing data from the sources within the Snowflake data warehouse to an all encompassing data model which allows for cross-channel analytics.

The minimum RPU consumption will be based on how many of the sources are used in the analysis and how much data is being pulled from the endpoint. Consult the Rivery Pricing Documentation for more information.

Configuring this Kit for use

Variables

In this Kit, there are three variables that are used to make for dynamic use of target configuration. 

  • {Database_Marketing} is used in all Target configurations and queries as the target database name.
  • {Schema_Marketing} is used in all Target configurations and queries as the target schema name.
  • {PM_Alert_Group} is used as the alert email address(es) for when a river fails (optional).

Go to the Variables menu on the left side navigation bar and create the global variables for Database_Marketing, Schema_Marketing, and PM_Alert_Group. Fill in the values as the Snowflake database and schema where you would like the data to land and the email address(es) to which you would like the failure emails sent.

Directions

Here are step-by-step instructions on how to use the Panintelligence Marketing Visualization Kit and connect it to your Panintelligence account. 

  1. Add the above variables to your Rivery account’s global variable list
  2. Within the ‘Panintelligence Marketing Data – Logic’ river, toggle off the containers for which you do not have source Kits (ex: if you do not use the Facebook Ads source, select the enable/disable toggle within the Facebook Ads container)
  3. Run the ‘Panintelligence Marketing Data – Logic’ river
  4. Go to Panintelligence Partnership with Rivery and click ‘Find Out More’
  5. Follow directions to create an account (enter an email and password)
  6. Create an environment – Your own customer dashboard environment will be built in 5 minutes
  7. Login as rivery / rivery in your environment
  8. The data connections will be edited, but you’ll see a dashboard with default data
  9. Click the ‘wrench’ in the top right corner and select data connections
  10. Select Edit the Modular Marketing Data Connections 
  11. Enter your snowflake details – exactly as you did in the Rivery console
  12. Save the data connection and click back into the dashboard
  13. Refresh the page and your data is displayed!
Connections

Kits are imported with ‘blank’ source and target connections. In order to use the kit, you have two options:

  • Swap out blank connections with existing connections
  • Add credentials to the blank connections that come with the imported Kit

Easily Solve Your Most Complex Data Challenges

No Credit Card Required.