Sphinx Mind

Your AI Marketing Assistant

[Ahmed Ali @A7med_3ly]

Just integrated Shopify with @SphinxMind. You need to read this if you’re considering building on top of Shopify.

This is my first time building something on Shopify. I always thought things would be straightforward, given the large dev community behind it. However, it turns out Shopify is another monopoly.

You must use the Shopify Billing API to charge users, regardless of whether your app is listed or unlisted in their store. This means you need to pay 20% on each transaction. But why should I pay if my app is unlisted and I am not getting any installs from your store?

This is overkill for us, as Shopify isn’t our core business. It's just one integration out of many, and it’s not proven that a lot of people will adopt it yet.

The workaround for us was custom distribution where users create the app themselves and share the access token. It's not the best we aimed for, but it works.

On top of that, Shopify doesn’t offer their Reporting API to regular stores, only to Plus stores, which are the minority.

The alternative is to pull raw data and do every single calculation from scratch. For example, to calculate total sales, you'll need to pull every single order and then sum up the price for each. You can imagine how it would work for the 35+ fields we had to calculate.

This process may make sense if your core business is a Shopify app. However, for us, if it's just another integration, it makes no sense for it to be so complex.

Anyway, it’s done, give it a try and let me know if you have any questions :)

[Ahmed Ali @A7med_3ly]

Today, I’m excited to roll out a new feature on @SphinxMind : Multi-Account chatting.

With this new feature, users can now aggregate data for multiple accounts or break it down by individual accounts. It’s definitely a must for agencies and businesses managing multiple accounts.

Implementing this feature was challenging, especially when ensuring it was scalable.

In previous projects, I rarely had to worry about querying calculated fields or ratios from marketing platforms, like average session duration or impression share. My approach was straightforward: query the dependent fields and handle the transformations at the end, using SQL or even simply in Excel.

There were 2 approaches to go about this feature:

1- Let the AI handle the aggregation, which would mean training the model on the calculation logic for each field. However, this didn’t seem scalable due to the token size limitations of LLM models.

2- The second approach was to add an aggregation layer across all data sources, which meant updating the schema for every field to include calculation logic. This is the path I went down.

The second approach was our go-to, as it gives us complete control and ensures the accuracy of the data.

Give it a try and let me know your thoughts!

[Sphinx Mind @SphinxMind]

Sphinx Mind is getting smarter 😂

[Ahmed Ali @A7med_3ly]

This app might be the future of marketing!

Meet @SphinxMind – Your AI Marketing Assistant. Chat directly with your marketing data from Google Analytics, Facebook Ads, and more!

Dive into a world where insights are revealed in plain English or your preferred language.

[Ahmed Ali @A7med_3ly]

Excited to announce our new domain: https://t.co/w7YOU6Nt90 - now redirecting to @SphinxMind

This domain reflects our specialized GA4 AI services, aiding in better exposure and easier access for you.

[Sphinx Mind @SphinxMind]

Talk with your GA4 #BigQuery data in plain English without needing SQL knowledge.

You can also view the underlying query and use it in your project.

Sphinx Mind has been trained to understand the nested nature of the #GA4 BigQuery exports and the calculation logic.

[Ahmed Ali @A7med_3ly]

5 months ago, I launched https://t.co/iDSru5eVWp, an SQL query generator tool tailored for GA4 BigQuery tables.

The tool has been widely adopted by many users in the community, reaching 40K generated queries to date.

Today, we mark another significant milestone: the integration of GA4 SQL with https://t.co/ZIUGRhQmwu, which now offers BigQuery support.

Sphinx Mind is optimized for GA4 datasets, allowing you to chat directly with your GA4 BigQuery tables and view the associated queries.

While GA4 SQL will continue to be accessible and free, if you're looking to interact with BigQuery in plain English, Sphinx Mind is your go-to.

[Ahmed Ali @A7med_3ly]

🚀 Big News: Chat with your marketing data directly in Microsoft Teams!

Sphinx Mind's new integration with Microsoft Teams lets you chat and optimize your campaigns without ever leaving your workspace.

Give it a try; we believe you'll love it.

[Ahmed Ali @A7med_3ly]

One of the most important analyses in #SEO is comparing the performance of Branded terms vs. Non-Branded terms. Conducting this manually can be quite time-consuming, as it requires extracting the data, pivoting it, and ultimately, visualizing it.

Now, with AI, you can do this in just a few seconds. Just ask Sphinx Mind, and it will group the data for you and visualize it.

Check out the Brand vs. Non-Brand prompt in our prompts library now!

[Ahmed Ali @A7med_3ly]

Introducing https://t.co/uPoR4xguIC - Your AI Marketing Assistant!

Integrate and chat with your favorite marketing sources like GA4, Facebook Ads, and more.

Receive instant graphs and trend analysis for data-driven decisions.

Try it out now for free!

#ga4 #facebookads