Expand my Community achievements bar.

philliptrost
philliptrost
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • 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...

    Type

    Questions

    Views

    264

    Likes

    0

    Replies

    1
  • 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!

    Type

    Questions

    Views

    859

    Like

    1

    Replies

    1
  • 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...

    Type

    Questions

    Views

    917

    Likes

    0

    Replies

    6
  • 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...

    Type

    Questions

    Views

    396

    Likes

    0

    Replies

    0
  • 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...

    Type

    Questions

    Views

    410

    Likes

    0

    Replies

    0
  • 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...

    Type

    Questions

    Views

    449

    Likes

    0

    Replies

    4
  • 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 ...

    Type

    Questions

    Views

    237

    Likes

    0

    Replies

    1
  • 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...

    Type

    Questions

    Views

    574

    Like

    1

    Replies

    1
  • 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,...

    Type

    Questions

    Views

    589

    Likes

    0

    Replies

    3
  • 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...

    Type

    Questions

    Views

    618

    Likes

    0

    Replies

    5
Top badges earned by philliptrost
Customize the badges you want to showcase on your profile