Power Automate

The digital marketing Power Automate flows

Overview

Where I [Don Barker] was able to I preferred to use Microsoft Flow - Now called Power Automate. The reason was this is because Zapier charges us per zap, whereas with Flow we have an unlimited package. All the flows require no maintenance, the only time I would come into here was when there were new flows to be created.

DM - Account Level: BRAND NAME Facebook Spend

Between 6 and 6:30 am these are scheduled to run. Basically they connect to the Facebook API and download each of the brands previous days spend. The API works at an account level, so when new campaigns are loaded its not an issue these will automatically pull through.

To create a new a Flow you just need to get the account id from Facebook and click on where the HTTP request is made and include it in the URL. You also just need to update the variable to include the campaign name (HomeLinkd, Best Internet ect.)

TODO - INSERT IMAGE

DM - CallRail BRAND NAME

We use a service called call rail that records all inbound calls we receive on USA lead gen campaigns. This flow links this service to our leads database. This is done for reporting reasons. Its a simple flow that waits for a webhook to be posted to it. When the webhook is received it then inserts it into the database.

DM - Leads to Connex

These flows take the leads from the cleansed leads database and inserts them into the dialler. There are a few different rules within each of them in terms of the leads that are loaded, however they are all mostly the same.

DM - Leads to Connex (Best Internet) v2

Standard, all leads that are 0, 600 and above and unknown XDS score

DM - Leads to Connex (Huawei) - All

Standard, all leads coming form the Huawei cares website.

DM - Leads to Connex (MS) - 0 and 680+ - With MTN API - ?? Renamed - DM - XDS MTN API - Request Based

This is a little different, we also push leads to the MTN API to check if they can be prevetted. Sucessful leads include the detail of this Vet when loaded into the dialler.

DM - Leads to Connex (Mobile Store) - Nulls - 082 and 083 only v2

This is another batch of Mobile Store leads we load. Its only of leads we don’t know the XDS score of, but have a premium cell number (082, 083).

DM - Leads to Connex (Viva) - All

Standard, all leads coming from the Viva website.

  • DM - MS / BI / HL - SEM Rush
  • DM - MS - SEM Rush Site Audit
  • DM - MS - SEM Rush Top 50 Keyword
  • DM - MS - SEM Rush Traffic Report
  • DM - BI - SEM Rush Site Audit
  • DM - HL - SEM Rush Site Audit
    All these reports to a similar thing. They pull data from a service called SEM rush. These are then loaded into a sharepoint excel file. Powerbi then consumes this data. Its purely for reporting purposes.

Spot SMS and Mailer

  • DM - Spot - SMS 1 Tracking
  • DM - Spot - SMS 2 Tracking
  • DM - Spot - SMS 3 Tracking
  • DM - Spot - SMS 4 Tracking

All the above connect to the Bitly API to determine how many of our SMS links have been clicked on. This is then inserted into our lead database. Powerbi uses this data for reporting reasons.

  • DM - Spot Mailer Status Update (previous day)
  • DM - Spot Mailer Status Update (today)

All the above connect to the Mandrill API to determine how many of our Email links have been clicked on. This is then inserted into our lead database. Powerbi uses this data for reporting reasons.

  • DM - Spot - aspotl.ink/elite50 - Tracking

The above connects to the Bitly API to determine how many of the leads have clicked on the app store link. This is then inserted into our lead database. Powerbi uses this data for reporting reasons.

Remaining Flows

  • DM - HomeLinkd - 10min Call Conversions
  • DM - HomeLinkd - Sales to Google
    • Checks our lead database for all leads that have a gclid (google clid id) and ended up being a sale (according to the dialler). It then takes this result and puts it into a google sheet which Adwords consumes.
  • DM - Landbot Order
    • This is a hook that landbot connects to to get the Silver Surfer Order Status
  • DM - MS Unknowns Journey
    • All leads that are generated that we are unable to get an XDS score for we load into a segment in Mautic. These leads are then communicated with via email within a Mautic journey.
  • DM - XDS MTN API - Request Based
    • The “DM - Leads to Connex (MS) - 0 and 680+ - With MTN API” flow connects to this flow. This is the API that does a prevet on a lead with XDS.

Last modified August 25, 2021: Merge changes (2f59c2d)