A few months ago, I reached out to one of our manufacturers to get their products’ information in a spreadsheet form.
Our sales rep came through with the spreadsheet but there were a few caveats. He sent 2 spreadsheets with one having all the product data and another with the the product name and sku. The problem was that I need the sku to be with the product data so I can connect the information together and pull our customer pricing from our internal program that we use.
So after I looked at the spreadsheets, I see that the spreadsheets are from the media company that set up the website. I don’t know what website platform the site is one, but the products on both sheets share a Product ID that the website.
The Product ID on both spreadsheet is the only data that matches the SKU on one spreadsheet to the Product Information on the other Spreadsheet.
From our internal program, the SKU is the only product data that will match to the manufacturer’s products that need to put on our website.
This isn’t a problem.
Use the Match and Vlookup formulas in Excel to match the SKU from one spreadsheet to the Product Information and pull the information into one spreadsheet. Then I’ll use the same formulas to match our customer pricing to the spreadsheet.
This will condense the original 3 spreadsheets into 1 spreadsheet.
From there I’ll take that spreadsheet and map the product information to the website import spreadsheet. Upload it and all of the products will be there.
This doesn’t include product pictures or additional information that I’ll upload later. For those, I’ll have a different process.
To make make changes to the product photos I’ll create a script to do it automatically in a program that’s similar to Photoshop. I don’t use Adobe Photoshop at work. (Don’t ask why, it’s complicated.) I use an open-source program that does what I need and then-some. Gimp is similar to Photoshop, the tools and functionality are the same, just the steps are a bit different and the tool are located in different places.
I started a course with Google this previous Monday called YouTube Creative Essentials.
I am about halfway through the course at the moment.
So far I’m liking and enjoying the material. Overall, the course is a good refresher and adds the latest best practices in digital marketing.
The goal is to have the YouTube Creative Essentials course completed this weekend.
After passing the YouTube Creative Essentials Assesment:
- Write a review on the YouTube Creative Essentials.
- Taking the subject matter into the workplace.
There is also an additional eStudy that is highly specific on YouTube, video creation, video production etc that is next on the list.
After College and Now
After receiving a text from a past coworker, my mind started to reflect on my college experience as a non-traditional student. A non-traditional student is one that attends college after the normal years of late teens and early twenties. Let me tell you, as a non-traditional student, working and with a family, it certainly wasn’t easy.
This was my second degree. The first college that I attended, The Art Institute of Atlanta, was during traditional college age years.
Both are quite different college experiences, but I’m glad that I have the perspective of both.
One-Year After Graduation
Since graduating, there have been ups and downs, to say the least. Within this time frame, there have been quite a few changes on the home and work front. I’m not going to get into the details of each, but I am an advocate of learning from the past and using those experiences to move forward.
Decisions have been made with and without my direct choice. Either way, the end is the same, it’s how I personally manage the outcome and progress from them.
Even though I graduated, schooling has yet ceased to stop. In the past few months, I have been refreshing my knowledge in Google Analytics or GA for short through the Google Analytics Academy. The four provided courses covering fundamental and advanced GA, eCommerce and Tag Manager.
The overall goal is to obtain my Google Analytics Certification.
Overall, I never plan to stay stagnant in knowledge. As a marketer, I have to stay on top of the digital world from a technology standpoint.
My philosophy is Absorb, Process, Conquer, Learn and Repeat.
My professional or career mission is finding the intersections, correlations, and cornerstones between businesses and their customers through technology usage.
Sounds pretty simple, eh?
It can be a bit complicated at times, but both the philosophy and professional objective are used as guiding points through life’s journey – with coffee in hand of course!