Zapier

The digital marketing Zapier integrations and zaps

General Usage - IMPORTANT

  • Always make sure your zap is on after working on the zap.
  • The smallest change will turn off a zap.
  • Each Zaps name explains what it does.
  • Changing the admin / igmaster password or username will turn off all mautic integration.

Ownership

With Donovan Barker leaving the group, the ZAPS have been transferred to Ben van Eeden. The Excel connector App account has also been transferred to Ben van Eeden’s.

Zaps

Best Internet

  • Best Internet - GA Lead Form
    • Pulls leads from Google Search Lead Forms into Lead database
  • Best Internet - New Website Form to SQL
    • Mautic website form to lead database
  • Best Internet Bot - Zendesk v2
    • Landbot sends support tickets to zendesk via this zap
  • Best Internet Bot Hook
    • Landbot sends leads to lead database
  • Best Internet FB to Mautic v2
    • Facebook lead ads to Mautic and SQL
  • Mautic Best Internet Form 2 to SQL
    • Mautic website form to lead database
  • Mautic Best Internet to SQL
    • Mautic website form to lead database

HomeLinkd

  • HomeLinkd - Facebook to Connex v3 - Split
    • Facebook lead ads to Mautic and SQL and connex
  • HomeLinkd - GA Lead Form to SQL and Connex
    • Pulls leads from Google Search Lead Forms into Lead database and connex
  • HomeLinkd Mautic to SQL and ADT Only
    • Mautic website form to lead database and ADT lead service
  • HomeLinkd Mautic to SQL and Connex v2 - APG&E Only
    • Mautic website form to lead database and APG&E lead service
  • HomeLinkd Mautic to SQL and Connex v2-Source Split
    • Mautic website form to lead database and Connex

Huawei Cares

  • All of them are Mautic website form to lead database

Life Alert

  • Life Alert to connex
    • Website form to lead data base then connex

Me&You

  • Me&You Lead Gen to DB and connex
    • Facebook lead ads to lead db and connex

Misc

  • IG Recruitment Leads
    • Facebook leads ads to excel doc
  • MP Website leads
    • Website lead form to leads database
  • Spot - Elite Campaign - SMS and Email web traffic
    • Check Google Analytics for previous days traffic from sms and emails and loads it into the lead db

Mobile Store

  • Mautic MS Call Back to SQL

    • Mautic Form to lead data base
  • Mautic MS to SQL v2

    • Mautic Form to lead data base
  • MS - FB Lead ads to SQL Server and Mautic v3

    • Facebook lead ads to mautic and then lead database
  • MS - Mautic Unknowns to SQL

    • Leads that responded to email communication - Mautic form to leads database
  • MS Google Lead Forms

    • Google Lead forms to Mautic and sql database
  • MS Landbot to Fresh Desk

    • Landbot to freshdesk via zapier
  • MS Landbot to Lead

    • Landbot lead to mautic and lead database
  • Zapier is triggered with the Facbook lead.

  • The lead is inserted into the Lead DB.

  • The Mautic contact is updated.

  • If the lead Campaign is VC Voice Upgrades, then the lead is inserted into the dialer Ignition 6

  • The leads inserted into the Leads DB are cleansed by Tommie’s SSIS package, and inserted into the cleansed leads table.

  • The Power Automate Flow picks up the cleansed leads.

    • If the Lead’s number starts with 082 or 083, then the lead is inserted into the dialer.
      • DM - Leads to Connex (Mobile Store) - Nulls - 082 and 083 only v2
    • Leads with an XDS score above 679 or 0 is inserted into the Dialer

OnAir

  • OnAir Mautic to Best Internet SQL
    • Onair mautic form to lead database
  • OnAir to SQL and connex
    • Onair mautic to connex dialler

Spot

  • All do the same thing. Check the Appsflyer service to see how many people downloaded and installed Spot

VivaLife

  • Mautic VivaLife Contact Form 2 to SQL
    • Mautic form to leads db
  • Mautic VivaLife Contact Form to SQL
    • Mautic form to leads db
  • Viva Lead Gen to DB and Connex
    • Facebook lead ads to leads db
  • VivaLife application Hook
    • Viva Application Form to Leads db

Zapier Troubleshoorting

The digital marketing Zapier integrations and zaps troubleshooting

Last modified September 20, 2021: Digital Marketing (f6ac392)