How-to set up an alert if your Meta Account or Campaign stops spending
Overview
This alert will identify if an account or campaign stopped spending DoD, comparing yesterday to today.
Platforms | Meta |
Datasource Type |
|
Required Columns | Urgent issue |
Instructions
Step One: Create your day-over-day report
Navigate to Explorer in Alli
Select
New Data Report
Name your report, provide a description and select
Custom SQL
as your sourceCopy and paste the SQL provided below, and made the necessary adjustments.
5. Click Preview
and confirm if the output is correct
6. Once you are QA’d, click Publish
and move to Step 2 (Marketplace App)
Step Two: Set up your Marketplace Alert
In the Marketplace tab, search for Alli Custom Alerts and select to install the app
![](../../__attachments/2702540815/image-20221026-221803.png?inst-v=9d2044ed-f5d2-41ad-960f-0e53811769aa)
Follow the provided setup instructions to complete your Marketplace app
Remember for the
view_name
it should match the report you just created! So in the example, we created a report calledreport_name
, so the total view_name should beclient.report_name
Don’t forget to set a schedule if necessary
You’re all set up, you will now receive an alert if your Facebook account or campaign stops spending.