We have a new organic social campaign we are going to start for a case against Rite Aid and we’ll need a landing page and Vegas call center number. What we need from me for the landing page and how soon can we get everything going once you get what you need from me.
Perfect, do you have a link for the landing page that was made for the Navy Fed case?
Jon Wright specifically asked not to make one for that case type, they only wanted a tracking number, and then we still build out the automation from the phone to the call center and got the "Banking Discrimination" intake template built to qualify leads and send to Desiree and team.
Oh weird! I didn’t get a chance to set my CTM password in time and I need a new code it says.
Works for me. My last meeting of the day should be done by 2:30 my time.
I'll ping you when I free up. Have a great afternoon.
Uzi, you good to catch up tomorrow. I'm feeling a bit sick all day and need to get some rest.
This is the social tracking for links training session. I'
Just realized I didn’t set a zoom. Want to just give me a call if this time still works?
To join the video meeting, click this link: https://meet.google.com/azs-ugsr-uxb
Otherwise, to join by phone, dial
@deleted-U069G4WMMD4, ping @Adrienne Hester in the #C05K09KMSCV channel, she has all project statuses. 🙂
Will do, I was first going to send this as a email and forgot the subject when I copy and pasted the message so it definitely didn’t make sense lol. I’ll ask again in the group chat.
No, those were organic, but I’ll double check on Cameron ‘s order sheet
*Thread Reply:* Confirmed, no paid campaign
@deleted-U069G4WMMD4, your Social Leads dashboard page is working again
Thanks! Quick question on the blog posts. Who do we plan on listing as the author on them?
We haven’t used a byline, but we can make it you if you want?
Let’s go with that for now and I’ll see if we want to use different attorneys as authors at some point.
Uzi, I did matches on phone and names, (de-formatting them to raw characters) and found these social lead cases. Lets discuss next meeting:
It was "techy-fun" to do this, the code to create the report is below, just for giggles:
sa.**,
CASE
WHEN LENGTH(sa.string_field_6) > 0 AND INSTR(sa.string_field_6, ',') > 0 THEN
CONCAT(
TRIM(LOWER(SPLIT(sa.string_field_6, ',')[OFFSET(1)])), ' ',
TRIM(LOWER(SPLIT(sa.string_field_6, ',')[OFFSET(0)]))
)
ELSE
TRIM(LOWER(sa.string_field_6)) -- If there's no comma, return the field as is in lowercase
END AS formatted_name, -- Reformats "last name, first name" to "first name last name" or returns the name as-is in lowercase
lead.name AS lead_name,
TRIM(REGEXP_REPLACE(lead.phone, r'[()\s-]', '')) AS cleaned_phone, -- Cleaned phone field with spaces removed
lead.source AS lead_source,
lead.type AS lead_type,
lead.crm AS lead_crm
FROM
`brandlytics-bi.ben_crump.sa_cases_export` AS sa
RIGHT JOIN
(SELECT
name,
phone,
TRIM(REGEXP_REPLACE(phone, r'[()\s-]', '')) AS cleaned_phone, -- Cleaned phone field with spaces removed
source,
type,
crm
FROM
`brandlytics-bi.ben_crump.lead_export`) AS lead
ON
CASE
WHEN LENGTH(sa.string_field_6) > 0 AND INSTR(sa.string_field_6, ',') > 0 THEN
CONCAT(
TRIM(LOWER(SPLIT(sa.string_field_6, ',')[OFFSET(1)])), ' ',
TRIM(LOWER(SPLIT(sa.string_field_6, ',')[OFFSET(0)]))
)
ELSE
TRIM(LOWER(sa.string_field_6))
END = TRIM(LOWER(lead.name)) -- Join on lowercase formatted name from sa_cases_export and lowercase lead.name from lead_export
WHERE sa.string_field_6 IS NOT NULL;-- Join on formatted name from sa_cases_export and lead.name from lead_expor
Jennifer Bates, Depo Provera social case signed yesterday from your S1: 0 PL-FacebookMB-UOCMP-OrganicSocial
Can you send me the number we set up for calendars?
Actually I think we had one for church fans not calendars. Looks like we’ll need one.
Here are the 3 we have, let me know if we need a 4th:
Give me a name label for it, I'll get Lee to set it up...
@deleted-U069G4WMMD4, here is the 4th:
It’s the first one on the list in the screenshot you sent. Does that work?
Hello Ryan, we have partners asking for some website stats. Can you provide answers to the following?
How many visitors -to the home page -to other pages How many people click on the articles How many people visit the results page Can you tell me if people use the drop-downs to go to other parts of the site, like the "National Practice Areas"?
*Thread Reply:* @deleted-U069G4WMMD4, can i get some backstory, which partner and why are they asking?
*Thread Reply:* Give me a call when you get a second and I can explain it better.
@deleted-U069G4WMMD4, ready this and let me know if you need more:
https://docs.google.com/document/d/1RUd3wUQkci2-_c2FRsZIuqqg7b2sEGHU-cIViPVvVGM/edit?usp=sharing
Summary of this contentThe 2024 Search Marketing Annual Report for Ben Crump law firm focuses on SEO-generated cases and Google Search performance.
• SEO Generated Cases: From March 2023 to January 2025, Ben Crump saw 2,736 SEO-generated cases, of which 1,987 (72.6%) are revenue-driving. 2024 saw an 11x improvement in retained cases compared to 2023. Top practice areas include Vaccine-Related and Toxic Tort, with most cases originating from Michigan, Illinois, and California. Case volume growth peaked in November 2024 and has remained strong. • Google Search Console 2024 Insights: Total clicks were 695,749 with a 0.01% average CTR. The US contributed the most clicks, with India a distant second. Mobile devices generated the most clicks, and the homepage saw the most engagement. Product snippets were the top search appearance. Recommendations for 2025 include mobile optimization, leveraging high-performing pages, and increasing international reach. • Google Search Rankings 2024 Insights: Motor Vehicle Accident keywords saw 16,321 clicks with a 7.89% average CTR. Top non-brand performing keywords included "truck accident lawyer" and "car accident attorney." The report lists the top 10 pages that need improved meta descriptions for better CTR, including pages about car accidents and civil rights lawyers. The report illustrates the significant impact of SEO on case acquisition for Ben Crump, with recommendations to further enhance performance in 2025.
https://bencrump.com/let-us-fight-for-altadena/
Your campaign setup is ready and leads tested from page to form and call at call center.
Is there way to know if this one came in through the landing page I created or through the old one?
*Thread Reply:* @deleted-U069G4WMMD4, added this for you on that page.
*Thread Reply:* Thanks, with that specific one being blank does that mean we don’t know exactly where it came from?
*Thread Reply:* Answered in the other sub-chat in the channel.
LaToya can setup CTM tracking numbers now, just @ me in the post in your #C05K09KMSCV
That’s the one. Thanks! I’ll throw that request in there.
Can you take a look at the dashboard. Somethings up with it.
Might have a service issue, 2nd complaint today. Will check.
@deleted-U069G4WMMD4, it's a google issue, try refreshing browser and be patient, this happned across several of our various clients. You'll be on a new system soon that is MUCh better.
@deleted-U069G4WMMD4 , I’m going to push this to tomorrow morning if you don’t have anything, if you do, can you put it here?
Same, four major projects , your analytics and datastore from call center and more! lol. Been to Vegas lately?
I haven’t been in quite awhile. I heard there’s a new office!
Good. There are three integrations, fixing Camp Lejeune, syncing PM crm to SmartAdv BCL, and building a data warehouse, it will take months to ensure clean data is built in dashboards.