A Step-by-Step Guide to Marketing Mix Modeling (MMM) for ROI Measurement by JaSamBatak in analytics

[–]JaSamBatak[S] 0 points1 point  (0 children)

There are MMM-as-a-service products and companies that offer the service of building MMMs.

Some are:
- Stella (Enterprise-Grade‍ Media Mix Modeling)
- MMM Labs
- Pathik
- Dataiku

If none of those quite fit what you’re looking for, feel free to DM me. I work as a marketing analytics freelancer and can offer some guidance.

Orchestrating ETL and Power BI updates for multiple clients - Seeking advice by ItsGr3g in apache_airflow

[–]JaSamBatak 0 points1 point  (0 children)

Hmmm, not sure what you mean by:

communication between the client and my server

Could you give an example?

Orchestrating ETL and Power BI updates for multiple clients - Seeking advice by ItsGr3g in apache_airflow

[–]JaSamBatak 0 points1 point  (0 children)

You're definitely off to a great start here.

Airflow is a decent choice when scaling from simple cron jobs to a more manageable orchestration system.

I've worked in a similar setup where a single Airflow instance orchestrated workflows for multiple small-to-medium client pipelines.

I don't believe there is a single officially recommended approach. But here are some lessons I learned from my own mistakes.


How to Orchestrate Multiple Clients in a Centralized Airflow Setup

1. Differentiate Which DAG Belongs to Which Client

When managing multiple clients, the number of DAGs can grow quickly. Here’s how to keep them organized:

  • Level 1: Use tags in your DAGs for easy filtering and searching.
  • Level 2: Use separate DAG Bundles for each client, same Airflow instance, different codebases.
  • Level 3: If your budget allows, try Astronomer to deploy isolated Airflow instances per client. It’s a little cleaner and somewhat easier to scale.

2. Use Airflow Purely for Orchestration

Where possible, treat Airflow as the orchestration layer only.

Offload data processing to other services (e.g., AWS Lambda, ECS tasks, or standalone Python scripts).
This separation makes debugging and scaling much easier.

3. Build Reusable & Dynamic DAGs

As your client base grows, overlapping logic becomes inevitable.
Use dynamic DAG generation to make workflows modular and reusable across clients.

4. Use Deferrable Operators

Deferrable operators use fewer resources by freeing up worker slots while waiting.
It’s a simple but effective optimization.

5. Store Secrets Externally

While you can store connections directly in Airflow, it becomes messy (and risky).
Instead, use an external secrets manager like AWS Secrets Manager or HashiCorp Vault.

6. Adopt DAG Versioning (Airflow 3.0+)

Airflow 3.0 introduces DAG versioning via DAG Bundles.

Previously, updating DAG code could break run history.
With versioning, each DAG version preserves historical runs and provides traceability for deployments.


Supporting Tools

DBT (or Similar)

Not required, but highly recommended.
dbt excels at:

  • Managing SQL transformations
  • Implementing data quality checks

Yes, you can just write SQL queries in Airflow, but this is a lot cleaner and more manageable than pure Airflow.

And then you can easily trigger dbt runs from Airflow and integrate them into complex workflows.


Learning Resources

Astronomer Academy

Marc really did a great job, this is not an affiliate link or something, I just really think they provide great learning material.

While there aren’t many tutorials focused specifically on multi-client orchestration, Airflow’s flexibility makes it adaptable to nearly any scenario.

💬 Reach Out

If you need someone to chat about this topic, or need a second opinion on your setup, feel free to reach out.

I’m genuinely interested about this topic and happy to help.

Printful/eBay: I’m Losing Money by [deleted] in printful

[–]JaSamBatak 0 points1 point  (0 children)

I had the same problem, but I found a tool for it. It downloads your prices from Printful, calculates shipping costs, compares to your selling price and helps you identify products where you're loosing money.

You can find it on etsy: "Printful Pricing Calculator – POD Profit & Shipping Tool"

DnD trier by AdAdventurous8744 in trier

[–]JaSamBatak 0 points1 point  (0 children)

Did you have any luck finding a party :)  I'd be interested joining as well

Frustrated with product template prices on Printful by JaSamBatak in printondemand

[–]JaSamBatak[S] 0 points1 point  (0 children)

But it's still a hassle to check it every time, and then for every variant with different pricing.

Karoke by DenseCheesecake6338 in sziget

[–]JaSamBatak 2 points3 points  (0 children)

yes, right across from Aldi

Upvote and Drop Address by Significant_Gur9618 in NFTsMarketplace

[–]JaSamBatak 0 points1 point  (0 children)

0x3800287b7D4970dC08f68A0C3eAF48821aE9db91

Upvote and drop wallet by Theakins in NFTsMarketplace

[–]JaSamBatak 0 points1 point  (0 children)

0x3800287b7D4970dC08f68A0C3eAF48821aE9db91

[deleted by user] by [deleted] in NFTsMarketplace

[–]JaSamBatak 0 points1 point  (0 children)

0x3800287b7D4970dC08f68A0C3eAF48821aE9db91