Digital Marketing Data Flows

Zapier

1. Facebook leads trigger the Zapier flow.
2. Zapier inserts the lead data into the IGN_LEAD_DC SQL database.
   • This step automatically triggers the power automate flow below.
3. Zapier formats the data, and calls Mautic to create or update the contact.
   • If a contact segment is in a Mautic Campaign, the campaign will trigger for this user to send out comms.
4. Depending on the Facebook lead, Zapier filters the incoming lead, and inserts into the Connex Dialer via API if appropriate.
   • E.g. MS - FB Lead ads to SQL Server and Mautic v3 Zap only inserts into the dialer if the Campaign name matches the campaign “VC Voice Upgrades”.

Lead Cleansing - Tommie’s SSIS package

1. The uncleansed leads' data are collated with the XDS scores based on MSISDN, ID numbers and some other criteria like name or nickname.
   • we get around a 45% - 48% hit rate on incoming leads.
2. The collated data is then inserted into the cleansed leads table.

Power Automate - Cleansed leads

1. Some Power automate flow triggers when a new row is inserted into the IGN_LEAD_DC SQL database.
2. Based on the configuration within the flow, the leads are filtered and inserted into the connex dialer.
   • e.g. DM - Leads to Connex (Mobile Store) - Nulls - 082 and 083 only v2.
     • if the MSISDN starts with 082 or 083 the leads is added to the Ignition6 dialer campaign.

Troubleshooting

Known Issues

Data not appearing in the reports. There are two main entry points into the database. The powerBi report is populated by Power Automate flows which connects to the Facebook API to retrieve the analytics.

These flows are all prefixed with DM- Account Level: Navigate to these flows and ensure that they are running. When clicking on a flow, you will see the 28-day run history. The Status field, you will see whether the last run was successful or not. Clicking on the row will show you the data with which the flow passed / failed.

If the flows ran successfully, but no rows were returned from teh Facebook API, consult the Digital marketing team to review the ads.