Export design studio assets.

A document by KCS Integration on behalf of bac89b007c194479a7573c01f235e47b3ecc2bbb on Jun 20, 2018Last modified by Vishal Sharma on Jun 26, 2018
Version 3Show Document
  • View in full screen mode
Issue Description
I would like to export design studio assets (images and files). Can support do that for me?

Issue Resolution
Unfortunately support doesn't have an option to export design studio assets (images and files). However, when reviewing few community discussions, we were able to see an workaround with the help of a scraper chrome extension and Excel. It looks like the entire process takes about 10 minutes. We would also like to mention that this isn't recommended by Marketo support and support will not be able to assist you on this if you face any error. 


Here's what you'll need

  • Google Chrome

  • Scraper Chrome Extension - Download

  • Microsoft Excel ***With the developer tab enabled*** - Learn how to enable the developer tab here


Step 1

  • Download and install the scraper chrome extension.


Step 2

  • Log into marketo and go into the design studio.

  • Click on Images and Files to display your asset library

  • Then click on this button to open your library in it's own window.

 User-added image

Step 3

  • With the new window open, right-click in the white space to the right of your list of assets and select "Scrape similar..."


  • Set the selector options in the scraper tool to the following and the click the "Scrape" button. You should see a list of all your asset file names on the right side of the scraper tool. Click on "Copy to clipboard" and paste the file names into column A in your spreadsheet.


    **Note the scraper will only copy the file names that are visible on that page so you will have to repeat the Scrape / Copy / Paste process for every page of assets that you have.** 



    Step 4

  • After you've successfully completed Step 3, tidy up your spreadsheet to remove all the cells that don't contain a file name.


    Step 5

  • In Excel we'll use a Concatenate function to prepend your marketo URL path to all of your file names. 

    Example: "http://info.yourdomain.com/rs/555-ABC-777/images/"


  • In cell B1 type =CONCATENATE("insert your url path here", A1 then press ENTER. You should now see the complete URL path and file name.

    Example: "http://info.yourdomain.com/rs/555-ABC-777/images/header.jpg"

  • Select cell B1 and click the little square handle in the bottom right corner of the cell and drag it down to the bottom of your list which will apply the formula to the rest of your list.


  • Now select / copy (Ctrl+C) everything in column B, then right-click cell A1 and choose "Paste Values".


  • Delete all contents from column B and you should be left with all of the URLs to all of your image assets in column A.


    Step 6

  • Create a folder on your C: drive or somewhere on your computer that you want to save all of your assets from Marketo

    Example: "C:MyImages"


    Step 7 - This is where the magic happens

  • In the Developer tab click on Visual Basic


  • In the Visual Basic window navigate to Insert > New Module


  • Write the following Macro script into the Module window. 

    **Be sure to replace all of the highlighted areas with the path to the folder you created in Step 6.

    **Also be sure to change the number circled in red with the total number of URLs in your spread sheet


  • Click File > Save, name your file and **be sure to change "Save as type" to Excel Macro-Enabled Workbook** and close out of Visual basic.


    Step 8

  • Go back to the developer tab in your spreadsheet and click on Macros


  • Select the Macro that you just created and click Run. If you typed the script correctly Excel will begin to download all of the files in your spread sheet to the folder that you specified and alert you when the download is complete.

Who This Solution Applies To

Is this article helpful ?