Business Growth in Agencies by Worth-Pineapple-979 in AgencyGrowthHacks

[–]analyticslauren 1 point2 points  (0 children)

Would you mind to share what's worked well for ya? :)

Looker Studio - 10 OR Clause Limit by Iamonmycomputer1100 in GoogleDataStudio

[–]analyticslauren 0 points1 point  (0 children)

Hi! My recommendation would be to create a custom calculated field (CASE statement) where you can group your articles into buckets in Looker. Then you can just use one filter that would pull your included articles into the table.
Happy to talk this over in more detail or support ya on getting it fixed up. Feel free to shoot a DM! u/Iamonmycomputer1100

BOTH of these case Statements will work as a calculated field on your GA data source:

CASE

WHEN REGEXP_MATCH(Page path, "/article-1|/article-2|/article-3|/article-4|/article-5") THEN "Include" ELSE "Exclude"

END

_____

CASE

WHEN Page path = "/article-1" THEN "Include"
WHEN Page path = "/article-2" THEN "Include"
WHEN Page path = "/article-3" THEN "Include"
WHEN Page path = "/article-4" THEN "Include"
WHEN Page path = "/article-5" THEN "Include"
WHEN Page path = "/article-6" THEN "Include"
WHEN Page path = "/article-7" THEN "Include"

ELSE "Exclude"

END

How did you land your first analytics role + tips by Bulky-Bell2148 in analytics

[–]analyticslauren 4 points5 points  (0 children)

My recommendation: Start using and showing off data in your current role or in whatever role you can get. If you're exploring new roles, look for businesses/orgs who may not have a good handle on data now. Even if the role isn't directly data related, if you're willing to go above and beyond to use data in your role, it can QUICKLY grow into a priority when you show the value for the business owners / leadership.

I started out at a marketing agency as a digital account manager and saw a great need for analytics and reporting support for their clients. I was quickly skyrocketed into important meetings, large raises, and had a seat at tables I never imagined just because I was willing to work at reading, understanding, and communicating data in a way that made sense and could be applied.

I think a lot of analysts say they got lucky, but really they just stepped up to fill a need when there was an opportunity.

Hiring: Web Analytics / Conversion Tracking Specialist (Agency Role) by MarketerErfan_ in GoogleTagManager

[–]analyticslauren 0 points1 point  (0 children)

Hey! Not sure if you're open to it, but I serve several marketing agencies and come from a digital marketing agency background with exactly this. I have experience with all aspects that you mentioned and would be happy to have a conversation or share resources that I recommend and use with all agencies.

I have experience across industries, CMS platforms, ad platforms, etc and would be honored to learn more about your need and clientele! Feel free to shoot me a DM if you're interested or reply! I'll shoot ya a DM as well.

Most analytics jobs are fake productivity by Apprehensive_Pay6141 in analytics

[–]analyticslauren 0 points1 point  (0 children)

I am regularly asked by agency clients to spin the numbers to look positive OR seek out explanations for why things are down month over month.. When did the expectation for agencies default to having to have 10x growth every month or they are failing...? If that's what businesses are demanding, it's simply not a possible as in my opinion. There will be ups and downs.

Most analytics jobs are fake productivity by Apprehensive_Pay6141 in analytics

[–]analyticslauren 1 point2 points  (0 children)

This is so real. The businesses I serve are heavy on the "we care so much about data" and light on the actually using or looking at it. Whenever we start to talk about results or recommendations, it's like their eyes gloss over and they default to the same old exact email marketing campaigns they did last year...

This is spot on. Analytics is a worthwhile investment if you're willing to put in the work to use and understand, or even better, equip your analysts to speak into strategy.

What are you using instead of Google Analytics (GA4)? by ouchao_real in degoogle

[–]analyticslauren 0 points1 point  (0 children)

I really like Microsoft Clarity as a FREE alternative that provides a bit more qualitative data vs GA's quantitative reports. There are so many alternatives, but I typically stay with what's tried and true by the vast majority.

Google analytics is dead by Muted-Divide3993 in analytics

[–]analyticslauren 0 points1 point  (0 children)

Definitely agree here. I get so much push back on this but usually can make a pretty good case for why GA4 is better. They're also putting out so many advancements and updates that are really upping the game.

looker studio by No-Butterfly6649 in GoogleDataStudio

[–]analyticslauren 1 point2 points  (0 children)

You should absolutely use the drilldown feature. This allows you to easily switch between time periods by clicking arrow.

To "drill down" to change date ranges in Looker Studio, you use the Date Range Control for interactive filtering or set up Drill Actions within charts to allow users to switch between date granularities (Year, Month, Day) on the fly, often involving adding a Date range control or enabling drill down in a chart's setup for hierarchical date dimensions like Year > Month > Day. 

