Export Design Studio Assets

Issue

You would like to export design studio assets (images and files) in bulk. 
 

Solution

Support doesn't have an option to export design studio assets (images and files). However, there is a third-party option with the help of a Scraper Chrome extension and Excel. 

Because this is a third party product, Marketo support will not be able to assist you with this. This information is provided to assist you in finding outside resources.

 

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..."

        scrape-capture.jpg
       
      • 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.

        scraper.JPG

        **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.** 

        pages.JPG
      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

        visual-basic.JPG
      • 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

        MacroScript.JPG
       
      • 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

        macrosbutton.JPG
       
      • 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.