Ryan (ryan@themedialab.agency)
2024-05-07 11:08:09

Here is the billable statuses:

image.png
Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-05-08 12:47:43

@Ryan on your financial dashboard for flatirons can you show me where these contracts are coming from? I’m am trying to match up what I sent to Dave and I’m only off by one or two. Looking in the data warehouse there isn’t any info on LeadId or other ID. Might be in AWS and not being passed but need to reconcile. Could we sit down ASAP to go over this for Dave?

Ryan (ryan@themedialab.agency)
2024-05-08 13:08:15

@Nicholas McFadden, in the TIP DB in BigQuery you can query this table and where "typeofcase" LIKE '%Flatirons%' and you'll get LeadIDs.

tort-intake-professionals.awslegagcypublic.financial_log

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-05-08 13:15:15

ok thanks I will look into it

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-05-08 13:26:54

Is there not a fivetran batch id?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-05-08 13:29:16

How are you filtering for the latest version? Date range on "fivetran_synched" or some filter on "fivetran_deleted"?

Ryan (ryan@themedialab.agency)
2024-05-08 13:39:02

If there is not, not sure why but the data is updated 4x per day but for reconciliation, use through yesterday

👍 Nicholas McFadden