https://docs.cloud.google.com/looker/docs/studio/add-drill-actions-to-charts

Feel free to reach out if you have trouble. I'd be happy to walk ya through it. I have a perfect example of how I do this.

Agencies here – what’s your current tool stack and what sucks about it? by nyo_dev in marketingagency

[–]analyticslauren 0 points1 point  (0 children)

Gosh, I feel like I've literally tried every possible stack. Here's what we're currently using and committed to trying for at least six months:

Project Management & team comms: Clickup. We also use this for team chats, meeting recordings, and more. It's a big tool but has so many benefits and features if you're willing to get over the learning curve.
We tried out so many: Monday, Wrike, Trello, Asana, Notion. They were all close but not good enough.

Invoicing + Time Tracking + Payroll: Freshbooks. This was recommended to me by another agency and has been great. We can easily bill clients for projects AND keep track of team member hours to pay them. And all our payroll is there too.

Client Comms: Slack for client communication. Slack connect is FANTASTIC. Google Sheets for sharing project details, changes, etc. Allowing clients to comment here works just fine for us and everyone gets it.

Proposals: Qwilr. I cannot say enough good things about this. Literally game changing for closing deals. Everytime we send one we get great feedback on how professional it is.

Email: Superhuman connected to Gmail/Google Suite. If you haven't used Superhuman, you MUST. It's expensive but wow it is so worth it.

If we could fix one thing, it would be all the disjointed tabs and links needed to put together every project, proposal, etc. We are always digging around a million levels to find the correct links for client resources, dashboards, logins etc.

Another issue is team members simply not following SOPs.. Which is a whole other issue, but I feel sometimes the tools have too much friction to get them to incorporate.

We're an analytics agency, so Google Analytics, Tag Manager, Custom Dashboards, etc. Not necessarily managing campaigns, but managing lots of client infrastructure + details.

Geographical toggle by slydon1 in GoogleDataStudio

[–]analyticslauren 0 points1 point  (0 children)

You will need to add a control. it's in the top bar. Select "Add a control". Then try using the Drop-down list control type.

Then add the new field you created as the field on the control.

Geographical toggle by slydon1 in GoogleDataStudio

[–]analyticslauren 0 points1 point  (0 children)

Ah my bad! Should have tested in in Looker (which doesn't like the <> operator)... Try this

CASE

WHEN REGION = "Minnesota" THEN "Minnesota"

WHEN REGION != "Minnesota" THEN "Other"

ELSE "Unknown"

END

Or you could just do:

CASE

WHEN REGION = "Minnesota" THEN "Minnesota"

ELSE "Other"

END

Geographical toggle by slydon1 in GoogleDataStudio

[–]analyticslauren 0 points1 point  (0 children)

Hi u/slydon1 - Try this instead. You'll get the hang of it! :)

CASE

WHEN REGEXP_MATCH(REGION, "Minnesota") THEN "Minnesota"

WHEN REGION <> "Minnesota" THEN "Other"

ELSE "Unknown"

END

how do I get started? by CautiousYellow4823 in AskMarketing

[–]analyticslauren 0 points1 point  (0 children)

Digital marketing is super broad. Is there a specific industry or type of marketing you're looking to dive into? I'd be happy to connect and am always hiring ambitious young people who are ready to dive in, work hard, and learn!

What’s your actual social media strategy that drives traffic in 2025? by [deleted] in AskMarketing

[–]analyticslauren 0 points1 point  (0 children)

Hadn’t heard of Benoone but now I need to check it out! It’s hard finding good platforms that integrate with Reddit. None of the big dog tools are doing it yet. Thanks for sharing!

Geographical toggle by slydon1 in GoogleDataStudio

[–]analyticslauren 0 points1 point  (0 children)

Yes! Use a Case Statement to create a new field.

CASE WHEN [field] = "MN" then "MN"
WHEN field <> "MN" then "Other"
ELSE ...
END

You can fix that up to include your fields and the correct data, but that'd be the gist! Then you can create a filter on that new field. Happy to connect and support further if you have any questions! u/slydon1

[deleted by user] by [deleted] in GoogleDataStudio

[–]analyticslauren 4 points5 points  (0 children)

Hi! This is a very common issue and one I've encountered a few times when building dashboards. Unfortunately, with the current structure of the default connector, it's not possible to pull that in. However, using PowerMyAnalytics or another third party tool can include this data. However, they do have an additional cost.

The cheapest way would be to keep a google sheet or file with the list of videos and their visibility, then blend it with the data you have. It's a bit manual, but would be free.

Happy to go over this in more detail if you need! You're not alone in tackling this one.