We know managing Pay-Per-Click (PPC) campaigns can be tricky, especially when importing ad data into PPC Ad Editor. To make this process easier PPC Ad Editor has a streamlined workflow for formatting and uploading Excel files so creating, collaborating, and approving PPC ads is a breeze.
Follow this guide and you’ll be more efficient and eliminate common import errors so your campaigns will be set up for success.
Why Proper Formatting Matters
Using the right template when importing Excel files ensures your data matches PPC Ad Editor. Wrong header names or missing required fields can cause import failures delays and frustration. By following these guidelines you can:
Prevent import errors.
Save time on troubleshooting.
Improve the efficiency of your workflow.
Preparing Your Excel Sheets for Import
1. Ensure Proper Header Names
Every sheet in your Excel file must have header names, even if some columns are blank. Missing headers will cause import failures. Some required headers are:
Headlines
Descriptions
Keywords
Site Links
Final URL
Note: Final URL is required. Without a valid URL ads mock-up won’t import or preview.
2. Verify Mandatory Fields and Specific Requirements
Make sure all required fields like Final URL are filled out. Final URL is the base of your ad campaign where ads will be pointing to the landing pages.
Steps to Import Excel Files into PPC Ad Editor
Step 1: Format Your Excel File
Make sure your Excel file has:
Correct header names.
Mandatory fields filled out.
Separate sheets for data elements like headlines, descriptions and keywords.
Step 2: Import the Excel File
Follow these steps to upload your file:
Ad Type: Choose the ad type (e.g. Google Responsive Search Ads).
Data Source: Select “Import from Google Ads CSV File”.
Upload: Select the formatted Excel file and click upload.
Once uploaded, you will see a green progress bar. After that, you can preview your ad mock-up data by clicking Preview.
Troubleshooting Common Import Errors
Incorrect Header Names
If your header names are wrong or missing, the import will fail. For example, if you change the “Ad Group” header to “Ad Grooo,” the import will break.
To fix this:
Check your headers.
Use the template provided by PPC Ad Editor.
Mandatory Fields Missing
Ensure that fields like the final URL are included and properly filled out. Missing mandatory data can result in incomplete previews or failed imports.
Using the Table View Format for Ad Mockups in PPC Ad Editor
If you don’t want to use Excel imports, PPC Ad Editor has a Table View Format that makes data entry easier. This is like the Google Sheets experience but with all the headers and templates included.
Steps to Use Table View Format
Open Table View:
Select ad type (e.g., Google Search Ads).
Choose “Base Data in Table View” as a data source.
Enter or Paste Data:
Fill in manually or copy and paste from your spreadsheet.
Make sure headers line up, or data will get mixed up between fields.
Preview Changes:
Click “Preview” to see live updates on your ad mock-up data.
Save when you’re done.
Pro Tip: When copying data from external sheets, make sure headers in the Table View line up so data fields don’t get mixed up.
Conclusion and Approval Process
Whether you import Excel files or use the Table View Format, formatting and following templates are key to a smooth experience in PPC Ad Editor. Follow these steps to reduce errors, save time, and optimize your PPC campaigns.
Track key interactions like PDF downloads and video engagement and show specific object properties in a readable way. This will engage patients, improve health outcomes, and give you valuable insights to optimize conversions while staying compliant.
For more tips and tools to help with your ad mock-up creation, check out more in PPC Ad Editor. Get started today!
