Malissa (malissa@shield-legal.com)
2025-03-03 13:52:06

hi @Dustin Surwill @Ahsan

Malissa (malissa@shield-legal.com)
2025-03-03 13:52:13

Greg and I just met with Jon Becker

Malissa (malissa@shield-legal.com)
2025-03-03 13:53:15

We need to report to him anything that doesn't have a smart advocate ID

Malissa (malissa@shield-legal.com)
2025-03-03 13:54:37

He also asked that we do a daily report for everything we took in the previous days. Is there something Greg and I can use to see what has a smart advocate ID? (i know you guys are busy)

Malissa (malissa@shield-legal.com)
2025-03-03 13:55:01

Or is there a daily report that can run that includes SA IDs?

Ahsan (ahsan@shield-legal.com)
2025-03-03 13:57:05

I can write a query that will display the last days sends. Once I am out of this flatirons meeting I will work on it

Ahsan (ahsan@shield-legal.com)
2025-03-03 15:55:02

https://console.cloud.google.com/bigquery?hl=en&project=integrations-tip&ws=!1m21!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s10f137cb-3789-4103-b473-0132faa5edbe!2e1!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s767719bd-bab7-42c6-88ce-d7480e7ad777!2e1!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s93c6c39a-ad81-423a-972f-0c69b4a0f10b!2e1|https://console.cloud.google.com/bigquery?hl=en&project=integrations-tip&ws=!1m21!1m6!12m[…]ip!2sus-west4!3s93c6c39a-ad81-423a-972f-0c69b4a0f10b!2e1

accounts.google.com
Google Cloud Platform
Google Cloud Platform lets you build, deploy, and scale applications, websites, and services on the same infrastructure as Google.
Original URL: https://console.cloud.google.com/bigquery?hl=en&project=integrations-tip&ws=!1m21!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s10f137cb-3789-4103-b473-0132faa5edbe!2e1!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s767719bd-bab7-42c6-88ce-d7480e7ad777!2e1!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s93c6c39a-ad81-423a-972f-0c69b4a0f10b!2e1
Ahsan (ahsan@shield-legal.com)
2025-03-03 15:56:02

This is the query for daily send s for meadow integrations. You both have been added to the query as a shared user.

SELECT ** FROM `integrations-tip.gcp_integrations_postgres.lead_data_view` WHERE case_type_id in (1705, 1749, 1892, 1794) -- enter case type here AND DATE(intake_processed_at) = CURRENT_DATE - interval 1 day ORDER BY intake_processed_at DESC LIMIT 1000;