locked
Anyone imported Ad words campaign? RRS feed

  • Question

  • Did anyone had luck importing adwords campaign?
    I tried for some time (by using adwords editor export), but nothing worked...

    Sunday, September 9, 2007 1:17 AM

Answers

  • Importing a Google Campaign into adCenter

     

    1.      From within the Google account, click the Reports tab.

    2.      Click Create a Report Now located at the top-left of the screen.

    3.      In the 1. Report Type section, select Ad Performance.

    4.      In the 2. Settings section, make the following selections:

    ·        For Ad Variations, click Text Ad

    ·        For View (unit of time), select Summary

    ·        For Date Range, click All Time

    ·        In the Campaigns and Ad Groups field, manually select from a list and select the appropriate campaign from the column on the left, and then click Add to move it to the column on the right

    5.      In the 3. Advanced Settings (Optional) section, select Add or Remove Columns and select the following:

    ·        For Level of Detail, ensure that only the following are selected:

    o Campaign

    o Ad Group

    o Keyword

    o Ad ID (this is required for this Google report type)

    ·        For Attributes, ensure that only the following are selected and deselect all others:

    o Display URL

    o Destination URL

    o Headline

    o Description Line 1

    o Description Line 2

    o Keyword Matching

    o Keyword Destination URL

    o Current Maximum CPC

    ·        For Performance Statistics, select CTR (one option MUST be selected here, and this category generates minimal data)

    6.      Click Filter Your Results. In the drop-down menu on the left, select Ad Distribution. In the drop-down menu on the right, select Search.

    7.      In the 4. Templates, Scheduling, and Email section, enter an appropriate name for the report (in the Name Your Report field), and then click Create Report.

    Note: When walking a customer through this process, you can request that they select the Whenever the report runs, send email to: option (next to Email) and have them enter your e-mail address in the field provided so that a copy of the file is sent to you for reference if further assistance is necessary.

    8.      On the Report: Ad Report page, (under Download Report), click csv.

    9.      In the File Download window, click the Open button. This will populate the report to any recognized spreadsheet application or a text editor.

    Note: The user may safely delete rows 1-5 and columns A and B (in these rows. Row 6 contains the headings for the data in the remaining cells. The last row can also be disregarded.

    Note: If the customer is using the Google version of Dynamic text {KeyWord: Contact Center}, they will have to edit the text to look like {KeyWord} to have it import and be functional.

    10. From within the customer account in the adCenter Beta site, click the Campaigns tab, click Import Campaigns, and then click Microsoft Excel File or CSV file.

    11. In the File Download window that launches, click the Save button. In the File Name field, enter the name of the campaign that you’re importing, choose the appropriate destination for the save location, then click the Okay button.

    12. With the newly created export CSV file opened in Excel (or a compatible spreadsheet application), open the adCenter import file that you saved in step 2.

    13. Transfer the information from the Google account in the export CSV file into the adCenter import file.

    Note Many, but not all, of the columns correspond between these two files. Locate the column in the adCenter import file that needs a specific piece of data, find the corresponding column in the export CSV file, then copy and paste from the export CSV file to the appropriate location in the adCenter import file. Once all of the information has been transferred, save the changes to the adCenter import file.

    14. To create the new campaign, in https://beta.adcenter.microsoft.com, specify the region and the language for the campaign in the drop-down menu displayed (item number 2. on the page).

    Important: THE ADVERTISER MUST select the correct distribution; the default is set to English - Canada and once this has been accepted, it cannot be altered. The campaign must be deleted and re-created if it is set incorrectly.

    15. Click Choose the file to import. You will have the option to select the file that you want to import – browse to and select the adCenter import file that you’ve transferred the CSV data into (in step 13). Click Open and the file is then imported.

    Note Once the file has been imported, the new campaign should be displayed in the customer’s account. All of the standard set-up options must still be attended to (defining a budget and base bid and adjusting other settings).

     

    Note: close the file to be imported before importing, file cannot be larger than 2mb .csv (import in chunks if necessary). The completed import will be in draft mode, run through each adgroup to confirm budget/bid settings are basically correct.

    Tuesday, September 18, 2007 1:19 PM
  • Just want to add a couple things here - as dr mcgarry points out, you do need to export your campaign through the reporting interface in the UI as opposed to the AdWords Editor export. We are working on supporting the AdWords Editor export and we'll keep you posted here when we have an ETA.

     

    Also, in our last release we improved the import functionality so that you no longer have to copy and paste the UI export into the adCenter template (step #13 in dr mcgarry's post above). As long as the column headers match, you can import the file, and adCenter will disregard any unnecessary columns. Here are the relevant Help topics:

     

    Export campaigns from Google AdWords.

    Import campaigns.

     

    I hope this helps.

    Thanks,

    Carolyn

     

    Thursday, September 27, 2007 8:03 PM

All replies

  • Importing a Google Campaign into adCenter

     

    1.      From within the Google account, click the Reports tab.

    2.      Click Create a Report Now located at the top-left of the screen.

    3.      In the 1. Report Type section, select Ad Performance.

    4.      In the 2. Settings section, make the following selections:

    ·        For Ad Variations, click Text Ad

    ·        For View (unit of time), select Summary

    ·        For Date Range, click All Time

    ·        In the Campaigns and Ad Groups field, manually select from a list and select the appropriate campaign from the column on the left, and then click Add to move it to the column on the right

    5.      In the 3. Advanced Settings (Optional) section, select Add or Remove Columns and select the following:

    ·        For Level of Detail, ensure that only the following are selected:

    o Campaign

    o Ad Group

    o Keyword

    o Ad ID (this is required for this Google report type)

    ·        For Attributes, ensure that only the following are selected and deselect all others:

    o Display URL

    o Destination URL

    o Headline

    o Description Line 1

    o Description Line 2

    o Keyword Matching

    o Keyword Destination URL

    o Current Maximum CPC

    ·        For Performance Statistics, select CTR (one option MUST be selected here, and this category generates minimal data)

    6.      Click Filter Your Results. In the drop-down menu on the left, select Ad Distribution. In the drop-down menu on the right, select Search.

    7.      In the 4. Templates, Scheduling, and Email section, enter an appropriate name for the report (in the Name Your Report field), and then click Create Report.

    Note: When walking a customer through this process, you can request that they select the Whenever the report runs, send email to: option (next to Email) and have them enter your e-mail address in the field provided so that a copy of the file is sent to you for reference if further assistance is necessary.

    8.      On the Report: Ad Report page, (under Download Report), click csv.

    9.      In the File Download window, click the Open button. This will populate the report to any recognized spreadsheet application or a text editor.

    Note: The user may safely delete rows 1-5 and columns A and B (in these rows. Row 6 contains the headings for the data in the remaining cells. The last row can also be disregarded.

    Note: If the customer is using the Google version of Dynamic text {KeyWord: Contact Center}, they will have to edit the text to look like {KeyWord} to have it import and be functional.

    10. From within the customer account in the adCenter Beta site, click the Campaigns tab, click Import Campaigns, and then click Microsoft Excel File or CSV file.

    11. In the File Download window that launches, click the Save button. In the File Name field, enter the name of the campaign that you’re importing, choose the appropriate destination for the save location, then click the Okay button.

    12. With the newly created export CSV file opened in Excel (or a compatible spreadsheet application), open the adCenter import file that you saved in step 2.

    13. Transfer the information from the Google account in the export CSV file into the adCenter import file.

    Note Many, but not all, of the columns correspond between these two files. Locate the column in the adCenter import file that needs a specific piece of data, find the corresponding column in the export CSV file, then copy and paste from the export CSV file to the appropriate location in the adCenter import file. Once all of the information has been transferred, save the changes to the adCenter import file.

    14. To create the new campaign, in https://beta.adcenter.microsoft.com, specify the region and the language for the campaign in the drop-down menu displayed (item number 2. on the page).

    Important: THE ADVERTISER MUST select the correct distribution; the default is set to English - Canada and once this has been accepted, it cannot be altered. The campaign must be deleted and re-created if it is set incorrectly.

    15. Click Choose the file to import. You will have the option to select the file that you want to import – browse to and select the adCenter import file that you’ve transferred the CSV data into (in step 13). Click Open and the file is then imported.

    Note Once the file has been imported, the new campaign should be displayed in the customer’s account. All of the standard set-up options must still be attended to (defining a budget and base bid and adjusting other settings).

     

    Note: close the file to be imported before importing, file cannot be larger than 2mb .csv (import in chunks if necessary). The completed import will be in draft mode, run through each adgroup to confirm budget/bid settings are basically correct.

    Tuesday, September 18, 2007 1:19 PM
  • Just want to add a couple things here - as dr mcgarry points out, you do need to export your campaign through the reporting interface in the UI as opposed to the AdWords Editor export. We are working on supporting the AdWords Editor export and we'll keep you posted here when we have an ETA.

     

    Also, in our last release we improved the import functionality so that you no longer have to copy and paste the UI export into the adCenter template (step #13 in dr mcgarry's post above). As long as the column headers match, you can import the file, and adCenter will disregard any unnecessary columns. Here are the relevant Help topics:

     

    Export campaigns from Google AdWords.

    Import campaigns.

     

    I hope this helps.

    Thanks,

    Carolyn

     

    Thursday, September 27, 2007 8:03 PM
  • I just wanted to reply thanking you for taking the steps to figure this out. However the is a problem with your instructions

    You specify to delete columns A and B... and I don't understand why because those are important fields. Anyways, after creating the google report per your instrcutions, I came up with a solution that did not require copying and pasting from one excel/csv to another. Simply open your google report in Excel and press Alt+F11 (Visual Basic Editor). In the Project Pane on the left, Right click on some white space and choose, Insert>Module. In the code window that pops up, copy and paste the code below. By default, excel does not use word wrap, but if for some reason you paste and it doesn't count each comment on it's own line, then you need to make sure you a)delete the comments, or b) make sure the comments start with an apostrophe '

    To run the macro, you can click the Play button on the Visual Basic Editor, or you can close out the VB editor and when you are back at the excel sheet view, press Alt+F8
    Then press run while the macro "ConvertAdwords" is selected.



    Sub ConvertAdwords()
    '
    ' ConvertAdwords Macro
    ' Macro recorded 10/4/2007 by  robbieb@gmail.com This macro converts a Google AdWords report into a working Microsoft Adcenter file (Follow this URL to create the Google Report http://forums.microsoft.com/AdCenter/ShowPost.aspx?PostID=2115020&SiteID=44)
    '
    ' Delete Rows 1-5
    '
    ' Rearrange columns...
    ' Cut, column J "Current Maximum CPC" Insert into column E
    ' Cut, column K " Keyword Destination URL" Insert into column F
    ' Delete Column K (Column L "Destination URL" becomes column K)
    ' Delete Column L

    '
        Application.WindowState = xlNormal
        Application.Left = 10
        Application.Top = 35.5
        Application.Width = 767.25
        Application.Height = 585
        Rows("1:5").Select
        Selection.Delete Shift:=xlUp
        Columns("J:J").Select
        Selection.Cut
        Columns("E:E").Select
        Selection.Insert Shift:=xlToRight
        Columns("K:K").Select
        Selection.Cut
        Columns("F:F").Select
        Selection.Insert Shift:=xlToRight
        Columns("K:K").Select
        Selection.Delete Shift:=xlToLeft
        Columns("L:L").Select
        Selection.Delete Shift:=xlToLeft
       
    ' Delete the very last row
    With ActiveSheet
       .Cells(.Rows.Count, "A").End(xlUp).EntireRow.Delete
    End With

    End Sub

    Thursday, October 4, 2007 8:37 PM
  • I followed the instructions, but where or how do I get the template, I found no mention of how to get it in the help center search. I have a google file as per the instructions, but the import still does not work. If I saw the template I could see why the info does not fully import. Below are the colum headers of my exported spreadsheet.

     

    Thanks,

    Bob

     

     

    Campaign Ad Group Keyword Keyword Matching Keyword Status Headline Description Line 1 Description Line 2 Display URL Ad Id Ad Status Daily Budget Current Maximum CPC Keyword Destination URL Ad Group Status Destination URL Campaign Status
    Thursday, October 11, 2007 5:42 PM
  • Code Block
    Code Block

    [quote'>http://saadsamah.com/">[quote user="partners95"]

    I'>http://saadsamah.com/">I followed the instructions, but where or how do I get the template, I found no mention of how to get it in the help center search. I have a google file as per the instructions, but the import still does not work. If I saw the template I could see why the info does not fully import. Below are the colum headers of my exported spreadsheet.

     

    Thanks,142-42409681-2396-46A8-EB75-94F400A8BC9D

    http://saadsamah.com/">Thanks,142-42409681-2396-46A8-EB75-94F400A8BC9D

    <P< A>align=left>Bob

    http://saadsamah.com/">Bob

    <P< A>align=left> 

     

    http://saadsamah.com/"> <COL< A>style="WIDTH: 48pt" width=64> http://saadsamah.com/">Campaign<TD< A> style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 119pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=158>Ad'>http://saadsamah.com/">Ad Grouphttp://saadsamah.com/">Keyword<TD< A> style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=64>Keyword'>http://saadsamah.com/">Keyword Matchinghttp://saadsamah.com/">Headline<TD< A> style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 130pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=173>Description'>http://saadsamah.com/">Description Line 1
    Campaign Keyword Keyword'>http://saadsamah.com/">Keyword Status Headline Description'>http://saadsamah.com/">Description Line 2 Display'>http://saadsamah.com/">Display URL Ad'>http://saadsamah.com/">Ad Id Ad'>http://saadsamah.com/">Ad Status Daily'>http://saadsamah.com/">Daily Budget Current'>http://saadsamah.com/">Current Maximum CPC Keyword'>http://saadsamah.com/">Keyword Destination URL Ad'>http://saadsamah.com/">Ad Group Status Destination'>http://saadsamah.com/">Destination URL Campaign'>http://saadsamah.com/">Campaign Status

    http://saadsamah.com/">

    <P< A>align=left> 

     

     

    Wednesday, October 31, 2007 11:07 AM