Edit product
Your Cart
    Subtotal

    Is this your street address?

    Card

    ···· ···· ···· 4242
    Test card

    05/18

    Card

    Use a different card?

    Card

    pp paypal

    or pay with

    We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

    or pay with

    Please confirm your location:
    You'll be charged .

    Your purchase was successful!

    We charged your card and sent you a receipt

      Gumroad Library

      Download from the App Store or text yourself a link to the app

      €149

      AdWords MCC Account(s) Dashboard

      What does it do?

      The Script show percentual differences between two Periods,

      for all Campaings of a Customer within an AdWords MCC Account per each labeled account.

      That means: If you have 4 accounts in your MCC, you'll receive 4 sheets that list all the campaigns.

      The Formular this is calculated on is for most of the values:

      (value_current_period / value_past_period) - 1 = percentual_change

      CostofSales:

      (cost_current / conversionValue_current) / (cost_past / conversionValue_past)= percentual_change

      CostOfSalesMerged is a little different:

      (cost / (conversionValue + clickAssistedConversionsValue + impressionAssistedConversionValue)) = value_current_period

      (cost / (conversionValue + clickAssistedConversionsValue + impressionAssistedConversionValue)) = value_past_period

      (value_current_period / value_past_period) - 1 = percentual_change

      Period to Watch:

      The default period is 30 days. The default period can be adjusted in with the "defaultDays" variable.

      After the first script run for an account, this value will be taken automatically.

      If you want to adjust the period later, for a single account,

      please change the value in the specific Customer-Dashboard.

      Output Values:

      Campaign Name, Impressions, Clicks, AverageCpc, Cost, CostOfSales, CostOfSalesMerged, Conversions, ConversionRate, CostPerAquisition, Position, Time on Page, Bounce Rate, Ctr

      Language:

      The Dashboard was designed for english Audience.

      If you plan on using it for another language, habe a look around line 15 adjust the string variables there to match your language.

      Tip:

      You can share single sheets within the spreadsheets individually. So it is possible to give client access to each single dashboard if you like.

      Installation:

      1. Go to you AdWords MCC under Bulk operations > Scripts

      2. Open a new Script with the "+ Script" Button.

      3. Copy & Paste all lines of the script.txt document wich is content of this zip.

      4. Create a new google Spreadsheet.

      5. Insert the spreadsheet url where it says: INSERT_SPREADSHEET_URL_HERE

      6. Adjust the Label Name for the accounts taken into the Dashboard. Standard Label is "AdWords Dashboard"

      7. Set the Label for all Accounts that should be monitored.

      8. Run the Script.

      You've purchased this product

      See it in your library

      View in Library
      Sorry, this item is not available in your location.
      Sold out, please go back and pick another option.

      Checkout

      AdWords MCC Account(s) Dashboard

      Enter your info to complete your purchase

      Card

      ···· ···· ···· 4242
      Test card

      05/18

      Card

      Use a different card?

      Card

      pp paypal

      or pay with

      We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

      or pay with

      Please confirm your location:
      You'll be charged US$168.16.

      Your purchase was successful!

      We charged your card and sent you a receipt

        Gumroad Library

        Download from the App Store or text yourself a link to the app

        Good news! Since you already have a Gumroad account, it's also been added to your library.

        Powered by Gumroad