How have others used custom GPTs to analyze data? Although this feature is new (November 2023).I've begun discovering how I can include a custom GPT in my A/B testing workflow: https://chat.openai.com/g/g-tBOqWs4ff-a-b-testing-assistant We use Target and Analytics for Target reporting and although I...

Dude, it worked.I knew that Cume average would be clutch; it's the same formula I've used for rolling averages. I must have not used enough containers, ha!I'm going to read a bit more on the function, but I'll be able to apply this in SO MANY ways now.Great work!

I'd like to build a freeform table that returns the percentage change from the prior period in the table.Expected results would be something like my screenshot below that shows the Week period in rows and then the Visits metric as a field. The custom metric would then show the percentage lift or fal...

I'm working through the calculated metric builder now; I'll admit my experience utilizing functions in Adobe is pretty basic - although I can create custom metrics/segments without much trouble. I find making DAX measures and M code in Power BI much easier - but glad to stretch a bit!Q: When you ref...

Hey Jennifer, thanks so much in advance! Regarding calculating Change in percent Demand, you are correct - I'll simply compare the difference between volumes use appropriate date ranges ( xx days before promo period, xx day promo, xx days following promo period). I'll do this for Carts, Checkouts, O...

I'm building a promotion performance workspace for my customers and would love to include data that calculates the Price Elasticity of Demand (PED) during the promotion period. I'd most likely break it down by category and product, but that's secondary to just getting it to work overall. My preferen...

In a project, I use a dropdown filter of Product Categories to filter metrics in a table such as Carts, Orders, Cart Rate, etc. However, when filtering by category in the panel, the Cart Rate (Carts/Unique Visitors) seems inaccurate from what I'm expecting. How can I create a formula that considers ...

Thanks so much for the help so far! It's bonkers to me that this solution seems so complex in AA; I've been an advocate of the tool since the Omniture days - but some things are just easier to export data and do in Excel. Sigh . .  Because our org is transitioning much of our manager-facing reportin...

Thanks, Jennifer, We have a pretty standard implementation. When a purchase even occurs we generate an external Order ID, the quantity and product purchased, and the revenue of that item.The example below shows an Order ID that has 14 items in the basket for an order total of $4,161. Of these items,...

I can't believe it's almost been a year, but this request has come up again so I'd love to get it resolved. I don't have a reliable promo code evar, so need to go another route please. I'm able to get the data I need in a freeform table, but then end up exporting and doing it in Excel. I'd like to e...