1. lou x ashley: reports training (2023-03-20 17:46 GMT-4) [FORWARDED THROUGH EMAIL]

    1. What’s Inside?

      1. Weekly Brand Review

        1. Klear slide (clippings + insights - Klear + influencer gsheet)
        2. Veritone slide (veritone yt vid performance + code redemption - veritone reporting gsheet + campaign schedule sheet)

        More step-by-step details on WBR in Weekly Reports Guide

  2. ashley x lou training : bsts (2023-03-30 19:17 GMT-4) [FORWARDED THROUGH EMAIL]

    1. What’s inside?
      1. BAU Campaigns sheet walkthrough [finding campaign decks for the month, creating monthly code & KOL email for BSTs]
      2. Creating monthly gift card codes on Magento (and gift cards in general)
      3. Using Vlookup to find emails/usernames/names
      4. Sending out gift card codes via Mailmerge
      5. KOL Campaign Planning, Outreach & Seeding
      6. Bumping to Post
      7. Placing Orders in Warehouse Sheet
      8. Monthly Outreach for New BSTs
      9. Using Docusign

  3. How To: Create Return Labels [FORWARDED THROUGH EMAIL]

    1. What’s inside?
      1. Creating Return Labels for BSTs returning items
        1. Usually BSTs will return if items are broken/ don’t fit
        2. Note
          1. If they are more than a month, we're unable to accept them
          2. We need the tags to be still attached in order for our warehouse to accept the returns

  4. How To: Create UTMs [FORWARDED THROUGH EMAIL]

    1. What’s inside
      1. Guide on UTM creation
      2. Please input the name of each item in column M (e.g. like in row 974-981)

  5. How To: Create Gift Cards (Media)

    1. What’s inside
      1. Guide on creating gift cards for media personnel

  6. How To: Create Gift Cards (Veritone/BSTs)

    1. What’s inside
      1. Guide on creating gift cards for Veritone influencers/BSTs

  7. How To: File Invoices

    1. What’s Inside
      1. Sample video of filing an invoice

  8. How To: Use Mailmerge & Vlookup

    1. Note: 4:20-4:55 screen is frozen

      1. I am clicking the mail merge sheet/tab I’m currently on which should show below

        1. Click the sheet “&& XXX Month Code Users *&!”

        Screen Shot 2023-09-06 at 15.04.36.png

    2. How to: Warehouse Sheet & Look up orders on Magento

    3. Notes

      1. www.skynetasiapacific.com: Type in tracking number here for tracking link
      2. Screen is frozen after 5:05-5:47, after clicking track shipment, screen below should show. Copy the web page link & that’s the tracking link

    Screen Shot 2023-09-06 at 15.20.45.png

    c. Second part of the video is to look for order details on Magento

    1. How to: Create Docusign
      1. What’s Inside
        1. Creating docusign when onboarding BSTs & in general